Note: Lifetime Access

Difference between Logical & Physical Joins (And different types)
Optimizing using APPLY operator
Performing SET operations
Subqueries – Advantages & Pitfalls
Optimizing your SQL code
Common Table Expression (Ease & Performance)
Performing Recursion
Implementing Ranking
Aggregating Data with business examples
Performing SET operations
The need for PIVOTing & UNPIVOTing