This comprehensive introduction to SQL Server begins with an overview of
database design basics and the SQL query language along with an in-depth
look at SQL Server itself. Progresses on to a clear explanation of how to
implement fundamental concepts with the new 2008 version of SQL Server.
Discusses creating and changing tables, managing keys, writing scripts,
working with stored procedures, programming with XML, using SQL Server
Reporting and Integration Services, and more. Features updated and new
material, including new examples using Microsoft's AdventureWorks sample
Table Of Contents:
Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?
Chapter 2: Tools of the Trade
Chapter 3: The Foundation Statements of T-.
Chapter 4: JOINs.
Chapter 5: Creating and Altering Tables.
Chapter 6: Constraints.
Chapter 7: Adding More to Our Queries.
Chapter 8: Being Normal: 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: A Brief XML Primer.
Chapter 17: Reporting for Duty, Sir! A Look At Reporting Services.
Chapter 18: Getting Integrated with Integration Services.
Chapter 19: Playing Administrator.
Appendix A: System Functions.
Appendix B: Very Simple Connectivity Examples.