Beginning Microsoft SQL Server 2008 Programming

Robert Vieira

ISBN: 978-0-470-25701-2

Paperback

720 pages

January 2009

Size : 13.86MB

• 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.

Link
Beginning Microsoft SQL Server 2008 Programming