Part 1: Introducing SQL Server.

Chapter 1: Introduction to SQL Server 2005.

Chapter 2: Overview of Database Concepts.

Chapter 3: Overview of SQL Server.

Chapter 4: Database Design and Normalization.

Part 2: Transact-SQL.

Chapter 5: Transact-SQL Overview and Basics.

Chapter 6: SELECT Queries.

Chapter 7: Action Queries.

Chapter 8: Topics in Advanced Transact-SQL.

Part 3: Digging into SQL Server.

Chapter 9: Using SQL Server Management Studio.

Chapter 10: Databases.

Chapter 11: Tables.

Chapter 12: Indexing.

Chapter 13: Views.

Chapter 14: Stored Procedures.

Chapter 15: Using Triggers.

.Part 4: Administering SQL Server.

Chapter 16: Basic Administrative Tasks.

Chapter 17: Automating Administration.

Chapter 18: Security and SQL Server 2005.

Part 5: Development with SQL Server.

Chapter 19: Integrating SQL Server with Microsoft .NET.

Chapter 20: ADO.NET and SQL Server.

Chapter 21: SMO and RMO Programming.

Chapter 22: Integration Services.

Part 6: Advanced Topics.

Chapter 23: Locking.

Chapter 24: Monitoring and Optimizing SQL Server 2005.

Chapter 25: Replication.

Chapter 26: Analysis Services.

Chapter 27: Notification Services.

Chapter 28: Reporting Services.

Chapter 29: Service Broker.

Chapter 30: Troubleshooting.

Appendix A: Transact-SQL Reference.

Index.