Back to courses
da-ds intermediate
SQL Intermediate
Master window functions, CTEs, and query optimization. Build real-world analytics queries.
10 lessons
~5 hours
⭐ 1200 XP total
Your Progress 0/10 lessons
What you'll learn
Window Functions CTEs Query Optimization Advanced DML Analytics
Course Content
1
Introduction to Window Functions
25 min +100 XP
2
Ranking Functions
30 min +125 XP
3
Aggregate Window Functions
30 min +150 XP
4
Offset Functions: LAG & LEAD
25 min +125 XP
5
Common Table Expressions
25 min +125 XP
6
Recursive CTEs
30 min +150 XP
7
Query Performance
25 min +100 XP
8
Advanced Data Manipulation
25 min +125 XP
9
Real-World Scenarios
30 min +150 XP
10
SQL Intermediate Quiz
Quiz 15 min +50 XP