Window Functions and Advanced SQL Patterns
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–4 of 4 courses
Running totals, rankings and gaps-and-islands, explained until they finally feel obvious.
Indexes, transactions, JSONB and migrations, taught from the application developer seat.
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.