3 courses match your filters.
Window functions, CTEs, recursive queries and query tuning, taught as claims about rows rather than as syntax to memorise.
CTEs · Window Functions · Recursive Queries · Upserts
Output-based
Query and shape data like a pro: SELECT, WHERE, JOINs, aggregates, schema design and transactions — with a working SQL console.
Output-based
Entity modelling, keys, normalisation to third normal form, constraints, indexing, and the judgement calls that come after the rules run out.
Database · SQL · Normalization · Schema Design
Output-based