SQL From Zero: Query Real Data With Confidence
by Sofia Navarro
Model it, query it, and keep it fast under real load.
SQL, schema design, indexing, analytics and data pipelines taught with datasets big enough to hurt. You learn to read a query plan, choose the right index and run migrations safely against a live table. PostgreSQL, MySQL and the analysis tooling that sits on top are all covered.
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.
Other shelves developers move on to next.