The most comprehensive course on PostgreSQL

Mastering Postgres is an in-depth video course by database educator Aaron Francis. Created in partnership with .

Optimized Learning

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 a Full Text Search wizard

Learn how to use the full text search capabilities of Postgres to build powerful search features.

Become an indexing expert

Indexes are the key to fast queries. Learn how to create and use them to speed up your queries.

Image 1Image 2

Dark mode videos

Dark mode users — we have you covered. Toggle light and dark mode videos and enjoy them in 4K resolution.

Over 30 data types

Postgres has a lot of data types. You'll learn which ones to use and which ones to avoid.

Your application is only as fast as your slowest query regardless of what language, framework, or hosting platform you choose. Mastering Postgres is a comprehensive video course that will help you level up your applications and your career.

You'll deeply understand the core principles of PostgreSQL through real-world examples. Get to know the many data types Postgres offers and when to use them, and more importantly, when not to use them. You'll understand how indexes work, how to improve your indexes and keep your database running as efficiently as possible.

Master

30+

data types

Includes

96

videos

Over

11 hrs

of content

What we'll cover

This course is designed to take you from beginner to expert in Postgres. You'll learn everything you need to confidently use Postgres in large-scale applications with demanding workloads.
Module 1
Introduction
Video 1
Introduction to the course
Free
2:14
Video 2
Overview of course structure
Free
3:40
Video 3
Postgres vs. everyone
Free
2:08
Video 4
The psql CLI
Free
2:38
Module 2
Data Types
Video 5
Introduction to schema
Free
6:45
Video 6
Integers
Free
9:40
Video 7
Numeric
Free
9:50
Video 8
Floating point
Free
8:04
Video 9
Storing money
Free
8:16
Video 10
NaNs and infinity
Free
3:44
Video 11
Casting types
Free
5:35
Video 12
Characters types
Free
7:42
Video 13
Check constraints
Free
8:55
Video 14
Domain types
Free
7:49
Video 15
Charsets and collations
Free
7:48
Video 16
Binary data
Free
9:00
Video 17
UUIDs
Free
6:19
Video 18
Boolean
Free
3:47
Video 19
Enums
Free
12:45
Video 20
Timestamps
Free
12:43
Video 21
Timezones
Free
13:13
Video 22
Dates and times
Free
7:50
Module 3
Advanced Data Types
Video 23
Intervals
Free
5:47
Video 24
Serial type
Free
9:52
Video 25
Sequences
Free
4:49
Video 26
Identity
7:02
Video 27
Network and mac addresses
4:48
Video 28
JSON
10:17
Video 29
Arrays
7:05
Video 30
Generated columns
8:03
Video 31
Text search types
7:42
Video 32
Bit string
5:15
Video 33
Ranges
15:39
Video 34
Composite types
4:19
Video 35
Nulls
3:52
Video 36
Unique constraints
5:38
Video 37
Exclusion constraints
6:52
Video 38
Foreign key constraints
10:50
Module 4
Indexing
Video 39
Introduction to indexes
5:27
Video 40
Heaps and CTIDs
4:18
Video 41
B-Tree overview
5:02
Video 42
Primary keys vs. secondary indexes
3:00
Video 43
Primary key types
7:13
Video 44
Where to add indexes
8:44
Video 45
Index selectivity
9:15
Video 46
Composite indexes
8:44
Video 47
Composite range
3:08
Video 48
Combining multiple indexes
4:34
Video 49
Covering indexes
8:54
Video 50
Partial indexes
6:29
Video 51
Index ordering
4:00
Video 52
Ordering nulls in indexes
2:35
Module 5
Advanced Indexing
Video 53
Functional indexes
5:22
Video 54
Duplicate indexes
3:04
Video 55
Hash indexes
4:13
Video 56
Naming indexes
2:16
Module 6
Understanding Query Plans
Video 57
Introduction to explain
1:25
Video 58
Explain structure
5:17
Video 59
Scan nodes
11:28
Video 60
Costs and rows
8:23
Video 61
Explain analyze
2:38
Module 7
Generating Results
Video 62
Introduction to queries
1:25
Video 63
Cross joins
5:21
Video 64
Inner joins
6:19
Video 65
Outer joins
5:40
Video 66
Subqueries
6:38
Video 67
Lateral joins
6:22
Video 68
ROWS FROM
3:44
Video 69
Filling gaps in sequences
6:56
Video 70
Subquery elimination
14:21
Video 71
Combining queries
7:58
Video 72
Set generating functions
6:21
Video 73
Indexing joins
4:47
Module 8
Advanced SQL
Video 74
Introduction to advanced SQL
1:26
Video 75
Grouping
11:07
Video 76
Grouping sets, rollups, cubes
7:14
Video 77
Window functions
18:10
Video 78
CTEs
10:31
Video 79
CTEs with window functions
10:35
Video 80
Recursive CTE
6:44
Video 81
Hierarchical recursive CTE
6:20
Video 82
Handling nulls
6:51
Video 83
Row value syntax
11:44
Video 84
Views
7:44
Video 85
Materialized views
10:52
Video 86
Removing duplicate rows
5:00
Video 87
Upsert
8:38
Video 88
Returning keyword
4:00
Video 89
COALESCE + generated column
4:31
Module 9
Full Text Search
Video 90
Introduction to full text search
3:01
Video 91
Searching with LIKE
3:03
Video 92
Vectors, queries, and ranks
8:09
Video 93
Websearch
5:56
Video 94
Ranking
14:10
Video 95
Indexing full text search
6:08
Video 96
Highlighting
3:32
Module 10
JSON
(Coming Soon)
Video 97 (Coming soon)
Intro to JSON
Video 98 (Coming soon)
Argument types: path, value, JSON
Video 99 (Coming soon)
Validating JSON
Video 100 (Coming soon)
Creating JSON objects + arrays
Video 101 (Coming soon)
JSON Extraction
Video 102 (Coming soon)
Updating JSON
Video 103 (Coming soon)
JSON aggregates
Video 104 (Coming soon)
JSON table functions
Video 105 (Coming soon)
Indexing JSON parts
Module 11
Operating Postgres
(Coming Soon)
Video 106 (Coming soon)
Roles & permissions
Video 107 (Coming soon)
Vacuum
Video 108 (Coming soon)
Analyze
Video 109 (Coming soon)
Connections
Video 110 (Coming soon)
Backups
Video 111 (Coming soon)
Replication
Module 12
Popular Extensions
(Coming Soon)
Video 112 (Coming soon)
Installing extensions
Module 13
Bonus interviews
Video 113
Heroku's glory days & Postgres vs the world (with Craig Kerstiens)
Free
62:45
Video 114
Creating a Postgres platform with Monica & Tudor from Xata.io
Free
61:21
Video 115
Bootstrapping an email service provider (with Jesse Hanley)
Free
81:58

Meet your instructor

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 hello@aaronfrancis.com.

Ready to start watching?

Watching solo? Or looking to get your team up to speed? We've got you covered.

Full Course
Early Access

$
249
$349
USD, plus local taxes

96 in-depth video tutorials

Nearly 11 hours of content

Future video releases included

Lifetime access

Optimize Postgres for production workloads

Understand database indexes at a deep level

Team Pricing

$
1,199
$1,245
USD, plus local taxes

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.

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
M Wildan Zulfikar

Frequently Asked Questions

I'm having issues with the course. Who can I contact?

Oh no! Send us an email at support@aaronfrancis.com.

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!

© 2024 Try Hard Studios, LLC