Lessons
SQL · Medium
SQL · Medium. Ten lessons. Open-book quizzes. Lesson 1 free.
10 lessons · The Host · Lesson 1 free
Pass all ten lessons for the certificate. Sample · Claim
Lesson 1 · On the house
Window functions
ROW_NUMBER and friends.
Lesson 2
CTEs
WITH clauses.
Lesson 3
EXPLAIN plans
Read the optimizer's mind.
Lesson 4
Normalization sketch
1NF–3NF intuition.
Lesson 5
Upserts
INSERT ... ON CONFLICT.
Lesson 6
Isolation levels
What transactions see.
Lesson 7
Partial indexes
Index a subset.
Lesson 8
JSON columns
Semi-structured data.
Lesson 9
Migrations
Evolve schema safely.
Lesson 10
Medium capstone
Report with window + CTE.
Sample certificate
Certificate of completion
Sign in to claim your certificate of completion.
Certificate
Finish all ten lessons, then sign in
Pass every lesson on this device (quizzes and checks). Then sign in or create an account to type your name and download the JPG.