Microsoft® SQL Server® 2008 T-SQL Fundamentals

Microsoft® SQL Server® 2008 T-SQL Fundamentals
Published:October 22, 2008Language:English
Author:Itzik Ben-Gan (Solid Quality Mentors)Technology:Microsoft SQL Server 2008
Length:416 PagesISBN 13:9780735626010

List Price:

$ 49.99
About The BookLearn T-SQL, write better code and queries, and extend your SQL Server knowledge

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

  • About Itzik Ben-Gan (Solid Quality Mentors)Itzik Ben-Gan is a mentor and cofounder of Solid Quality Mentors. A Microsoft MVP for SQL Server since 1999, Ben-Gan teaches and consults internationally on T-SQL querying, programming, and query tuning. He is the coauthor of Inside Microsoft SQL Server: T-SQL Querying and Inside Microsoft SQL Server:T-SQL Programming. He has written numerous articles for SQL Server Magazine and MSDN®, and speaks at industry events such as Microsoft Tech
  • Ed, DevWeek, PASS, and SQL Server Connections.
  • Other Books By Itzik Ben-Gan
    Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community. Preparing for an exam now? Find your Microsoft Certification Study Group. Talk to us on these social networks:
    What do you think of this book? Your feedback is important in helping us create books that serve your needs and meet your expectations.Please take our survey at www.microsoft.com/learning/booksurvey

    Note: You will need this book's 13-digit International Standard Book Number (ISBN) to take the survey.The ISBN 13 can be found above.
    To report or search for corrections in this book or its companion content,
    search for the title in our online store and then check the Errata & Updates tab. To report errors, please go to our Submit errata page.