Beginning Sql Server 2005 Programming

Beginning SQL Server 2005 Programming provides a comprehensive introduction to SQL Server. The book begins with a quick overview of database design basics and the SQL query language, for those programmers who may be building their first Microsoft database application. It also provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release. The author then proceeds to show how to implement these fundamental concepts with Microsoft SQL Server 2005. The book's appendixes provide a collection of useful reference material, and the book's companion site provides all of the code found in the book. The book is designed to complement the authors' bestselling Wrox book, Professional SQL Server 2005 Programming.

Table of contents :
Introduction
· RDBMS Basics: What Makes Up a SQL Server Database?
· Tools of the Trade
· The Foundation Statements of T-SQL
· JOINs
· Creating and Altering Tables
· Constraints
· Adding More to Our Queries
· Being Normal: Normalization and Other Basic Design Issues
· SQL Server Storage and Index Structures
· Views
· Writing Scripts and Batches
· Stored Procedures
· User Defined Functions
· Transactions and Locks
· Triggers
· A Brief XML Primer
· Reporting for Duty, Sir!: A Look At Reporting Services
· Getting Integrated With Integration Services
· Playing Administrator
Appendix A: Exercise Solutions
Appendix B: System Functions
Appendix C: Finding the Right Tool
Appendix D: Very Simple Connectivity Examples
Appendix E: Installing and Using the Samples
Index

Market Description :
· Microsoft Database Developers
· DBAs

About Author :
Robert Vieira is one of the leading authorities on Microsoft SQL Server and author of the bestselling title from Wrox Press, Professional SQL Server 2000 Programming, with nearly 40,000 copies in print. Vieira is currently a Software Architect for NetIQ Corporation in Portland, OR, where he performs design work and coaches other developers. He speaks frequently at both public and private conferences nationally, and is perhaps best known for his light-hearted approach to teaching and writing.