Chapters:

I want to see all the training videos on one page

• 1 - The Development Environment - Tools, Code Generation, and More (13 Videos)

• 2 - The Transact-SQL Language - An Introduction to Common Terms, Tools, and Techniques in TSQL (17 Videos)

• 3 - Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More (21 Videos)

• 4 - SELECT, INSERT, UPDATE and DELETE - Data Manipulation Language (28 Videos)

• 5 - Aggregating Data Using DISTINCT, GROUP BY, HAVING, ROLLUP, CUBE and more (3 Videos)

• 6 - JOINs and UNIONs - Working with Multiple Tables (5 Videos)

• 7 - Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more (17 Videos)

• 8 - Index Design, Plan Guides, Execution Plans and Query Plans for SQL Server: Performance Tuning Your Queries (8 Videos)

• 9 - Subqueries, Nested Queries, and Derived Tables in Transact SQL (6 Videos)

• 10 - Server-Side Storage: Temp Tables, Table Variables, Cursors and More (2 Videos)

• 11 - Stored Procedure Programming, Error Handling, and Passing Resultsets to the Client (13 Videos)

• 12 - Views in SQL Server (2 Videos)

• 13 - User-Defined Functions (UDFs) in SQL Server (9 Videos)

• 14 - Dynamic Data Source Queries - How to Write Distributed Data Queries Using Linked Servers and more (3 Videos)

• 15 - XML and SQL Server - FOR XML, SQLXML, MSXML, and More (8 Videos)

• 16 - Design Patterns for Transact-SQL (10 Videos)

• 17 - Misc Stuff That Just Doesn't Fit Anywhere Else (26 Videos)