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

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:
9780735626010
Publisher:
Microsoft Press
Publication date:
11/05/2008
Series:
Developer Reference Series
Pages:
416
Product dimensions:
8.44(w) x 7.28(h) x 1.27(d)

Meet the Author

Itzik Ben-Gan is a mentor and cofounder of SolidQ. 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 author of Microsoft SQL Server T-SQL Fundamentals and 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 TechEd, DevWeek, PASS, and SQL Server Connections.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Microsoft SQL Server 2008 T-SQL Fundamentals 4.6 out of 5 based on 0 ratings. 8 reviews.
Anonymous More than 1 year ago
this is great for introductory and for those wanting to dive further into querying. Doesn't get into building database, which is nice as that is not what I need. Perfect addition to library.
Anonymous More than 1 year ago
Great book. Helpful to brush up and realize what you had forgotten about T-SQL. Highly recommend this book for beginners as well as a reference for those who just need something handy to refer to.
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
StevenMurawski More than 1 year ago
This book is an excellent introduction to T-SQL. If you've been working with SQL Server and want to brush up on your T-SQL chops, this is the book for you. I've re-read it twice now and pick up additional nuances each time.