SQL From Zero: Query Real Data With Confidence
by Sofia Navarro
Catalog
Model it, query it, and keep it fast under real load.
Jump to a technology
Showing 1–6 of 6 courses
Write joins, aggregates and filters you can defend, starting from a completely blank slate.
Running totals, rankings and gaps-and-islands, explained until they finally feel obvious.
Indexes, transactions, JSONB and migrations, taught from the application developer seat.
Turn EXPLAIN output into a fix list, and make slow endpoints fast without guesswork.
Schema decisions that still hold up after two years of features nobody planned for.
Build a warehouse layer with tested transformations that analysts and executives both trust.