SQL beyond basic queries
Rank tied records, calculate running totals and paginate with composite cursors.
Prerequisite: SQL foundations · 80 minutes of guided study
3 SQLite workshops with alternative datasets; production plans vary by database.
Start first lesson →What you’ll be able to do
- A composite cursor gives each page a stable boundary.
How to study this course
Follow the numbered modules. Read the example, explain why it works, attempt the exercise, then compare your result with the supplied checks.
Setup: A modern browser. JavaScript, TypeScript, Python and SQLite exercises run here; project workshops state their additional setup.
Times estimate guided reading and practice. Projects and revision can take longer.
Course syllabus · 3 lessons
Engineering practice
- Keep every row tied for first place25 min · Browser exercise →
Ranking semantics are a business decision.
- Make running totals deterministic25 min · Browser exercise →
Specify the window frame instead of relying on a default.
- Project · Paginate a changing activity feed30 min · Browser exercise →
A composite cursor gives each page a stable boundary.