Learn Postgres in the best way possible.
Mastering Postgres is a comprehensive video course that will help you level up your applications and your career.
Learn the basics, master the complexities.
Start with the fundamentals and work your way up to advanced topics like indexes and data types.
Become an indexing expert.
Indexes are the key to fast queries. Learn how to create and use them to speed up your queries.
Master over 30 data types.
Postgres has a lot of data types. You'll learn which ones to use and which ones to avoid.
Meet your instructor
Aaron Francis
My name is Aaron Francis.
I'm a software developer, database educator, and content creator. (More importantly though, I'm a dad to two (!) sets of twins!)
I created this course because I love databases and want more software developers to feel empowered to work with them.
If you want to get in touch you can always find me on Twitter or shoot us an email [email protected].
What to expect
This course is designed to take you from beginner to expert in Postgres. You'll learn how to use Postgres in production, how to optimize it, and how to use advanced features like full text search, vectors and advanced techniques for working with JSON.
Module 1
Introduction
Module 2
Data Types
Introduction to schema
Integers
Numeric
Floating point
Storing money
NaNs and infinity
Casting types
Characters types
Check constraints
Domain types
Charsets and collations
Binary data
UUIDs
Boolean
Enums
Timestamps
Timezones
Dates and times
Module 3
Advanced Data Types
Intervals
Serial type
Sequences
Identity
Network and mac addresses
JSON
Arrays
Generated columns
Text search types
Bit string
Ranges
Composite types
Nulls
Unique constraints
Exclusion constraints
Foreign key constraints
Module 4
Indexing
Introduction to indexes
Heaps and CTIDs
B-Tree overview
Primary keys vs. secondary indexes
Primary key types
Where to add indexes
Index selectivity
Composite indexes
Composite range
Combining multiple indexes
Covering indexes
Partial indexes
Index ordering
Ordering nulls in indexes
Module 5
Advanced Indexing
Module 6
Understanding Query Plans
Module 7
Generating Results
Introduction to queries
Cross joins
Inner joins
Outer joins
Subqueries
Lateral joins
ROWS FROM
Filling gaps in sequences
Subquery elimination
Combining queries
Set generating functions
Indexing joins
Module 8
Advanced SQL
Introduction to advanced SQL
Grouping
Grouping sets, rollups, cubes
Window functions
CTEs
CTEs with window functions
Recursive CTE
Hierarchical recursive CTE
Handling nulls
Row value syntax
Views
Materialized views
Removing duplicate rows
Upsert
Returning keyword
COALESCE + generated column
Module 9
Full Text Search
Module 10
Advanced JSON
Intro to JSON
JSON vs JSONB
Validating JSON
Creating JSON objects + arrays
JSON extraction
JSON containment
JSON existence
JSON recordset
Updating JSON
Indexing JSON parts
GIN index
Module 11
Vectors (pgvector)
Join 1,287 students
Here's what students who have taken the course have to say:
Aaron is a natural teacher and this course is the best introduction to Postgres I have come across. Lessons are easy to follow and he recommends some great tools for working with Postgres.Joel Drumgoole
Window function 😊. CTE with window function 😮. Hierarchical recursive CTE 🤯. Recommended all the way. Can’t wait to see the rest of the videos!M Wildan Zulfikar
The course "Mastering Postgres" helped me practice query commands and understand why they're important. Inspiring me to explore the 'why' and 'how' behind each one. Truly a great course!Nakolus
I bought Mastering Postgres because I use Postgres a lot and wanted to support Aaron and his content. I already learned more than I expected and have been very impressed with the quantity and work Aaron put in.Timo Strackfeldt
Mastering Postgres has dramatically improved my understanding of indexes. It has helped me make informed decisions around my queries and schema rather than blindly adding indexes and hoping for the best.Dwight Watson
Mastering Postgres is single-handedly the most thorough and informative database course I’ve seen. I’ve gone from someone who barely knew the basics of Postgres and how it works to being comfortable with the advanced topics of Postgres.Ryan Hendrickson
Mastering Postgres is such a crisp way to learn this subject. With today’s AI tools writing many of the queries via autocomplete it’s vital to have this knowledge to ensure you know what’s actually happening under the hood. My app’s performance improved overnight after learning more about indexing. Aaron’s excitement for the subject makes it really fun to learn whether I’m next to my code editor or on a treadmill run.Peter Ramsing
Like many, I only dealt with databases when necessary. This course changed that, making me feel confident as my team's 'Database Expert'! Aaron is an engaging and insightful educator, making this a 10 out of 10 course. I'll definitely buy more courses from him. Highly recommend—no regrets!Kyle Bennett
The course broke down complex subjects into easy-to-understand videos that I've referred back to multiple times since completing it. It strengthened my knowledge by filling gaps and expanding into new areas I hadn't known about—absolutely worth doing!Lawrence
Finally treated myself to mastering Postgres by Aaron Francis. I highly recommend it! I love how each video is proving a concept - it makes the content easy to retain and engaging.Andrew Bass
Going through the Mastering Postgres course by Aaron Francis and holy cow is it well designed. These types of well-polished knowledge products bring me an immense amount of joy.Adam Taylor
Just finished Aaron Francis' Mastering Postgres course. Highly recommend 🙂Savannah
Really enjoying Aaron Francis' "Mastering Postgres". It's information-dense, very approachable, and well-produced.Daniel Bachhuber
Start learning today
Pay once and get lifetime access to the course, including all future content updates. No subscription fees, no hidden costs.
Complete Course
117 in-depth video tutorials
Over 16 hours of content
Advanced topics like JSON, Vectors, and more
Lifetime access
Optimize Postgres for production workloads
Understand database indexes at a deep level
Team Pricing
We offer team discounts on the full course based on the number of team members you'd like to purchase for.
Need more seats? Email us.
Mastering Postgres is such a crisp way to learn this subject. With today’s AI tools writing many of the queries via autocomplete it’s vital to have this knowledge to ensure you know what’s actually happening under the hood. My app’s performance improved overnight after learning more about indexing. Aaron’s excitement for the subject makes it really fun to learn whether I’m next to my code editor or on a treadmill run.Peter Ramsing
Frequently Asked Questions
I'm having issues with the course. Who can I contact?
Oh no! Send us an email at [email protected].
Is there a free trial available?
There are several free videos, but no free trial. If you aren’t fully satisfied with the course, just ask for your money back—no problem.
Is there a money back guarantee?
If, for any reason, you find yourself less than fully satisfied with the course, you may request a refund at any time.
Can I get an invoice?
Absolutely! After making a purchase we will automatically email you a receipt. If you need a more detailed invoice, just email us.
Do you offer discounts?
Sure, if you live in a country where the USD price is too high or if you are a student, don't hesitate to email us!