Micro Free Course — 100% Free Learning
All lessons in this module are free to learn. Sign in with Google to save your progress.
4
ADVANCED ANALYTICS - PIVOT/UNPIVOT, INDEXING, ORDER OF EXECUTION
Pivot/unpivot, and perf basics (indexes, plans).
Module Progress0% Complete
90 min total
6 Lessons
0 Completed
Module Content
PIVOT and UNPIVOT in SQL
30 minVideo
Start
SQL - Indexes (Just filter or join on indexed columns)
7 minVideo
Start
Order of Execution - Optimizing Queries
6 minVideo
Start
QUIZ - MODULE 4
35 minTutorial
Start
CODING: Pivot via Conditional Aggregation
Pivot track counts by genre and media type using conditional aggregation -- the Postgres-native way to express what the video demonstrates in T-SQL PIVOT syntax.
12 minAssignment
Start
CODING: Optimize a Date Filter
Rewrite a non-SARGable date filter into an index-friendly equivalent -- the core trap from the Order of Execution / SARGability video.
10 minAssignment
Start