Part I Design Fundamentals and Core Technologies
1 Overview
2 Exploring the T-SQL Enhancements in SQL Server 2005
3 An Overview of SQL CLR
4 XML and the Relational Database
5 Introducing SQL Server Management Studio
6 Using SQL Server Management Objects (SMO)
7 SQL Server 2005 Security

Part II Applications Development and Reach Technologies
8 ADO.NET 2.0, Typed DataSet Objects, and .NET Data Binding
9 Debugging
10 SQL Server 2005 Native XML Web Services
11 Transactions
12 SQL Server Service Broker: The New Middleware
13 Using SQL Server 2005 Notification Services
14 Developing Desktop Applications with SQL Server Express Edition
15 Developing Applications with SQL Server 2005 Everywhere Edition
and SQL Server Merge Replication

Part III Reporting and Business Intelligence
16 Using SQL Server 2005 Integration Services
17 Basic OLAP
18 Advanced OLAP
19 OLAP Application Development
20 Extending Your Database System with Data Mining
21 Reporting Services