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 thesefundamental concepts with Microsoft SQL Server 2008. The author covers such essential topics as: Creating and changing tables. Managing keys. Database normalization. Writing scripts. Working withstored procedures. Programming with XML. Using SQL Server Reportingand Integration Services. For the SQL Server 2008 edition, key additions and changes include: DATE, TIME datatypes, and a discussion of the new time related functionality HierarchyID data type, and a discussion of hierarchical data Enhancedcoverage of the XML data type MERGE and multiple inserts in one INSERT statement Recursive queries Others to be determined as more complete CTPs become available. In addition, the author will updateall examplesusing Microsoft's current AdventureWorks sample database. The final book is expected to be about 20 to 25% new and revised. Note that this Beginningbook is designed to complement the author's Professional SQL Server 2008 Programming.
Wydawnictwo: John Wiley & Sons, Ilość stron: 720, ISBN: 978-0-470-25701-2

Zobacz wszystkie książki autora: R. Vieira, R. Vieira.