Microsoft SQL Server 2008 Tâ "SQL Fundamentals

Itzik Ben-Gan

ISBN 10: 0735626014 / ISBN 13: 9780735626010

Published by Microsoft Press,U.S., United States, Redmond, 2008

About this Item

Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidanceincluding exercises and code samplesthat show you how to develop code to query and modify data. Youll 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. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged.

Seller Inventory # GOR004623451

Bibliographic Details

• Title: Microsoft SQL Server 2008 Tâ "SQL Fundamentals
• Publisher: Microsoft Press,U.S., United States, Redmond
• Publication Date: 2008
• Language: English
• ISBN 10: 0735626014
• ISBN 13: 9780735626010
• Binding: Paperback
• Condition: Very Good

About this title

Synopsis

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 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.