T-SQL Querying Crash Course

Trainer(s): Amit Bansal
Provider: SQLMaestros
Duration: 3 Hours
Subtitles: No
Price: FREE
Type: Free Video Courses

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