Share
Create bookmark
Microsoft® SQL Server® 2008 T-SQL Fundamentals
Notes
Please login to add notes
- + Cover
- Dedication
- Contents at a Glance
- Table of Contents
- Acknowledgments
- + Introduction
-
+
Chapter 1: Back to T-SQL Querying and Programming
- + Chapter 2: Single-Table Queries
-
+
Chapter 3: Joins
-
+
Chapter 4: Subqueries
-
+
Chapter 5: Table Expressions
-
+
Chapter 6: Set Operations
-
+
Chapter 7: Pivot, Unpivot, and Grouping Sets
-
+
Chapter 8: Data Modification
-
+
Chapter 9: Transactions and Concurrency
-
+
Chapter 10: Programmable Objects
-
+
Appendix A: Getting Started
- + Index
- Author Bio
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
Test the closed alpha on paperc.com
Book Details
Authors
Categories
Publishers
Publication year : 2009
License: All rights reserved ©
Times read: 620
