CourseFlix

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

Course content

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

Related courses

  • Database Design & Implementation thumbnail

    Database Design & Implementation

    By: Nelson Djalo (Amigoscode)
    Backend starts from Your Database. When you have a solid database design coding is easy.
    2 hours 7 minutes 49 seconds 5 / 5
  • Effective Database Design thumbnail

    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.
    1 hour 3 minutes 56 seconds 5 / 5
  • Database DevOps from Start to Finish thumbnail

    Database DevOps from Start to Finish

    By: Tim Corey
    If you have only ever built a database using SQL Server Management Studio (SSMS), you are in for a treat. SQL Server Data Tools (SSDT) is designed for building
    2 hours 40 minutes 37 seconds

Frequently asked questions

What is Mastering Postgres | The most comprehensive course on PostgreSQL about?
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…
Who teaches Mastering Postgres | The most comprehensive course on PostgreSQL?
Mastering Postgres | The most comprehensive course on PostgreSQL is taught by Aaron Francis. You can find more courses by this instructor on the corresponding source page.
How long is Mastering Postgres | The most comprehensive course on PostgreSQL?
Mastering Postgres | The most comprehensive course on PostgreSQL contains 118 lessons with a total runtime of 16 hours 13 minutes. All lessons are available to watch online at your own pace.
Is Mastering Postgres | The most comprehensive course on PostgreSQL free to watch?
Mastering Postgres | The most comprehensive course on PostgreSQL is part of CourseFlix's premium catalog. A CourseFlix subscription unlocks the full video player; the course description, table of contents, and preview information are available to everyone.
Where can I watch Mastering Postgres | The most comprehensive course on PostgreSQL online?
Mastering Postgres | The most comprehensive course on PostgreSQL is available to watch online on CourseFlix at https://courseflix.net/course/mastering-postgres-the-most-comprehensive-course-on-postgresql. The page hosts every lesson with the integrated video player; no download is required.