Lessons
SQL · Expert
SQL · Expert. 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
Locking and deadlocks
Row locks and waits.
Lesson 2
MVCC intuition
Readers vs writers.
Lesson 3
Query antipatterns
SELECT * and N+1.
Lesson 4
Covering indexes
Index-only scans.
Lesson 5
Partitioning sketch
Split large tables.
Lesson 6
Prepared statements
Plan reuse and safety.
Lesson 7
Triggers caution
Hidden side effects.
Lesson 8
Roles and grants
Least privilege.
Lesson 9
Temporal / audit patterns
History tables.
Lesson 10
Expert capstone
Safe money transfer sketch.
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.