Chapter 1: SQL Server 2000 – Particulars and History.

Chapter 2: RDBMS Basics: What Makes Up a SQL Server Database?

Chapter 3: Tools of the Trade.

Chapter 4: The Foundation Statements of T-SQL.

Chapter 5: Joining Tables.

Chapter 6: Creating and Altering Tables.

Chapter 7: Constraints.

Chapter 8: Normalization and Other Basic Design Issues.

Chapter 9: SQL Server Storage and Index Structures.

Chapter 10: Views.

Chapter 11: Writing Scripts and Batches.

Chapter 12: Stored Procedures.

Chapter 13: User Defined Functions.

Chapter 14: Transactions and Locks.

Chapter 15: Triggers.

Chapter 16: Advanced Queries.

Chapter 17: Distributed Queries and Transactions.

Chapter 18: SQL Cursors.

Chapter 19: A Brief XML Primer.

Chapter 20: Integration of XML into SQL Server.

Chapter 21: The Bulk Copy Program (bcp).

Chapter 22: Introduction to Data Transformation Services.

Chapter 23: Replication.

Chapter 24: Advanced Design.

Chapter 25: Analysis Services.

Chapter 26: Full-Text Search.

Chapter 27: English Query.

Chapter 28: Security.

Chapter 29: Performance Tuning.

Chapter 30: Administration Overview.

Chapter 31: Advanced DTS.

Chapter 32: Scripting Administrative Functions with WMI.

Appendix A: System Functions.

Appendix B: Function Listing.

Appendix C: Tools for Our Time.

Appendix D: Access Upsizing.

Appendix E: Microsoft Data Transformation Services Package Object Library Reference.

Index.