Microsoft SQL Server 2008: T-SQL Fundamentals

Chapter 01: Background to T-SQL Querying and Programming
- Theoretical Background
- SQL Server Architecture
- Creating Tables and Defining Data Integrity
- Conclusion

Chapter 02: Single-Table Queries
- Elements of 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 03: Joins
- Cross Joins
- Inner Joins
- Further Join Examples
- Outer Joins
- Conclusion
- Exercises
- Solutions

Chapter 04: Subqueries
- Self-Contained Subqueries
- Correlated Subqueries
- Beyond the Fundamentals of Subqueries
- Conclusion
- Exercises
- Solutions

Chapter 05: Table Expressions
- Derived Tables
- Common Table Expressions
- Views
- Inline User Defined Functions
- APPLY
- Conclusion
- Exercises
- Solutions

Chapter 06: Set Operations
- The UNION Set Operation
- The INTERSECT Set Operation
- The EXCEPT Set Operation
- Precedence
- Circumventing Unsupported Logical Phases
- Conclusion
- Exercises
- Solutions

Chapter 07: Pivot, Unpivot and Grouping Sets
- Pivoting Data
- Unpivoting Data
- Grouping Sets
- Conclusion
- Exercises
- Solutions

Chapter 08: 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 09: 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 Sample Database
- Working with Microsoft SQL Server Management Studio
- Working with Microsoft SQL Server Books Online

Back to T-SQL Fundamentals 2008 Main Page