| Introduction.
Part I: Get Started Using the SQL Server 2005 Development Environment.
Chapter 1: The Joy of SQL Server 2005 Programming.
Chapter 2: Understanding Database Fundamentals.
Chapter 3: Getting to Know the SQL Server Toolset.
Part II: Retrieving Data Using Transact-SQL.
Chapter 4: Retrieving Data Using the SELECT Statement.
Chapter 5: Creating Joins.
Chapter 6: Creating Advanced Queries.
Chapter 7: Manipulating Data.
Part III: Creating Databases and Database Objects with Transact-SQL.
Chapter 8: Designing, Creating, and Altering Database Objects.
Chapter 9: Designing, Creating, and Changing Tables.
Chapter 10: Applying Constraints.
Chapter 11: Creating Views.
Chapter 12: Using Stored Procedures.
Chapter 13: Using Triggers.
Chapter 14: Creating Functions.
Chapter 15: Creating Indexes.
Chapter 16: Handling Errors Using TRY . . . CATCH.
Part IV: Programming SQL Server Security.
Chapter 17: Adding Logins and Users.
Chapter 18: Creating Database-Level Security.
Chapter 19: Securing Data Using Encryption.
Part V: Beyond Transact-SQL Programming.
Chapter 20: Working with XML.
Chapter 21: Working with the Common Language Runtime.
Chapter 22: Using Visual Studio 2005.
Chapter 23: Working with SQL Server Management Objects.
Part VI: The Part of Tens.
Chapter 24: Ten Tips to Program Like a Pro.
Chapter 25: Ten Sources for More Information on SQL Server 2005.
Index.
| 
