PostgreSQL Fundamentals

Wanna get better at querying and performance tuning PostgreSQL? You’re in the right place! Whether you’re using self-hosted Postgres, AWS Aurora, or Azure Database for PostgreSQL, we’ve got resources to help your queries go faster.

• Early Access Bundle – get access to all of the below courses for just $249, plus access to all of the new Fundamentals of Performance classes I’m building for Postgres, and watch me live stream as I work.
• Fundamentals of Select – my free half-hour video that introduces how PostgreSQL queries work, and how to make them go faster.
• Fundamentals of Vacuum – if you don’t understand this crucial maintenance task, your database will keep getting larger and your queries will keep getting slower.
• Fundamentals of Index Tuning – learn how to make your Postgres database faster without changing your queries, and understand why index tuning on Postgres is different than other databases.
• Fundamentals of Python – learn the new world standard language for data work.

Resources:

• Stack Overflow database – download it to follow along with my training classes and Query Exercises.
• Query Exercises – free self-paced exercises to improve your query skills. The end of each exercise has a link to another post with my answers & thoughts.
• Smart Postgres Box of Tricks – Github repo with scripts to improve performance.

Want to learn more? Join my Early Access program. I’m building out new training classes and scripts, starting with Fundamentals of Vacuum. My Early Access members get to watch me live stream as I work, plus get access to the completed training classes at no extra charge.