Fundamentals · Recorded class · Taught by Brent Ozar
Postgres: Fundamentals of Index Tuning 2027
Make your Postgres queries go faster by building the right indexes, without touching the code.
$195 one payment · recordings through Dec 31, 2026
Buy the recording See what’s inside ↓
One payment, no auto-renew, no refunds. Or get all 10 Fundamentals recordings for $695: Recorded Class Season Pass: Fundamentals →
Curriculum · Every lecture
What’s inside
- About 3 hours
- 5 sections
- 18 lectures
- Taught by Brent Ozar
- Early access more lectures as they’re recorded
Making Sure You're Ready for Class: Free Prerequisites
- Welcome to the Class 3:59
- Concepts to Grasp First
- Getting Your Computer Ready
- Download the Scripts and Resources
1: Which Columns to Index
- Which Columns Should You Index at First? 22:55
- Why You Shouldn't Start With Multi-Column Indexes 23:46
- Lab: Picking Columns to Index 4:32
- Watch Brent Do the Lab 31:10
2: How Functional Indexes Help Timestamps and Varchars
- Why Timestamp Columns Often Need Functional Indexes 15:26
- Lab: Designing Functional Indexes for Timestamp Columns 16:10
- Watch Brent Do the Lab 14:24
3: Indexing for Sorts & Order By
- Sorting Many Rows From One Table 24:28
- Sorting a Few Rows From One Table 10:54
- Lab: Designing Indexes for Order By 1:03
- Watch Brent Do the Lab 14:24
4: How Partial Indexes Reduce Size and Overhead
- Where Partial Indexes Make Sense 9:00
- Lab: Design Partial Indexes Where They Make Sense 1:19
- Watch Brent Do the Lab 7:37
This class is included in…
Or get all of them.
4 bundles contain this class. Every one is cheaper than buying its classes one at a time, and the recorded passes are about half.
Recorded bundle · 10 classes
Recorded Class Season Pass: Fundamentals
Access through Dec 31, 2026. Every class links to its own page and full curriculum.
$1,950
$695
bought separately · save 64%
Recorded bundle · 13 classes
Recorded Class Season Pass: Fundamentals + Mastering
Access through Dec 31, 2026. Every class links to its own page and full curriculum.
$4,335
$2,195
bought separately · save 49%
Fundamentals · Live class
Fundamentals Week
Live Fundamentals of Index, Query, and Server Tuning, plus the Recorded Class Season Pass: Fundamentals (all 10 recordings), through Dec 31, 2027.
$1,495 one payment
Registration opens October 1, 2026Live Class Season Pass 2027
One pass. Every class. All year.
Fundamentals Week and all three Mastering classes, live, every rotation through Feb 2028. Plus the Recorded Class Season Pass: Fundamentals + Mastering (all 13 recordings) the minute you buy, and your name in the alumni directory.
$4,395 one payment
Registration opens October 1, 2026Prerequisites & logistics
The fine print, in regular-size type.
- Labs (optional)
- Your own Postgres server to run the labs on; the prerequisites walk you through setting one up. Labs are optional; the lectures stand on their own.
- Access
- Recordings through Dec 31, 2026, on training.brentozar.com. One payment, no auto-renew.
- Refunds
- None. Watch the free previews and read the curriculum above first; that’s what it’s there for.
- Purchase orders
- Accepted for 10 or more seats; email help@brentozar.com for a quote. Everything else goes through the website by credit card.
Free, 3× a week
3 posts a week, in your inbox
Plus a Monday roundup of my favorite database news from around the web. No fluff, occasional jokes.
Questions first
Not sure this is the one?
Email help@brentozar.com and tell me what’s slow. It’s me answering, and I’d rather sell you the right class than the biggest one.
Email me