Beginning Microsoft SQL server 2008 programming

This 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 an explanation of how to implement fundamental concepts with the new 2008 version of SQL Server

Bibliographic Details
Main Author: Vieira, Robert
Format: eBook
Language:English
Published: Indianapolis, IN Wiley Pub. 2009
Series:Wrox beginning guides
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
Table of Contents:
  • 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