Postgres: Fundamentals of Index Tuning 2027 (Early Access)
You need to make your Postgres database go faster and cut costs, quickly, without changing code. Indexes are the key.
What you will get:
- Watch on any Device
- 5 sections
- lectures
- of video
Last updated: 13 July 2026
Your Instructor
I make Microsoft SQL Server go faster. I've been working with SQL Server since the late 1990s, and I'm one of the rare Microsoft Certified Masters of SQL Server. I love teaching, travel, and laughing. I live in Las Vegas, Nevada.
Course Description
The easiest way to make all of your queries go faster is to build the right indexes to support them. Good news – I’ll teach you how in this recorded class.
The class includes hands-on lab assignments that will take you hours to work through, and my students tell me they love doing these labs again and again. They're kinda like database video games! To follow along, you'll need to build your own Postgres server - see the prerequisite notes in the curriculum.
Course 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
