You’re a developer or database administrator who stores data in PostgreSQL. You’re comfortable writing queries, and you’ve shipped production applications.
Your queries are slow, and you’re getting confusing, conflicting advice from ChatGPT and Google. You’re looking for clear, simple answers.
Get instant access to my Box of Tricks scripts, the Stack Overflow database in Postgres, my Fundamentals of Select class, and more.
TRUSTED BY DEVELOPERS AND DBAS AT
Your queries aren’t the problem: they worked fine when the data was smaller. But your app added more users over time, the data got bigger, and your hosting bills keep getting more expensive.
You don’t want to sit through boring PowerPoints filled with useless trivia. You don’t need to know the internals of how b-trees are structured, or hear somebody show off what they know.
You just want to see clear, simple demos showing problems and solutions.
Then you want to prove what you’ve learned by doing hands-on lab exercises, and watch someone else step through those same exercises to see their thought process.
You want my Fundamentals classes where I respect your time and get right to the point so you can go back to focusing on delivering app features for your users.
WHAT YOU’LL LEARN IN EACH CLASS
I’ve been working with databases for over 25 years. I got my start on Microsoft SQL Server, and I built the BrentOzar.com resources site, the open source First Responder Kit diagnostic scripts, spoke at conferences around the world, and sold millions of dollars of training classes. I’ve consulted at StackOverflow.com, Google, Cisco, and a bunch of other companies whose products you use every day.
In 2017, I started using AWS Aurora Postgres and fell in love with it. Postgres has so much power and flexibility, especially given its price tag compared to Microsoft SQL Server! I designed a commercial monitoring product using Postgres as a back end, churning through 2TB of data per month, and learned a lot about performance tuning it.
I wanna share what I’ve learned, helping your apps go faster with as little work as possible, and have a great time doing it. Let’s do this!