Beginning SQL Server 2008 Programming

Description

* 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 database

CONTENTS:

Introduction.

  
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.

  
Index.