CF

Mastering Postgres | The most comprehensive course on PostgreSQL

16h 13m 30s
English
Paid

Your application operates at the speed of the slowest query, regardless of the language, framework, or platform you use. The course "Mastering Postgres" is a comprehensive video course that will help you improve your applications and career.

You will gain a deep understanding of the core principles of PostgreSQL through real-life examples. You will learn about the various data types that Postgres offers, when it's best to use them, and more importantly, when not to use them. You will understand how indexes work, learn to improve them, and maintain your database at peak performance.

"Mastering Postgres" is the best way to learn Postgres and enhance your applications and career. The course covers everything from fundamental principles to advanced topics like indexes and data types.

Learn the Basics, Master the Complexities

Start with basic knowledge and gradually move on to complex topics, including indexing and working with various data types.

Become a Full-Text Search Master

Learn how to use Postgres's full-text search capabilities to create powerful search functions.

Become an Index Expert

Indexes are key to fast queries. Learn how to create and use them to speed up database performance.

Your application will operate only as fast as your slowest query, regardless of the language, framework, or platform. This course will help you gain deeper insight into PostgreSQL through real-life examples, enhance indexing, and keep your database performing at its best.

Additional

Early Access

About the Author: Aaron Francis

Aaron Francis thumbnail

Aaron Francis is a Texas-based developer and educator who runs Try Hard Studios and is best known in the PHP / Laravel community for his deep production-database content. His videos and courses focus on the parts of working software that don't get attention from the framework documentation: SQL performance, database internals, and the realities of running databases at scale.

His CourseFlix listing reflects that focus — three database courses (High Performance SQLite, Mastering Postgres, MySQL for Developers) plus two on screencasting craft (Screencasting.com and Screenflow for Screencasters) covering the workflow he uses to produce the database material itself. The database courses are unusually rigorous for the YouTube-tutorial market: each one runs many hours and treats the database as a first-class object of study, not a black box behind an ORM.

Watch Online 118 lessons

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 118 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Introduction to the course
All Course Lessons (118)
#Lesson TitleDurationAccess
1
Introduction to the course Demo
02:15
2
Overview of course structure
03:41
3
Postgres vs. everyone
02:09
4
The psql CLI
02:39
5
Introduction to schema
06:46
6
Integers
09:40
7
Numeric
09:51
8
Floating point
08:05
9
Storing money
08:17
10
NaNs and infinity
03:45
11
Casting types
05:36
12
Characters types
07:43
13
Check constrai
08:55
14
Domain types
07:49
15
Chars and collations
07:48
16
Binary data
09:01
17
UUIDs
06:20
18
Boolean
03:48
19
Enums
12:45
20
Timestamps
12:44
21
Timezones
13:13
22
Dates and times
07:51
23
Intervals
05:47
24
Serial type
09:53
25
Sequences
04:50
26
Identity
07:03
27
Network and mac addresses
04:49
28
JSON
10:18
29
Arrays
07:05
30
Generated columns
08:03
31
Text search types
07:43
32
Bit string
05:16
33
Ranges
15:40
34
Composite types
04:20
35
Nulls
03:53
36
Unique constrai
05:38
37
Exclusion constrai
06:52
38
Foreign key constrai
10:51
39
Introduction to indexes
05:28
40
Heaps and CTIDs
04:18
41
B-Tree overview
05:02
42
Primary keys vs. secondary indexes
03:01
43
Primary key types
07:13
44
Where to add indexes
08:45
45
Index selectivity
09:16
46
Composite indexes
08:45
47
Composite range
03:09
48
Combining multiple indexes
04:34
49
Covering indexes
08:54
50
Partial indexes
06:30
51
Index ordering
04:01
52
Ordering nulls in indexes
02:36
53
Functional indexes
05:23
54
Duplicate indexes
03:05
55
Hash indexes
04:13
56
Naming indexes
02:17
57
Introduction to explain
01:25
58
Explain structure
05:17
59
Scan nodes
11:29
60
Co and rows
08:24
61
Explain analyze
02:39
62
Introduction to queries
01:26
63
Inner joins
06:19
64
Outer joins
05:41
65
Subqueries
06:38
66
Lateral joins
06:23
67
ROWS FROM
03:45
68
Filling gaps in sequences
06:56
69
Subquery elimination
14:21
70
Combining queries
07:58
71
Set generating functions
06:22
72
Indexing joins
04:47
73
Introduction to advanced SQL
01:26
74
Cross joins
05:21
75
Grouping
11:08
76
Grouping s, rollups, cubes
07:15
77
Window functions
18:11
78
CTEs
10:31
79
CTEs with window functions
10:35
80
Recursive CTE
06:45
81
Hierarchical recursive CTE
06:20
82
Handling nulls
06:51
83
Row value syntax
11:44
84
Views
07:44
85
Materialized views
10:53
86
Removing duplicate rows
05:01
87
Upsert
08:38
88
Returning keyword
04:00
89
COALESCE + generated column
04:32
90
Introduction to full text search
03:01
91
Searching with LIKE
03:04
92
Vectors, queries, and ranks
08:10
93
Websearch
05:56
94
Ranking
14:10
95
Indexing full text search
06:09
96
Highlighting
03:32
97
Intro to JSON
03:16
98
JSON vs JSONB
04:17
99
Validating JSON
04:42
100
Creating JSON objects + arrays
08:21
101
JSON extraction
08:25
102
JSON containment
04:15
103
JSON existence
03:04
104
JSON recordset
08:42
105
Updating JSON
11:54
106
Indexing JSON parts
10:09
107
GIN index
06:15
108
Intro to pgvector
02:18
109
Vector embedding columns
08:00
110
Find related articles
09:22
111
Upsert vector embedding
03:02
112
Semantic search
05:36
113
Other operators
03:06
114
Vector indexes
05:00
115
Thank you
01:42
116
Heroku's glory days & Postgres vs the world (with Craig Kerstiens)
01:02:46
117
Creating a Postgres platform with Monica & Tudor from Xata.io
01:01:21
118
Bootstrapping an email service provider (with Jesse Hanley)
01:21:58
Unlock unlimited learning

