Microsoft SQL Server 2008 T-SQL Fundamentals

by Itzik Ben-Gan

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:	10/22/2008
Series:	Developer Reference
Sold by:	Barnes & Noble
Format:	eBook
Pages:	416
File size:	3 MB

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.

Table of Contents

Acknowledgments; Introduction; Who This Book Is For; What This Book Is About; Companion Content; Hardware and Software Requirements; Find Additional Content Online; Support for This Book; Chapter 1: Background to T-SQL Querying and Programming; Theoretical Background; SQL Server Architecture; Creating Tables and Defining Data Integrity; Conclusion; Chapter 2: Single-Table Queries; Elements of the SELECT Statement; Predicates and Operators; CASE Expressions; NULLs; All-At-Once Operations; Working with Character Data; Working with Date and Time Data; Querying Metadata; Conclusion; Exercises; Solutions; Chapter 3: Joins; Cross Joins; Inner Joins; Further Join Examples; Outer Joins; Conclusion; Exercises; Solutions; Chapter 4: Subqueries; Self-Contained Subqueries; Correlated Subqueries; Beyond the Fundamentals of Subqueries; Conclusion; Exercises; Solutions; Chapter 5: Table Expressions; Derived Tables; Common Table Expressions; Views; Inline Table-Valued Functions; The APPLY Operator; Conclusion; Exercises; Solutions; Chapter 6: Set Operations; The UNION Set Operation; The INTERSECT Set Operation; The EXCEPT Set Operation; Precedence; Circumventing Unsupported Logical Phases; Conclusion; Exercises; Solutions; Chapter 7: Pivot, Unpivot, and Grouping Sets; Pivoting Data; Unpivoting Data; Grouping Sets; Conclusion; Exercises; Solutions; Chapter 8: Data Modification; Inserting Data; Deleting Data; Updating Data; Merging Data; Modifying Data Through Table Expressions; Modifications with the TOP Option; The OUTPUT Clause; Conclusion; Exercises; Solutions; Chapter 9: Transactions and Concurrency; Transactions; Locks and Blocking; Isolation Levels; Deadlocks; Conclusion; Exercises; Chapter 10: Programmable Objects; Variables; Batches; Flow Elements; Cursors; Temporary Tables; Dynamic SQL; Routines; Error Handling; Conclusion; Appendix A: Getting Started; Installing SQL Server; Downloading Source Code and Installing the Sample Database; Working with SQL Server Management Studio; Working with SQL Server Books Online; Appendix : Itzik Ben-Gan; Appendix : Additional Resources for Developers from Microsoft Press; Visual Basic; Visual C#; Web Development; Data Access; SQL Server 2005; Other Developer Topics; Appendix : More Great Developer Resources; Developer Step by Step; Developer Reference; Focused Topics;