I took the SQL Server 2005 Dev and Admin course. It was a very high level introduction to 2005 (I know at the time, they offered courses that covered specfic topics in more depth). it was a week long course where there was lecture and labs. The labs had the following topics:

-installing SQL Server 2005

-Creating and managing databases

-SQL Management Objects

-Creating Stored procedures and Views

-working with XML data

-Implementing Full-Text indexes

-implementing security

-Database backups and mirroring

-Monitoring SQL servers

-Configuring replication

-working with SQL server integration services

-using analysis services

-creating reports and report models

-creating a notification service

-working with service broker