Bundle · 3 recorded classes
Recorded Class Season Pass: Mastering
All 3 Mastering 2026 recordings. Watch in any order, as many times as you like, through Dec 31, 2026.
$2,385
$1,495
bought separately · save 37%
Get the pass See what’s inside ↓
One payment, no auto-renew, no refunds.
What you get
3 classes, and the year to watch them.
- All 3 Mastering recordings: Mastering Index Tuning 2026, Mastering Query Tuning 2026, and Mastering Server Tuning 2026.
- Access through Dec 31, 2026. No drip schedule, no auto-renew.
Who it’s for
You’ve done the Fundamentals and you’re responsible for a server that needs more than the basics.
Everything inside · 3 classes
Every class, every lecture.
- 3 classes
- Access through Dec 31, 2026
- Each class has its own page
Mastering
Mastering Index Tuning 2026
$795 on its own
Before the Class
- Introductions 20:09
- Prerequisites
- Change Log for This Class
- Watch the Live Class Start
- Download the Slides & Demos
Bending the 5 & 5 Guideline with Special Indexes
- Filtered Indexes 37:41
- Indexed Views 39:56
- Computed Columns 28:45
- Automatic Indexing Through Time 22:36
- Lab 1 Assignment 7:20
- Lab 1: Brent Does It 37:10
Heaps and Clustered Indexes
- Where to Use Heaps and How to Pick Clustering Keys 48:20
Fixing Blocking with Index Tuning
- Fixing Blocking with Index Tuning 42:14
- Lab 2 Assignment 7:34
- Lab 2: Brent Does It 38:26
Making Tough Decisions When You Scale
- When to Remove Constraints and Foreign Keys 35:02
- Choosing Between Partitioned Tables and Views 43:42
- How to Get Seeks on the Second Column of an Index 15:04
- Lab 3 Assignment 5:47
- Lab 3: Brent Does It 47:00
Specialized Index Types
- Tuning Indexes to Avoid Key Lookups 20:12
- Indexing JSON 25:50
Doing the D.E.A.T.H. Method
- Deduping and Eliminating 44:56
- Lab 4 Assignment 5:28
- Lab 4: Brent Does It 52:57
Mastering
Mastering Query Tuning 2026
$795 on its own
Curriculum in progress
Three days of lectures and labs. The module list goes up here as the recordings are cut.
Mastering
Mastering Server Tuning 2026
$795 on its own
Curriculum in progress
Three days of lectures and labs. The module list goes up here as the recordings are cut.
The next bundle up
Or get more of the catalog.
Everything in this pass is also inside Recorded Class Season Pass: Fundamentals + Mastering and Live Class Season Pass 2027. Each costs less than adding its classes one at a time.
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%
Live 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)
- Each class lists its own setup. The SQL Server classes want your own lab (any edition, or Azure SQL DB / Amazon RDS) with the Stack Overflow database, or a rented lab VM; Drew’s classes want Python, an Azure subscription, or PowerShell respectively. Labs are optional everywhere.
- 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