Faster databases with no code changes.
You're comfortable getting the data you want out of Postgres, but your queries don't come back as quickly as you'd like. You don't really wanna make any app code changes - you just want everything to go faster, now.
In this class, you'll learn how to design indexes, review indexes for an existing table, create indexes for a specific query, how to recognize common index mistakes (and fix them), and how to gauge the success of your work.
This class is in Early Access mode now, still being built, projected to be done in Q2 2025. As Brent finishes each new module, you'll automatically get access and be emailed about it.
Curriculum
Making Sure You're Ready for Class: Free Prerequisites
Available in
days
days
after you enroll
1: Which Columns to Index
Available in
days
days
after you enroll
2: How Functional Indexes Help Timestamps and Varchars
Available in
days
days
after you enroll
3: Indexing for Sorts & Order By
Available in
days
days
after you enroll
4: How Partial Indexes Reduce Size and Overhead
Available in
days
days
after you enroll
5. Your First Big Lab: The Single-Table-Query Lab
Available in
days
days
after you enroll
6: Indexing for Joins
Available in
days
days
after you enroll