01 -Introduction-to-the-course (15.18 MB)
02 -Overview-of-course-structure (17.73 MB)
03 -Postgres-vs -everyone (14.85 MB)
04 -The-psql-CLI (9.56 MB)
05 -Introduction-to-schema (41.93 MB)
06 -Integers (27.74 MB)
07 -Numeric (33.77 MB)
08 -Floating-point (26.3 MB)
09 -Storing-money (22.72 MB)
10 -NaNs-and-infinity (9.23 MB)
11 -Casting-types (13.65 MB)
12 -Characters-types (28.66 MB)
13 -Check-constraints (36.29 MB)
14 -Domain-types (30.16 MB)
15 -Charsets-and-collations (23.54 MB)
16 -Binary-data (35.39 MB)
17 -UUIDs (21.76 MB)
18 -Boolean (11.41 MB)
19 -Enums (46.05 MB)
20 -Timestamps (43.65 MB)
21 -Timezones (48.65 MB)
22 -Dates-and-times (30.08 MB)
23 -Intervals (20.98 MB)
24 -Serial-type (40.13 MB)
25 -Sequences (11.82 MB)
26 -Identity (82.09 MB)
27 -Network-and-mac-addresses (15.95 MB)
28 -JSON (44.7 MB)
29 -Arrays (27.34 MB)
30 -Generated-columns (34.03 MB)
31 -Text-search-types (23.03 MB)
32 -Bit-string (22.35 MB)
33 -Ranges (52.51 MB)
34 -Composite-types (15.82 MB)
35 -Nulls (21.33 MB)
36 -Unique-constraints (17.16 MB)
37 -Exclusion-constraints (21.83 MB)
38 -Foreign-key-constraints (49.12 MB)
39 -Introduction-to-indexes (39.34 MB)
40 -Heaps-and-CTIDs (21.89 MB)
41 -B-Tree-overview (22.81 MB)
42 -Primary-keys-vs -secondary-indexes (19.9 MB)
43 -Primary-key-types (53.36 MB)
44 -Where-to-add-indexes (36.85 MB)
45 -Index-selectivity (40.3 MB)
46 -Composite-indexes (43.76 MB)
47 -Composite-range (19.53 MB)
48 -Combining-multiple-indexes (19.85 MB)
49 -Covering-indexes (47.13 MB)
50 -Partial-indexes (29.78 MB)
51 -Index-ordering (12.07 MB)
52 -Ordering-nulls-in-indexes (8.99 MB)
53 -Functional-indexes (21.15 MB)
54 -Duplicate-indexes (10.21 MB)
55 -Hash-indexes (22.85 MB)
56 -Naming-indexes (6.92 MB)
57 -Introduction-to-explain (8.93 MB)
58 -Explain-structure (18.42 MB)
59 -Scan-nodes (50.8 MB)
60 -Costs-and-rows (24.05 MB)
61 -Explain-analyze (10.27 MB)
62 -Introduction-to-queries (10.07 MB)
63 -Inner-joins (25.33 MB)
64 -Outer-joins (24.4 MB)
65 -Subqueries (28.05 MB)
66 -Lateral-joins (22.71 MB)
67 -ROWS-FROM (12.12 MB)
68 -Filling-gaps-in-sequences (19.8 MB)
69 -Subquery-elimination (46.64 MB)
70 -Combining-queries (25.94 MB)
71 -Set-generating-functions (20.45 MB)
72 -Indexing-joins (16.34 MB)
73 -Introduction-to-advanced-SQL (10.57 MB)
74 -Cross-joins (18.61 MB)
75 -Grouping (35.88 MB)
76 -Grouping-sets -rollups -cubes (24.74 MB)
77 -Window-functions (76.05 MB)
78 -CTEs (35.22 MB)
79 -CTEs-with-window-functions (43.06 MB)
80 -Recursive-CTE (21.36 MB)
81 -Hierarchical-recursive-CTE (21.97 MB)
82 -Handling-nulls (21.07 MB)
83 -Row-value-syntax (40.18 MB)
84 -Views (28.3 MB)
85 -Materialized-views (41.91 MB)
86 -Removing-duplicate-rows (15.35 MB)
87 -Upsert (30.32 MB)
88 -Returning-keyword (10.51 MB)
89 -COALESCE-generated-column (16.58 MB)
90 -Introduction-to-full-text-search (17.31 MB)
91 -Searching-with-LIKE (8.35 MB)
92 -Vectors -queries -and-ranks (27.33 MB)
93 -Websearch (27.47 MB)
94 -Ranking (51.01 MB)
95 -Indexing-full-text-search (20.12 MB)
96 -Highlighting (16.97 MB)
97 -Heroku s-glory-days- -Postgres-vs-the-world- with-Craig-Kerstiens (456.85 MB)
98 -Creating-a-Postgres-platform-with-Monica- -Tudor-from-Xata io (600.02 MB)
99 -Bootstrapping-an-email-service-provider- with-Jesse-Hanley (690.26 MB)