Track · Analyst
Window functions end to end
From the first OVER to frames, moving averages and ranking within groups. The topic interviews ask about most and courses teach last.
30 tasks~10 h4 modules
Track program
4 modules- 1Module 1
First windows
8 tasks - 2Module 2
Ranking
8 tasks - 3Module 3
Frames and moving windows
8 tasks - 4Module 4
Expert
6 tasks
Who it's for
A track for data analysts. Tasks run from the basics to the advanced, grading is automatic, and both PostgreSQL and MySQL are supported.