Database Design and Indexing for Analytics Workloads

<p>Follow backend engineer Dara Okonkwo as they take over Tidewell Analytics' core Postgres database and fix it one real incident at a time &mdash; correcting column types and constraints, building composite and covering indexes, partitioning a fast-growing orders table, pre-aggregating expensive reports with materialized views, and finally diagnosing a live slow-query incident end to end with EXPLAIN.</p>

Tools: PostgreSQL, Indexing, Table Partitioning, Materialized Views, Query Optimization