Mastering Postgres - The most comprehensive course on PostgreSQL Feb 2025

1. 0118. Bootstrapping an email service provider with Jesse Hanley.mp41.06GB
2. 0002. Overview of course structure.mp417.73MB
3. 0003. Postgres vs everyone.mp414.85MB
4. 0004. The psql CLI.mp49.56MB
5. 0005. Introduction to schema.mp441.93MB
6. 0006. Integers.mp427.74MB
7. 0007. Numeric.mp433.77MB
8. 0008. Floating point.mp426.3MB
9. 0009. Storing money.mp422.72MB
10. 0010. NaNs and infinity.mp49.23MB
11. 0011. Casting types.mp413.65MB
12. 0012. Characters types.mp428.66MB
13. 0013. Check constrai.mp436.29MB
14. 0014. Domain types.mp430.16MB
15. 0015. Chars and collations.mp423.54MB
16. 0016. Binary data.mp435.39MB
17. 0017. UUIDs.mp421.76MB
18. 0018. Boolean.mp411.41MB
19. 0019. Enums.mp446.05MB
20. 0020. Timestamps.mp443.65MB
21. 0021. Timezones.mp448.65MB
22. 0022. Dates and times.mp430.08MB
23. 0023. Intervals.mp420.98MB
24. 0024. Serial type.mp440.13MB
25. 0025. Sequences.mp411.82MB
26. 0026. Identity.mp482.09MB
27. 0027. Network and mac addresses.mp415.95MB
28. 0028. JSON.mp444.7MB
29. 0029. Arrays.mp427.34MB
30. 0030. Generated columns.mp434.03MB
31. 0031. Text search types.mp423.03MB
32. 0032. Bit string.mp422.35MB
33. 0033. Ranges.mp452.51MB
34. 0034. Composite types.mp415.82MB
35. 0035. Nulls.mp421.33MB
36. 0036. Unique constrai.mp417.16MB
37. 0037. Exclusion constrai.mp421.83MB
38. 0038. Foreign key constrai.mp449.12MB
39. 0039. Introduction to indexes.mp439.34MB
40. 0040. Heaps and CTIDs.mp421.89MB
41. 0041. B Tree overview.mp422.81MB
42. 0042. Primary keys vs secondary indexes.mp419.9MB
43. 0043. Primary key types.mp453.36MB
44. 0044. Where to add indexes.mp436.85MB
45. 0045. Index selectivity.mp440.3MB
46. 0046. Composite indexes.mp443.76MB
47. 0047. Composite range.mp419.53MB
48. 0048. Combining multiple indexes.mp419.85MB
49. 0049. Covering indexes.mp447.13MB
50. 0050. Partial indexes.mp429.78MB
51. 0051. Index ordering.mp412.07MB
52. 0052. Ordering nulls in indexes.mp48.99MB
53. 0053. Functional indexes.mp421.15MB
54. 0054. Duplicate indexes.mp410.21MB
55. 0055. Hash indexes.mp422.85MB
56. 0056. Naming indexes.mp46.92MB
57. 0057. Introduction to explain.mp48.93MB
58. 0058. Explain structure.mp418.42MB
59. 0059. Scan nodes.mp450.8MB
60. 0060. Co and rows.mp424.05MB
61. 0061. Explain analyze.mp410.27MB
62. 0062. Introduction to queries.mp410.07MB
63. 0063. Inner joins.mp425.33MB
64. 0064. Outer joins.mp424.4MB
65. 0065. Subqueries.mp428.05MB
66. 0066. Lateral joins.mp422.71MB
67. 0067. ROWS FROM.mp412.12MB
68. 0068. Filling gaps in sequences.mp419.8MB
69. 0069. Subquery elimination.mp446.64MB
70. 0070. Combining queries.mp425.94MB
71. 0071. Set generating functions.mp420.45MB
72. 0072. Indexing joins.mp416.34MB
73. 0073. Introduction to advanced SQL.mp410.57MB
74. 0074. Cross joins.mp418.61MB
75. 0075. Grouping.mp435.88MB
76. 0076. Grouping s rollups cubes.mp424.74MB
77. 0077. Window functions.mp476.05MB
78. 0078. CTEs.mp435.22MB
79. 0079. CTEs with window functions.mp443.06MB
80. 0080. Recursive CTE.mp421.36MB
81. 0081. Hierarchical recursive CTE.mp421.97MB
82. 0082. Handling nulls.mp421.07MB
83. 0083. Row value syntax.mp440.18MB
84. 0084. Views.mp428.3MB
85. 0085. Materialized views.mp441.91MB
86. 0086. Removing duplicate rows.mp415.35MB
87. 0087. Upsert.mp430.32MB
88. 0088. Returning keyword.mp410.51MB
89. 0089. COALESCE generated column.mp416.58MB
90. 0090. Introduction to full text search.mp417.31MB
91. 0091. Searching with LIKE.mp48.35MB
92. 0092. Vectors queries and ranks.mp427.33MB
93. 0093. Websearch.mp427.47MB
94. 0094. Ranking.mp451.01MB
95. 0095. Indexing full text search.mp420.12MB
96. 0096. Highlighting.mp416.97MB
97. 0097. Intro to JSON.mp438.63MB
98. 0098. JSON vs JSONB.mp452.45MB
99. 0099. Validating JSON.mp425.21MB
100. 0100. Creating JSON objects arrays.mp440.96MB
101. 0101. JSON extraction.mp443.58MB
102. 0102. JSON containment.mp416.46MB
103. 0103. JSON existence.mp415.05MB
104. 0104. JSON recordset.mp444.73MB
105. 0105. Updating JSON.mp453.63MB
106. 0106. Indexing JSON parts.mp456.77MB
107. 0107. GIN index.mp450.68MB
108. 0108. Intro to pgvector.mp426.88MB
109. 0109. Vector embedding columns.mp442.41MB
110. 0110. Find related articles.mp455.34MB
111. 0111. Upsert vector embedding.mp415.71MB
112. 0112. Semantic search.mp437.02MB
113. 0113. Other operators.mp424.05MB
114. 0114. Vector indexes.mp439.41MB
115. 0115. Thank you.mp419.55MB
116. 0116. Heroku s glory days Postgres vs the world with Craig Kerstiens.mp4912.84MB
117. 0117. Creating a Postgres platform with Monica Tudor from Xata io.mp41003.63MB
118. 0001. Introduction to the course.mp415.18MB
119. code/mp_demo_data/mp_demo_data726.95MB