Overview of Microsoft SQL Server -- Installing and configuring SQL Server 2008 -- Using the tools in SQL Server 2008 -- Creating databases -- Designing tables -- Indexes -- Partitioning -- Data retrieval -- Advanced data retrieval -- Data manipulation -- Views -- Stored procedures -- Functions -- Triggers -- Database snapshots -- Service broker -- Full-text indexing -- Security -- Policy-based management -- Data recovery -- SQL server agent -- Dynamic management views -- High availability -- SQL server integration services -- SQL server reporting services -- SQL server analysis services