Microsoft SQL Server 2008 T-SQL Fundamentals
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...
Search in google:
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
1 Background to T-SQL Querying and Programming 12 Single-Table Queries 253 Joins 1014 Subqueries 1335 Table Expressions 1616 Set Operations 1937 Pivot, Unpivot, and Grouping Sets 2138 Data Modification 2379 Transactions and Concurrency 27910 Programmable Objects 319 App. A Getting Started 359 Index 379
![SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]](/application/data/covers/44/31/9780321444431.jpg "SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]")
