The book covers such topics as:
- Writing complex queries
- Building more complex types of data structures.
- Techniques for improving application speed and performance.
- Advanced scripting and error handling.
- Advanced methods for handling stored procedures.
- SQL cursors
- XML and XQuery support
- Reporting and Data Transformation Services
- Replication
- Security and Performance Tuning
- Advanced database design
Chapter 1 Being Objective: Re-Examining Objects in SQL Server
Chapter 2 Tool Time
Chapter 3 Basic T-SQL
Chapter 4 Creating and Altering Tables
Chapter 5 Reviewing Keys and Constraints
Chapter 6 Asking a Better Question: Advanced Queries
Chapter 7 Daring to Design
Chapter 8 SQL Server- -Storage and Index Structures
Chapter 9 Views
Chapter 10 Scripts and Batches
Etc.