Zenler Player
Your course is loading. Hang tight.
30 Day SQL Interview Prep Challenge Course
Back to curriculum
0% Complete
0% Complete
30 days from now, you will either crack the interview or make the same excuse.
Day 0 Why SQL Is the Most Valuable Skill You Can Learn.
Day 1 SELECT, WHERE, ORDER BY
Day 2 GROUP BY & HAVING
Day 3 JOINs — INNER, LEFT, RIGHT & FULL
Day 4 Working with NULLs
Day 5 SELF JOIN — a table joining itself
Day 6 Subqueries — queries inside queries
Stop. Look Back Before Moving Forward.
This Is Where Most People Quit
Day 7 CASE WHEN — conditional logic in SQL
Day 8 ROW_NUMBER, RANK, & DENSE_RANK
Day 9 PARTITION BY — scoping window functions
Day 10 LAG & LEAD
Day 11 SUM, AVG, COUNT as window functions
Day 12 FIRST_VALUE, LAST_VALUE, NTH_VALUE
Day 13 NTILE & PERCENT_RANK
Day 14 Window Frames — ROWS vs RANGE BETWEEN
Day 15 CTEs — Common Table Expressions
You Are Further Ahead Than You Think
This is where your SQL becomes genuinely powerful.
Day 16 Chained CTEs — Building Logic Step by Step
Day 17 Deduplication — Keeping the Right Record
Day 18 Date & Time Functions — Arithmetic on the Calendar
Day 19 String Functions — Cleaning Messy Text Data
Day 20 Advanced Aggregation — FILTER and Conditional Counts
Day 21 Set Operators — UNION, INTERSECT, EXCEPT
Day 22 Top-N Per Group — ROW_NUMBER, RANK, DENSE_RANK
You Are Closer Than Ever
Do Not Slow Down Now
How did this challenge feel for you so far?
Day 23 Running Totals & Moving Averages
Day 24 Gaps & Islands — Consecutive Sequence Detection
Day 25 Pivot & Unpivot — Reshaping Tabular Data
Day 26 Many-to-Many Joins & Bridge Tables
Day 27 Recursive CTEs — Tree & Hierarchy Traversal
Day 28 Query Performance — Writing SQL That Scales
Day 29 Mixed Expert — No Labels. Two Problems.
Day 30- 30 Days, Full-Stack SQL.
Personal Request from me
You are a Diamond!
Start here!
30 days from now, you will either crack the interview or make the same excuse.
Preview
Part 1
Day 0 Why SQL Is the Most Valuable Skill You Can Learn.
Day 1 SELECT, WHERE, ORDER BY
Day 2 GROUP BY & HAVING
Day 3 JOINs — INNER, LEFT, RIGHT & FULL
Day 4 Working with NULLs
Day 5 SELF JOIN — a table joining itself
Day 6 Subqueries — queries inside queries
Stop. Look Back Before Moving Forward.
Part 2
This Is Where Most People Quit
Day 7 CASE WHEN — conditional logic in SQL
Day 8 ROW_NUMBER, RANK, & DENSE_RANK
Day 9 PARTITION BY — scoping window functions
Day 10 LAG & LEAD
Day 11 SUM, AVG, COUNT as window functions
Day 12 FIRST_VALUE, LAST_VALUE, NTH_VALUE
Day 13 NTILE & PERCENT_RANK
Day 14 Window Frames — ROWS vs RANGE BETWEEN
Day 15 CTEs — Common Table Expressions
You Are Further Ahead Than You Think
Part 3
This is where your SQL becomes genuinely powerful.
Day 16 Chained CTEs — Building Logic Step by Step
Day 17 Deduplication — Keeping the Right Record
Day 18 Date & Time Functions — Arithmetic on the Calendar
Day 19 String Functions — Cleaning Messy Text Data
Day 20 Advanced Aggregation — FILTER and Conditional Counts
Day 21 Set Operators — UNION, INTERSECT, EXCEPT
Day 22 Top-N Per Group — ROW_NUMBER, RANK, DENSE_RANK
You Are Closer Than Ever
Part 4
Do Not Slow Down Now
How did this challenge feel for you so far?
Day 23 Running Totals & Moving Averages
Day 24 Gaps & Islands — Consecutive Sequence Detection
Day 25 Pivot & Unpivot — Reshaping Tabular Data
Day 26 Many-to-Many Joins & Bridge Tables
Day 27 Recursive CTEs — Tree & Hierarchy Traversal
Day 28 Query Performance — Writing SQL That Scales
Day 29 Mixed Expert — No Labels. Two Problems.
Day 30- 30 Days, Full-Stack SQL.
Personal Request from me
You are a Diamond!
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available !
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Next Lesson