For three days last week I attended a Microsoft training course at Dimension Data Learning Services in St. Kilda (thanks boss for paying for this!)
The course was 2779 Implementing a Microsoft SQL Server 2005 Database. The official curriculum covered: creating databases; data types; creating tables, views, stored procedures and functions; indexes and index tuning; XML; managed code (VB.NET or C# in the database, although we didn't cover creating the code, just implementing an assembly); and Service Broker.
Along with 3 days of tutorial time, we also got a huge handbook and CD with course materials. The 9 topics were delivered...