Get instant access to all 117 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Related courses

  • PostgreSQL High Performance Tuning Guide thumbnailUpdated 2y ago

    PostgreSQL High Performance Tuning Guide

    By: Udemy
    PostgreSQL is one of the most powerful and convenient database management systems.
    2h 41m
  • Effective Database Design thumbnailUpdated 2y ago

    Effective Database Design

    By: Ben Brumm
    The course "Effective Database Design" will provide you with an action plan, examples, and instructions for creating a well-designed database.
    1h 3m5/5
  • DBMS thumbnailUpdated 8mo ago

    DBMS

    By: takeUforward (Striver)
    This course is dedicated to the study of Database Management Systems (DBMS) - technologies that allow for efficient storage, processing, and protection of data.
    21h 30m5/5

Frequently asked questions

What prerequisites should I have before enrolling in this course?
Before enrolling in this course, it's beneficial to have a basic understanding of databases and SQL. Familiarity with database management concepts will help you grasp topics like schema design and indexing more efficiently. The course starts with fundamental principles, so even if you're not an expert, you can gradually build up your knowledge.
What kind of projects or exercises will I work on during the course?
Throughout the course, you will engage in practical exercises that involve using PostgreSQL's full-text search capabilities and creating various types of indexes. You'll also work on real-life examples that demonstrate how to improve database performance and maintain it effectively. These hands-on exercises are designed to deepen your understanding of PostgreSQL's core principles.
Who is the target audience for this course?
The course is designed for software developers, database administrators, and anyone interested in enhancing their database management skills. Whether you're a beginner looking to understand the basics or an experienced professional aiming to master complex topics like indexing and full-text search, this course caters to various skill levels.
How does this course compare to other PostgreSQL courses in terms of depth and scope?
This course offers a comprehensive exploration of PostgreSQL, covering everything from basic data types and schema design to advanced topics like full-text search and complex indexing strategies. With 118 lessons, it provides an in-depth understanding that might surpass other courses that focus only on specific aspects of PostgreSQL.
What specific tools or platforms will I learn to use in this course?
You will learn to use the psql CLI, which is crucial for interacting with PostgreSQL databases. The course also covers various data types, indexing techniques, and the full-text search capabilities of PostgreSQL, allowing you to leverage these tools for efficient database management.
Are there any topics or areas that this course does not cover?
While the course covers a wide range of topics related to PostgreSQL, it does not delve into non-PostgreSQL databases or systems. The focus remains on PostgreSQL's capabilities and how to optimize its performance, rather than covering other database technologies.
What is the time commitment required to complete this course?
The course comprises 118 lessons, with a total runtime that has yet to be specified. Given the comprehensive nature of the material, students should be prepared to invest a significant amount of time to thoroughly understand each topic and complete the practical exercises.