Advanced T SQL
Module 00 - Advanced T-SQL Introduction
 Module 01 - Execution Plan Basics
 Module 02 - Working with NULLS
 Module 03A - Window Functions (Ranking Functions)
 Module 03B - Window Functions (Aggregate Function)
 Module 03C - Window Functions (Framing)
 Module 03D - Window Functions (Alternative Methods)
 Module 03E - Window Functions (Analytical Functions)
 Module 04A - Working with Sets (EXCEPT)
 Module 04B - Working with Sets (INTERSECT and UNION)
 Module 05A - Advanced Joins (Self Joins)
 Module 05B - Advanced Joins (NON-EQUI, CROSS and OUTER Joins)
 Module 06A - Functions (Scalar Functions)
 Module 06B - Functions (Table-Valued Functions)
 Module 07A - Apply Operator (Introduction to Apply)
Module 07B - Apply Operator (Apply for Performance)
 Module 08A - Pivot and UnPivot (PIVOT)
 Module 08B - Pivot and UnPivot (UNPIVOT)
 Module 09 - Subqueries
 Module 10A - CTEs, Temp Tables and Derived Tables (Introduction to CTEs)
 Module 10B - CTEs, Temp Tables and Derived Tables (Simplifying Complex Problems)
 Module 10C - CTEs, Temp Tables and Derived Tables (Derived Tables)
 Module 10D - CTEs, Temp Tables and Derived Tables (Recursion and Modifying Data)
 Module 10E - CTEs, Temp Tables and Derived Tables (Temp Tables)
 Module 11 - HASHBYTES and CHECKSUM
 Module 12 - IF.. ELSE and EXISTS
 Module 13 - Merge
 Module 14A - Miscellaneous Functions
 Module 14B - Miscellaneous Functions (SQL Server 2016 New Features)
 Module 15 - Dynamic SQL
 Module 16 - Cursors and While Loop
 Module 17A - XML (XML RAW)
 Module 17B - XML (XML AUTO)
 Module 17C - XML (XML PATH)
Module 17D - XML (XML Shredding)
 Module 17E - XML (XQUERY)
 Module 17F - XML (XML PATH - Comma Delimited List)
 Module 18 - Transactions
 Module 19 - Error Handling