Beginning Microsoft SQL Server 2008 Programming

Starting simply and gradually progressing to increasingly advanced topics, this introduction to the SQL Server database focuses on what is distinctive about the SQL environment - SQL Server 2008, in particular - versus other programming environments. Author Robert Vieira draws on his experience as one of the leading authorities on Microsoft SQL Server and uses his unique tutorial approach to explain the significant changes to the fundamental core components of SQL Server 2008. You'll begin with an overview of database design concepts and learn how to implement these fundamental concepts with Microsoft SQL Server 2008. Then, you'll take a look at the role of an RDBMS and where it fits in the grand scheme of system development.

• 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

"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 ."--Publisher's website A study of the programming aspects of Microsoft SQL Server 2008 explores the changes and updates to the new release, furnishes extensive code examples, and covers such topics as creating and changing tables, building complex data structures, improving application speed and performance, and advanced scripting and error handling.