Beginning Microsoft Sql Server 2008 Programming

Beginning SQL Server 2008 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. The author then proceeds to show how to implement these fundamental concepts with Microsoft SQL Server 2008. · RDBMS Basics: What Makes Up a SQL Server Database? · Tools of the Trade · The Foundation Statements of T- · 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
About Author :
Robert Vieira is one of the leading authorities on Microsoft SQL Server and author of Professional SQL Server Programming, with more than 46,000 copies in its 2000 and 2005 editions. Vieira is currently an independent consultant in Vancouver, WA. He speaks frequently at both public and private conferences nationally, and is perhaps best known for his unique tutorial approach both in teaching and writing. He plans to aggressively promote the book via speaking engagements at the PASS 2008 Conference, a new SQL Server programming blog, and in articles in SQL Server Magazine.