Beginning Microsoft SQL Server 2008 Programming
By Robert Vieira
Publisher: Wiley / Wrox
Final Release Date: December 2008
Pages: 720

Starting simply and gradually progressing to increasingly advancedtopics, this introduction to the SQL Server database focuses onwhat is distinctive about the SQL environment—SQL Server2008, in particular—versus other programming environments.Author Robert Vieira draws on his experience as one of the leadingauthorities on Microsoft SQL Server and uses his unique tutorialapproach to explain the significant changes to the fundamental corecomponents of SQL Server 2008.

You'll begin with an overview of database design concepts andlearn how to implement these fundamental concepts with MicrosoftSQL Server 2008. Then, you'll take a look at the role of an RDBMS(relational database management system) and where it fits in thegrand scheme of system development. Thorough coverage of the keyadditions and changes to the 2008 version of SQL Server includediscussions on DATE and TIME datatypes, hierarchyID datatypes,MERGE and multiple inserts, recursive queries, and more. With thisbook, you will conquer the many changes and challenges of MicrosoftSQL Server 2008.

What you will learn from this book

  • How RDBMSs store, manage, and retrieve data
  • Ways to create and alter tables

  • Various "forms" of database normalization

  • Techniques for writing scripts and working with storedprocedures

  • The positives and negatives of indexes

  • Myriad consequences that locks and deadlocks have on systemperformance

  • An understanding of triggers and how they are used

Who this book is for
This book is for developers who are looking for a completeintroduction to database design concepts and learning SQL. A basicunderstanding of development fundamentals is helpful.

Wrox Beginning guides are crafted to make learningprogramming languages and technologies easier than you think,providing a structured, tutorial format that will guide you throughall the techniques involved.

Product Details
Recommended for You
Customer Reviews
 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $39.99
Formats:  ePub, Mobi, PDF