Microsoft SQL Server 2008 T-SQL Fundamentals

Microsoft SQL Server 2008 T-SQL Fundamentals

4.6 8
by Itzik Ben-Gan
     
 

View All Available Formats & Editions

Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance—including exercises and code samples—that show you how to develop code to query and modify data. You’ll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful

See more details below

Overview

Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance—including exercises and code samples—that show you how to develop code to query and modify data. You’ll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries.


Discover how to:



  • Apply T-SQL fundamentals, create tables, and define data integrity

  • Understand logical query processing

  • Query multiple tables using joins and subqueries

  • Simplify code and improve maintainability with table expressions

  • Explore pivoting techniques and how to handle grouping sets

  • Write code that modifies data

  • Isolate inconsistent data and address deadlock and blocking scenarios

Product Details

ISBN-13:
9780735638129
Publisher:
Pearson Education
Publication date:
11/05/2008
Series:
Developer Reference
Sold by:
Barnes & Noble
Format:
NOOK Book
Pages:
416
Sales rank:
427,035
File size:
3 MB

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >