Udemy - SQL and PostgreSQL The Complete Developer's Guide

File Type Create Time File Size Seeders Leechers Updated
Movie 2022-10-25 5.02GB 0 1 5 months ago
Download
Magnet link   or   Save Instantly without Torrenting   or   Torrent download

To download this file, you need a free bitTorrent client such as qBittorrent.

Report Abuse
Tags
Udemy  SQL  and  PostgreSQL  The  Complete  Developer  Guide  
Related Torrents
  1. [GigaCourse.Com] Udemy - The Vue 3 Bootcamp The Complete Developer Guide 8.80GB
  2. [ FreeCryptoLearn.com ] Udemy - Cryptocurrency and bitcoin, the complete crypto course 2024 3.57GB
  3. [GigaCourse.Com] Udemy - ChatGPT and LangChain The Complete Developers Masterclass 4.45GB
  4. Udemy - Go The Complete Developer's Guide (Golang) 4.85GB
  5. [FreeCourseSite.com] Udemy - The Modern React 18 Bootcamp - A Complete Developer Guide 7.65GB
  6. [FreeCourseSite.com] Udemy - ES6 Javascript The Complete Developer's Guide 1010.43MB
  7. [FreeCourseSite.com] Udemy - Next JS The Complete Developer's Guide 5.16GB
  8. [GigaCourse.Com] Udemy - Go The Complete Developer's Guide (Golang) 4.85GB
  9. Udemy - The Complete Git Guide Understand and master Git and GitHub 7.52GB
  10. Udemy - The Complete Git Guide Understand and master Git and GitHub 7.52GB
Files
  1. 22 - Understanding the Internals of PostgreSQL/005 Heap File Layout.mp4 338.62MB
  2. 01 - Simple - But Powerful - SQL Statements/002 Course Resources.html 1.25KB
  3. 01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About_.mp4 21.75MB
  4. 01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About___en.srt 7.24KB
  5. 01 - Simple - But Powerful - SQL Statements/004 Database Design.mp4 35.37MB
  6. 01 - Simple - But Powerful - SQL Statements/004 Database Design__en.srt 7.97KB
  7. 01 - Simple - But Powerful - SQL Statements/005 Creating Tables.mp4 18.61MB
  8. 01 - Simple - But Powerful - SQL Statements/005 Creating Tables__en.srt 7.50KB
  9. 01 - Simple - But Powerful - SQL Statements/006 Analyzing CREATE TABLE.mp4 11.38MB
  10. 01 - Simple - But Powerful - SQL Statements/006 Analyzing CREATE TABLE__en.srt 5.36KB
  11. 01 - Simple - But Powerful - SQL Statements/007 Inserting Data Into a Table.mp4 12.12MB
  12. 01 - Simple - But Powerful - SQL Statements/007 Inserting Data Into a Table__en.srt 7.38KB
  13. 01 - Simple - But Powerful - SQL Statements/008 Retrieving Data with Select.mp4 4.05MB
  14. 01 - Simple - But Powerful - SQL Statements/008 Retrieving Data with Select__en.srt 3.21KB
  15. 01 - Simple - But Powerful - SQL Statements/009 Calculated Columns.mp4 10.37MB
  16. 01 - Simple - But Powerful - SQL Statements/009 Calculated Columns__en.srt 7.14KB
  17. 01 - Simple - But Powerful - SQL Statements/010 Calculating Phone Revenue.mp4 2.19MB
  18. 01 - Simple - But Powerful - SQL Statements/010 Calculating Phone Revenue__en.srt 1.52KB
  19. 01 - Simple - But Powerful - SQL Statements/011 Exercise Solution.mp4 2.17MB
  20. 01 - Simple - But Powerful - SQL Statements/011 Exercise Solution__en.srt 1.57KB
  21. 01 - Simple - But Powerful - SQL Statements/012 String Operators and Functions.mp4 11.34MB
  22. 01 - Simple - But Powerful - SQL Statements/012 String Operators and Functions__en.srt 9.62KB
  23. 01 - Simple - But Powerful - SQL Statements/28579121-003-sql.sql 104B
  24. 01 - Simple - But Powerful - SQL Statements/28579125-005-sql-cumulative.sql 384B
  25. 01 - Simple - But Powerful - SQL Statements/28579127-005-sql.sql 278B
  26. 01 - Simple - But Powerful - SQL Statements/28579131-012-sql.sql 404B
  27. 01 - Simple - But Powerful - SQL Statements/37099256-diagrams.zip 7.72MB
  28. 02 - Filtering Records/001 Filtering Rows with _Where_.mp4 8.43MB
  29. 02 - Filtering Records/001 Filtering Rows with _Where___en.srt 5.63KB
  30. 02 - Filtering Records/002 More on the _Where_ Keyword.mp4 6.00MB
  31. 02 - Filtering Records/002 More on the _Where_ Keyword__en.srt 3.75KB
  32. 02 - Filtering Records/003 Compound _Where_ Clauses.mp4 12.76MB
  33. 02 - Filtering Records/003 Compound _Where_ Clauses__en.srt 7.41KB
  34. 02 - Filtering Records/004 A _Where_ Exercise Overview.mp4 1.22MB
  35. 02 - Filtering Records/004 A _Where_ Exercise Overview__en.srt 962B
  36. 02 - Filtering Records/005 A _Where_ Solution.mp4 1.89MB
  37. 02 - Filtering Records/005 A _Where_ Solution__en.srt 1.32KB
  38. 02 - Filtering Records/006 _Where_ With Lists.mp4 1.12MB
  39. 02 - Filtering Records/006 _Where_ With Lists__en.srt 1.02KB
  40. 02 - Filtering Records/007 A _Where_ With Lists Solution.mp4 3.56MB
  41. 02 - Filtering Records/007 A _Where_ With Lists Solution__en.srt 2.29KB
  42. 02 - Filtering Records/008 Calculations in _Where_ Clauses.mp4 3.41MB
  43. 02 - Filtering Records/008 Calculations in _Where_ Clauses__en.srt 3.00KB
  44. 02 - Filtering Records/009 Solving Calculations.mp4 4.15MB
  45. 02 - Filtering Records/010 Updating Rows.mp4 11.69MB
  46. 02 - Filtering Records/010 Updating Rows__en.srt 6.30KB
  47. 02 - Filtering Records/011 Deleting Rows.mp4 9.13MB
  48. 02 - Filtering Records/011 Deleting Rows__en.srt 4.88KB
  49. 02 - Filtering Records/012 A Solution for Updating Rows.mp4 3.42MB
  50. 02 - Filtering Records/012 A Solution for Updating Rows__en.srt 2.13KB
  51. 02 - Filtering Records/013 Solution for Deleting Rows.mp4 2.76MB
  52. 02 - Filtering Records/013 Solution for Deleting Rows__en.srt 1.96KB
  53. 02 - Filtering Records/28579133-013-sql.sql 48B
  54. 03 - Working with Tables/001 The Plan Moving Forward.mp4 7.08MB
  55. 03 - Working with Tables/001 The Plan Moving Forward__en.srt 2.72KB
  56. 03 - Working with Tables/002 Approaching Database Design.mp4 30.49MB
  57. 03 - Working with Tables/002 Approaching Database Design__en.srt 11.75KB
  58. 03 - Working with Tables/003 One-to-Many and Many-to-One Relationships.mp4 26.25MB
  59. 03 - Working with Tables/003 One-to-Many and Many-to-One Relationships__en.srt 9.85KB
  60. 03 - Working with Tables/004 One-to-One and Many-to-Many Relationships.mp4 15.27MB
  61. 03 - Working with Tables/004 One-to-One and Many-to-Many Relationships__en.srt 8.51KB
  62. 03 - Working with Tables/005 Primary Keys and Foreign Keys.mp4 18.82MB
  63. 03 - Working with Tables/005 Primary Keys and Foreign Keys__en.srt 7.68KB
  64. 03 - Working with Tables/006 Understanding Foreign Keys.mp4 41.56MB
  65. 03 - Working with Tables/006 Understanding Foreign Keys__en.srt 12.60KB
  66. 03 - Working with Tables/007 Auto-Generated ID's.mp4 14.63MB
  67. 03 - Working with Tables/007 Auto-Generated ID's__en.srt 8.69KB
  68. 03 - Working with Tables/008 Creating Foreign Key Columns.mp4 12.01MB
  69. 03 - Working with Tables/008 Creating Foreign Key Columns__en.srt 7.25KB
  70. 03 - Working with Tables/009 Running Queries on Associated Data.mp4 24.52MB
  71. 03 - Working with Tables/009 Running Queries on Associated Data__en.srt 10.06KB
  72. 03 - Working with Tables/010 Exercise Overview.mp4 5.34MB
  73. 03 - Working with Tables/010 Exercise Overview__en.srt 3.31KB
  74. 03 - Working with Tables/011 Foreign Key Creation Solution.mp4 5.39MB
  75. 03 - Working with Tables/011 Foreign Key Creation Solution__en.srt 2.95KB
  76. 03 - Working with Tables/012 Foreign Key Constraints Around Insertion.mp4 16.89MB
  77. 03 - Working with Tables/012 Foreign Key Constraints Around Insertion__en.srt 8.51KB
  78. 03 - Working with Tables/013 Constraints Around Deletion.mp4 25.98MB
  79. 03 - Working with Tables/013 Constraints Around Deletion__en.srt 7.47KB
  80. 03 - Working with Tables/014 Commands You8217ll Need for the Next Video.html 691B
  81. 03 - Working with Tables/015 Testing Deletion Constraints.mp4 14.19MB
  82. 03 - Working with Tables/015 Testing Deletion Constraints__en.srt 6.58KB
  83. 03 - Working with Tables/016 Setting Foreign Keys to Null on Delete.mp4 8.26MB
  84. 03 - Working with Tables/016 Setting Foreign Keys to Null on Delete__en.srt 4.29KB
  85. 03 - Working with Tables/017 Adding Some Complexity.mp4 6.78MB
  86. 03 - Working with Tables/017 Adding Some Complexity__en.srt 4.66KB
  87. 03 - Working with Tables/28579153-007-tables-cumulative.sql 172B
  88. 03 - Working with Tables/28579155-007-tables.sql 194B
  89. 03 - Working with Tables/28579157-008-tables-cumulative.sql 348B
  90. 03 - Working with Tables/28579159-008-tables.sql 197B
  91. 03 - Working with Tables/28579161-009-tables-cumulative.sql 536B
  92. 03 - Working with Tables/28579163-009-tables.sql 326B
  93. 03 - Working with Tables/28579179-012-tables-cumulative.sql 600B
  94. 03 - Working with Tables/28579183-012-tables.sql 199B
  95. 03 - Working with Tables/28579187-014-tables-cumulative.sql 994B
  96. 03 - Working with Tables/28579189-014-tables.sql 469B
  97. 03 - Working with Tables/28579191-015-tables-cumulative.sql 1.28KB
  98. 03 - Working with Tables/28579193-015-tables.sql 340B
  99. 04 - Relating Records with Joins/001 Adding Some Data.html 7.66KB
  100. 04 - Relating Records with Joins/002 Queries with Joins and Aggregations.mp4 17.77MB
  101. 04 - Relating Records with Joins/002 Queries with Joins and Aggregations__en.srt 5.06KB
  102. 04 - Relating Records with Joins/003 Joining Data from Different Tables.mp4 27.41MB
  103. 04 - Relating Records with Joins/003 Joining Data from Different Tables__en.srt 11.51KB
  104. 04 - Relating Records with Joins/004 Another Quick Join.mp4 5.62MB
  105. 04 - Relating Records with Joins/004 Another Quick Join__en.srt 3.15KB
  106. 04 - Relating Records with Joins/005 Exercise Overview.mp4 3.09MB
  107. 04 - Relating Records with Joins/005 Exercise Overview__en.srt 1.73KB
  108. 04 - Relating Records with Joins/006 A Joinful Solution.mp4 3.47MB
  109. 04 - Relating Records with Joins/006 A Joinful Solution__en.srt 2.50KB
  110. 04 - Relating Records with Joins/007 Alternate Forms of Syntax.mp4 14.42MB
  111. 04 - Relating Records with Joins/007 Alternate Forms of Syntax__en.srt 9.11KB
  112. 04 - Relating Records with Joins/008 Missing Data in Joins.mp4 19.08MB
  113. 04 - Relating Records with Joins/008 Missing Data in Joins__en.srt 9.53KB
  114. 04 - Relating Records with Joins/009 Why Wasn't It Included.mp4 14.99MB
  115. 04 - Relating Records with Joins/009 Why Wasn't It Included__en.srt 3.68KB
  116. 04 - Relating Records with Joins/010 Four Kinds of Joins.mp4 75.29MB
  117. 04 - Relating Records with Joins/010 Four Kinds of Joins__en.srt 14.40KB
  118. 04 - Relating Records with Joins/011 Each Join in Practice.mp4 23.44MB
  119. 04 - Relating Records with Joins/011 Each Join in Practice__en.srt 6.12KB
  120. 04 - Relating Records with Joins/012 Does Order Matter_.mp4 35.92MB
  121. 04 - Relating Records with Joins/012 Does Order Matter___en.srt 6.26KB
  122. 04 - Relating Records with Joins/013 Exercise Overview.mp4 1.53MB
  123. 04 - Relating Records with Joins/013 Exercise Overview__en.srt 1.43KB
  124. 04 - Relating Records with Joins/014 Two Possible Solutions.mp4 10.19MB
  125. 04 - Relating Records with Joins/014 Two Possible Solutions__en.srt 4.60KB
  126. 04 - Relating Records with Joins/015 Where with Join.mp4 20.21MB
  127. 04 - Relating Records with Joins/015 Where with Join__en.srt 10.03KB
  128. 04 - Relating Records with Joins/016 Three Way Joins.mp4 32.08MB
  129. 04 - Relating Records with Joins/016 Three Way Joins__en.srt 11.90KB
  130. 04 - Relating Records with Joins/017 A Bit of Practice.mp4 11.53MB
  131. 04 - Relating Records with Joins/017 A Bit of Practice__en.srt 7.47KB
  132. 04 - Relating Records with Joins/018 Exercise Solution.mp4 5.44MB
  133. 04 - Relating Records with Joins/018 Exercise Solution__en.srt 3.88KB
  134. 04 - Relating Records with Joins/28571441-009-joins-cheatsheet.pdf 190.52KB
  135. 04 - Relating Records with Joins/28595533-007-joins-cumulative.sql 7.54KB
  136. 04 - Relating Records with Joins/28595535-010-sql-cumulative.sql 7.59KB
  137. 05 - Aggregation of Records/001 Aggregating and Grouping.mp4 5.34MB
  138. 05 - Aggregation of Records/001 Aggregating and Grouping__en.srt 3.46KB
  139. 05 - Aggregation of Records/002 Picturing Group By.mp4 30.92MB
  140. 05 - Aggregation of Records/002 Picturing Group By__en.srt 8.06KB
  141. 05 - Aggregation of Records/003 Aggregate Functions.mp4 7.62MB
  142. 05 - Aggregation of Records/003 Aggregate Functions__en.srt 4.42KB
  143. 05 - Aggregation of Records/004 Combining Group By and Aggregates.mp4 10.24MB
  144. 05 - Aggregation of Records/004 Combining Group By and Aggregates__en.srt 7.03KB
  145. 05 - Aggregation of Records/005 A Gotcha with Count.mp4 3.99MB
  146. 05 - Aggregation of Records/005 A Gotcha with Count__en.srt 4.05KB
  147. 05 - Aggregation of Records/006 Visualizing More Grouping.mp4 6.72MB
  148. 05 - Aggregation of Records/006 Visualizing More Grouping__en.srt 4.45KB
  149. 05 - Aggregation of Records/007 Exercise Overview.mp4 1.14MB
  150. 05 - Aggregation of Records/007 Exercise Overview__en.srt 1.12KB
  151. 05 - Aggregation of Records/008 Grouping Solution.mp4 2.23MB
  152. 05 - Aggregation of Records/008 Grouping Solution__en.srt 2.10KB
  153. 05 - Aggregation of Records/009 Adding a Layer of Difficulty.mp4 1.19MB
  154. 05 - Aggregation of Records/009 Adding a Layer of Difficulty__en.srt 1.08KB
  155. 05 - Aggregation of Records/010 Solution.mp4 2.59MB
  156. 05 - Aggregation of Records/010 Solution__en.srt 2.13KB
  157. 05 - Aggregation of Records/011 Filtering Groups with Having.mp4 23.90MB
  158. 05 - Aggregation of Records/011 Filtering Groups with Having__en.srt 7.54KB
  159. 05 - Aggregation of Records/012 Having In Action.mp4 4.69MB
  160. 05 - Aggregation of Records/012 Having In Action__en.srt 3.87KB
  161. 05 - Aggregation of Records/013 More on Having_.mp4 18.57MB
  162. 05 - Aggregation of Records/013 More on Having___en.srt 10.20KB
  163. 05 - Aggregation of Records/014 A Having Exercise Overview.mp4 8.40MB
  164. 05 - Aggregation of Records/014 A Having Exercise Overview__en.srt 5.36KB
  165. 05 - Aggregation of Records/015 A Quick Solution.mp4 5.19MB
  166. 05 - Aggregation of Records/015 A Quick Solution__en.srt 3.69KB
  167. 06 - Working with Large Datasets/001 A New Dataset.html 17.84KB
  168. 06 - Working with Large Datasets/002 Investigating This Dataset.mp4 5.42MB
  169. 06 - Working with Large Datasets/003 Some Group By Practice.mp4 2.09MB
  170. 06 - Working with Large Datasets/003 Some Group By Practice__en.srt 1.97KB
  171. 06 - Working with Large Datasets/004 Group By Review Solution.mp4 5.32MB
  172. 06 - Working with Large Datasets/004 Group By Review Solution__en.srt 3.43KB
  173. 06 - Working with Large Datasets/005 Remember Joins_.mp4 5.97MB
  174. 06 - Working with Large Datasets/005 Remember Joins___en.srt 3.45KB
  175. 06 - Working with Large Datasets/006 Of Course You Remember_.mp4 3.02MB
  176. 06 - Working with Large Datasets/006 Of Course You Remember___en.srt 2.06KB
  177. 06 - Working with Large Datasets/28595541-001-sq-data.sql 15.82KB
  178. 07 - Sorting Records/001 The Basics of Sorting.mp4 4.64MB
  179. 07 - Sorting Records/001 The Basics of Sorting__en.srt 3.51KB
  180. 07 - Sorting Records/002 Two Variations on Sorting.mp4 6.28MB
  181. 07 - Sorting Records/002 Two Variations on Sorting__en.srt 4.02KB
  182. 07 - Sorting Records/003 Offset and Limit.mp4 13.21MB
  183. 07 - Sorting Records/004 Exercise Overview.mp4 811.13KB
  184. 07 - Sorting Records/004 Exercise Overview__en.srt 692B
  185. 07 - Sorting Records/005 Exercise Solution.mp4 2.41MB
  186. 07 - Sorting Records/005 Exercise Solution__en.srt 1.99KB
  187. 08 - Unions and Intersections with Sets/001 Handling Sets with Union.mp4 13.00MB
  188. 08 - Unions and Intersections with Sets/001 Handling Sets with Union__en.srt 8.54KB
  189. 08 - Unions and Intersections with Sets/002 A Few Notes on Union.mp4 10.82MB
  190. 08 - Unions and Intersections with Sets/002 A Few Notes on Union__en.srt 5.53KB
  191. 08 - Unions and Intersections with Sets/003 Commonalities with Intersect.mp4 10.13MB
  192. 08 - Unions and Intersections with Sets/003 Commonalities with Intersect__en.srt 4.91KB
  193. 08 - Unions and Intersections with Sets/004 Removing Commonalities with Except.mp4 13.67MB
  194. 08 - Unions and Intersections with Sets/004 Removing Commonalities with Except__en.srt 9.22KB
  195. 08 - Unions and Intersections with Sets/005 Union Exercise Overview.mp4 2.97MB
  196. 08 - Unions and Intersections with Sets/005 Union Exercise Overview__en.srt 2.19KB
  197. 08 - Unions and Intersections with Sets/006 Exercise Solution.mp4 3.25MB
  198. 08 - Unions and Intersections with Sets/006 Exercise Solution__en.srt 2.02KB
  199. 09 - Assembling Queries with SubQueries/001 What's a Subquery_.mp4 19.43MB
  200. 09 - Assembling Queries with SubQueries/001 What's a Subquery___en.srt 8.67KB
  201. 09 - Assembling Queries with SubQueries/002 Thinking About the Structure of Data.mp4 15.19MB
  202. 09 - Assembling Queries with SubQueries/002 Thinking About the Structure of Data__en.srt 7.37KB
  203. 09 - Assembling Queries with SubQueries/003 Subqueries in a Select.mp4 15.15MB
  204. 09 - Assembling Queries with SubQueries/003 Subqueries in a Select__en.srt 8.29KB
  205. 09 - Assembling Queries with SubQueries/004 Exercise Overview.mp4 2.10MB
  206. 09 - Assembling Queries with SubQueries/004 Exercise Overview__en.srt 1.69KB
  207. 09 - Assembling Queries with SubQueries/005 Select Solution.mp4 2.62MB
  208. 09 - Assembling Queries with SubQueries/005 Select Solution__en.srt 1.77KB
  209. 09 - Assembling Queries with SubQueries/006 Subqueries in a From.mp4 28.32MB
  210. 09 - Assembling Queries with SubQueries/006 Subqueries in a From__en.srt 11.68KB
  211. 09 - Assembling Queries with SubQueries/007 From Subqueries that Return a Value.mp4 6.11MB
  212. 09 - Assembling Queries with SubQueries/007 From Subqueries that Return a Value__en.srt 4.21KB
  213. 09 - Assembling Queries with SubQueries/008 Example of a Subquery in a From.mp4 34.35MB
  214. 09 - Assembling Queries with SubQueries/008 Example of a Subquery in a From__en.srt 13.34KB
  215. 09 - Assembling Queries with SubQueries/009 Exercise Overview.mp4 2.40MB
  216. 09 - Assembling Queries with SubQueries/009 Exercise Overview__en.srt 1.82KB
  217. 09 - Assembling Queries with SubQueries/010 Exercise Solution.mp4 6.56MB
  218. 09 - Assembling Queries with SubQueries/011 Subqueries in a Join Clause.mp4 10.84MB
  219. 09 - Assembling Queries with SubQueries/011 Subqueries in a Join Clause__en.srt 6.66KB
  220. 09 - Assembling Queries with SubQueries/012 More Useful - Subqueries with Where.mp4 23.88MB
  221. 09 - Assembling Queries with SubQueries/012 More Useful - Subqueries with Where__en.srt 13.32KB
  222. 09 - Assembling Queries with SubQueries/013 Data Structure with Where Subqueries.mp4 27.68MB
  223. 09 - Assembling Queries with SubQueries/013 Data Structure with Where Subqueries__en.srt 8.72KB
  224. 09 - Assembling Queries with SubQueries/014 Exercise Overview.mp4 1.90MB
  225. 09 - Assembling Queries with SubQueries/015 Exercise Solution.mp4 4.45MB
  226. 09 - Assembling Queries with SubQueries/015 Exercise Solution__en.srt 3.02KB
  227. 09 - Assembling Queries with SubQueries/016 The Not In Operator with a List.mp4 23.45MB
  228. 09 - Assembling Queries with SubQueries/016 The Not In Operator with a List__en.srt 6.28KB
  229. 09 - Assembling Queries with SubQueries/017 A New Where Operator.mp4 24.20MB
  230. 09 - Assembling Queries with SubQueries/017 A New Where Operator__en.srt 9.42KB
  231. 09 - Assembling Queries with SubQueries/018 Finally Some_.mp4 20.48MB
  232. 09 - Assembling Queries with SubQueries/018 Finally Some___en.srt 8.03KB
  233. 09 - Assembling Queries with SubQueries/019 Exercise Overview.mp4 853.67KB
  234. 09 - Assembling Queries with SubQueries/019 Exercise Overview__en.srt 743B
  235. 09 - Assembling Queries with SubQueries/020 A Quick Solution.mp4 3.06MB
  236. 09 - Assembling Queries with SubQueries/020 A Quick Solution__en.srt 2.38KB
  237. 09 - Assembling Queries with SubQueries/021 Probably Too Much About Correlated Subqueries.mp4 66.89MB
  238. 09 - Assembling Queries with SubQueries/021 Probably Too Much About Correlated Subqueries__en.srt 24.57KB
  239. 09 - Assembling Queries with SubQueries/022 More on Correlated Subqueries.mp4 27.85MB
  240. 09 - Assembling Queries with SubQueries/022 More on Correlated Subqueries__en.srt 12.76KB
  241. 09 - Assembling Queries with SubQueries/023 A Select Without a From_.mp4 6.44MB
  242. 09 - Assembling Queries with SubQueries/023 A Select Without a From___en.srt 5.18KB
  243. 09 - Assembling Queries with SubQueries/024 Exercise Overview.mp4 1.37MB
  244. 09 - Assembling Queries with SubQueries/024 Exercise Overview__en.srt 1.19KB
  245. 09 - Assembling Queries with SubQueries/025 Exercise Solution.mp4 2.53MB
  246. 09 - Assembling Queries with SubQueries/025 Exercise Solution__en.srt 1.70KB
  247. 10 - Selecting Distinct Records/001 Selecting Distinct Values.mp4 8.43MB
  248. 10 - Selecting Distinct Records/001 Selecting Distinct Values__en.srt 6.33KB
  249. 10 - Selecting Distinct Records/002 Exercise Overview.mp4 961.13KB
  250. 10 - Selecting Distinct Records/002 Exercise Overview__en.srt 876B
  251. 10 - Selecting Distinct Records/003 A Distinct Solution.mp4 1.36MB
  252. 10 - Selecting Distinct Records/003 A Distinct Solution__en.srt 931B
  253. 11 - Utility Operators, Keywords, and Functions/001 The Greatest Value in a List.mp4 7.87MB
  254. 11 - Utility Operators, Keywords, and Functions/001 The Greatest Value in a List__en.srt 4.92KB
  255. 11 - Utility Operators, Keywords, and Functions/002 And the Least Value in a List_.mp4 3.76MB
  256. 11 - Utility Operators, Keywords, and Functions/002 And the Least Value in a List___en.srt 2.95KB
  257. 11 - Utility Operators, Keywords, and Functions/003 The Case Keyword.mp4 19.04MB
  258. 11 - Utility Operators, Keywords, and Functions/003 The Case Keyword__en.srt 6.53KB
  259. 12 - Local PostgreSQL Installation/001 PostgreSQL Installation on macOS.mp4 14.14MB
  260. 12 - Local PostgreSQL Installation/001 PostgreSQL Installation on macOS__en.srt 9.69KB
  261. 12 - Local PostgreSQL Installation/002 PGAdmin Setup on macOS.mp4 22.05MB
  262. 12 - Local PostgreSQL Installation/002 PGAdmin Setup on macOS__en.srt 7.53KB
  263. 12 - Local PostgreSQL Installation/003 Postgres installation on Windows.mp4 13.77MB
  264. 12 - Local PostgreSQL Installation/003 Postgres installation on Windows__en.srt 6.41KB
  265. 13 - PostgreSQL Complex Datatypes/001 What'd We Just Do_.mp4 12.38MB
  266. 13 - PostgreSQL Complex Datatypes/001 What'd We Just Do___en.srt 6.37KB
  267. 13 - PostgreSQL Complex Datatypes/002 Data Types.mp4 19.72MB
  268. 13 - PostgreSQL Complex Datatypes/002 Data Types__en.srt 6.98KB
  269. 13 - PostgreSQL Complex Datatypes/003 Fast Rules on Numeric Data Types.mp4 11.96MB
  270. 13 - PostgreSQL Complex Datatypes/003 Fast Rules on Numeric Data Types__en.srt 3.50KB
  271. 13 - PostgreSQL Complex Datatypes/004 More on Number Data Types.mp4 30.51MB
  272. 13 - PostgreSQL Complex Datatypes/004 More on Number Data Types__en.srt 14.38KB
  273. 13 - PostgreSQL Complex Datatypes/005 Reminder on Character Types.mp4 19.13MB
  274. 13 - PostgreSQL Complex Datatypes/005 Reminder on Character Types__en.srt 7.33KB
  275. 13 - PostgreSQL Complex Datatypes/006 Boolean Data Types.mp4 5.43MB
  276. 13 - PostgreSQL Complex Datatypes/006 Boolean Data Types__en.srt 3.77KB
  277. 13 - PostgreSQL Complex Datatypes/007 Times, Dates, and Timestamps.mp4 14.29MB
  278. 13 - PostgreSQL Complex Datatypes/007 Times, Dates, and Timestamps__en.srt 8.15KB
  279. 13 - PostgreSQL Complex Datatypes/008 Really Awesome Intervals.mp4 13.48MB
  280. 13 - PostgreSQL Complex Datatypes/008 Really Awesome Intervals__en.srt 8.81KB
  281. 14 - Database-Side Validation and Constraints/001 Thinking About Validation.mp4 16.52MB
  282. 14 - Database-Side Validation and Constraints/001 Thinking About Validation__en.srt 6.67KB
  283. 14 - Database-Side Validation and Constraints/002 Creating and Viewing Tables in PGAdmin.mp4 18.55MB
  284. 14 - Database-Side Validation and Constraints/002 Creating and Viewing Tables in PGAdmin__en.srt 11.23KB
  285. 14 - Database-Side Validation and Constraints/003 Applying a Null Constraint.mp4 14.08MB
  286. 14 - Database-Side Validation and Constraints/003 Applying a Null Constraint__en.srt 9.98KB
  287. 14 - Database-Side Validation and Constraints/004 Solving a Gotcha with Null Constraints.mp4 9.10MB
  288. 14 - Database-Side Validation and Constraints/004 Solving a Gotcha with Null Constraints__en.srt 6.30KB
  289. 14 - Database-Side Validation and Constraints/005 Default Column Values.mp4 14.32MB
  290. 14 - Database-Side Validation and Constraints/006 Applying a Unique Constraint to One column.mp4 26.77MB
  291. 14 - Database-Side Validation and Constraints/006 Applying a Unique Constraint to One column__en.srt 8.63KB
  292. 14 - Database-Side Validation and Constraints/007 Multi-Column Uniqueness.mp4 18.37MB
  293. 14 - Database-Side Validation and Constraints/007 Multi-Column Uniqueness__en.srt 5.08KB
  294. 14 - Database-Side Validation and Constraints/008 Adding a Validation Check.mp4 11.70MB
  295. 14 - Database-Side Validation and Constraints/008 Adding a Validation Check__en.srt 5.96KB
  296. 14 - Database-Side Validation and Constraints/009 Checks Over Multiple Columns.mp4 11.57MB
  297. 14 - Database-Side Validation and Constraints/009 Checks Over Multiple Columns__en.srt 7.43KB
  298. 14 - Database-Side Validation and Constraints/010 So Where Are We Applying Validation_.mp4 14.54MB
  299. 14 - Database-Side Validation and Constraints/010 So Where Are We Applying Validation___en.srt 9.63KB
  300. 15 - Database Structure Design Patterns/001 Approaching More Complicated Designs.mp4 7.66MB
  301. 15 - Database Structure Design Patterns/002 Using a SQL Design Tool.mp4 32.43MB
  302. 15 - Database Structure Design Patterns/002 Using a SQL Design Tool__en.srt 9.66KB
  303. 15 - Database Structure Design Patterns/003 A Config-based Schema Designer.mp4 19.25MB
  304. 15 - Database Structure Design Patterns/003 A Config-based Schema Designer__en.srt 11.51KB
  305. 15 - Database Structure Design Patterns/004 Here's the Plan.mp4 5.90MB
  306. 15 - Database Structure Design Patterns/004 Here's the Plan__en.srt 4.15KB
  307. 15 - Database Structure Design Patterns/005 Rebuilding Some Schema.mp4 14.12MB
  308. 15 - Database Structure Design Patterns/005 Rebuilding Some Schema__en.srt 10.33KB
  309. 15 - Database Structure Design Patterns/28595545-005-design.dbml 455B
  310. 16 - How to Build a 'Like' System/001 Requirements of a Like System.mp4 16.24MB
  311. 16 - How to Build a 'Like' System/001 Requirements of a Like System__en.srt 7.53KB
  312. 16 - How to Build a 'Like' System/002 How Not to Design a Like System.mp4 10.26MB
  313. 16 - How to Build a 'Like' System/002 How Not to Design a Like System__en.srt 4.72KB
  314. 16 - How to Build a 'Like' System/003 Designing a Like System.mp4 16.81MB
  315. 16 - How to Build a 'Like' System/003 Designing a Like System__en.srt 8.07KB
  316. 16 - How to Build a 'Like' System/004 Making a Reaction System Instead.mp4 4.12MB
  317. 16 - How to Build a 'Like' System/004 Making a Reaction System Instead__en.srt 2.47KB
  318. 16 - How to Build a 'Like' System/005 Polymorphic Associations.mp4 33.43MB
  319. 16 - How to Build a 'Like' System/005 Polymorphic Associations__en.srt 9.40KB
  320. 16 - How to Build a 'Like' System/006 Polymorphic Association Alternative Implementation.mp4 39.49MB
  321. 16 - How to Build a 'Like' System/006 Polymorphic Association Alternative Implementation__en.srt 10.62KB
  322. 16 - How to Build a 'Like' System/007 The Simplest Alternative.mp4 17.40MB
  323. 16 - How to Build a 'Like' System/007 The Simplest Alternative__en.srt 5.96KB
  324. 16 - How to Build a 'Like' System/008 So Which Approach_.mp4 10.46MB
  325. 16 - How to Build a 'Like' System/008 So Which Approach___en.srt 6.83KB
  326. 17 - How to Build a 'Mention' System/001 Additional Features Around Posts.mp4 54.04MB
  327. 17 - How to Build a 'Mention' System/001 Additional Features Around Posts__en.srt 9.78KB
  328. 17 - How to Build a 'Mention' System/002 Adding Captions and Locations.mp4 5.36MB
  329. 17 - How to Build a 'Mention' System/002 Adding Captions and Locations__en.srt 2.56KB
  330. 17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions.mp4 44.21MB
  331. 17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions__en.srt 12.33KB
  332. 17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags.mp4 42.88MB
  333. 17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags__en.srt 11.33KB
  334. 17 - How to Build a 'Mention' System/005 Update For Tags.mp4 14.97MB
  335. 17 - How to Build a 'Mention' System/005 Update For Tags__en.srt 7.20KB
  336. 18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System.mp4 60.55MB
  337. 18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System__en.srt 11.64KB
  338. 18 - How to Build a 'Hashtag' System/002 Tables for Hashtags.mp4 10.02MB
  339. 18 - How to Build a 'Hashtag' System/002 Tables for Hashtags__en.srt 5.65KB
  340. 18 - How to Build a 'Hashtag' System/003 Including the Hashtag Table.mp4 11.58MB
  341. 18 - How to Build a 'Hashtag' System/003 Including the Hashtag Table__en.srt 5.77KB
  342. 18 - How to Build a 'Hashtag' System/004 A Few More User Columns.mp4 16.86MB
  343. 18 - How to Build a 'Hashtag' System/004 A Few More User Columns__en.srt 9.57KB
  344. 18 - How to Build a 'Hashtag' System/005 Why No Number of Followers or Posts_.mp4 10.44MB
  345. 18 - How to Build a 'Hashtag' System/005 Why No Number of Followers or Posts___en.srt 5.90KB
  346. 19 - How to Design a 'Follower' System/001 Designing a Follower System.mp4 17.21MB
  347. 19 - How to Design a 'Follower' System/001 Designing a Follower System__en.srt 8.96KB
  348. 20 - Implementing Database Design Patterns/001 Back to Postgres.mp4 4.42MB
  349. 20 - Implementing Database Design Patterns/001 Back to Postgres__en.srt 3.19KB
  350. 20 - Implementing Database Design Patterns/002 Creating Tables with Checks.mp4 40.10MB
  351. 20 - Implementing Database Design Patterns/002 Creating Tables with Checks__en.srt 20.44KB
  352. 20 - Implementing Database Design Patterns/003 Posts Creation.mp4 24.30MB
  353. 20 - Implementing Database Design Patterns/003 Posts Creation__en.srt 12.42KB
  354. 20 - Implementing Database Design Patterns/004 Comments Creation.mp4 4.93MB
  355. 20 - Implementing Database Design Patterns/004 Comments Creation__en.srt 3.37KB
  356. 20 - Implementing Database Design Patterns/005 Likes Creation.mp4 15.83MB
  357. 20 - Implementing Database Design Patterns/005 Likes Creation__en.srt 9.73KB
  358. 20 - Implementing Database Design Patterns/006 Photo Tags and Caption Tags.mp4 25.74MB
  359. 20 - Implementing Database Design Patterns/006 Photo Tags and Caption Tags__en.srt 8.05KB
  360. 20 - Implementing Database Design Patterns/007 Creating Hashtags, Hashtag Posts, and Followers.mp4 13.66MB
  361. 20 - Implementing Database Design Patterns/007 Creating Hashtags, Hashtag Posts, and Followers__en.srt 8.81KB
  362. 20 - Implementing Database Design Patterns/28595559-002-db.sql 375B
  363. 20 - Implementing Database Design Patterns/28595561-003-db.sql 791B
  364. 20 - Implementing Database Design Patterns/28595563-004-db.sql 1.11KB
  365. 20 - Implementing Database Design Patterns/28595565-005-db.sql 1.55KB
  366. 20 - Implementing Database Design Patterns/28595567-006-db.sql 2.19KB
  367. 20 - Implementing Database Design Patterns/28595569-007-db.sql 2.84KB
  368. 21 - Approaching and Writing Complex Queries/001 Quick Note About Adding Some Data.html 251B
  369. 21 - Approaching and Writing Complex Queries/002 Adding Some Data.mp4 10.84MB
  370. 21 - Approaching and Writing Complex Queries/002 Adding Some Data__en.srt 6.45KB
  371. 21 - Approaching and Writing Complex Queries/003 Restoring from Scratch.mp4 13.85MB
  372. 21 - Approaching and Writing Complex Queries/003 Restoring from Scratch__en.srt 6.81KB
  373. 21 - Approaching and Writing Complex Queries/004 Highest User ID's Exercise.mp4 4.74MB
  374. 21 - Approaching and Writing Complex Queries/004 Highest User ID's Exercise__en.srt 3.02KB
  375. 21 - Approaching and Writing Complex Queries/005 Solution for User ID's.mp4 2.99MB
  376. 21 - Approaching and Writing Complex Queries/005 Solution for User ID's__en.srt 1.78KB
  377. 21 - Approaching and Writing Complex Queries/006 Posts by a Particular User.mp4 2.97MB
  378. 21 - Approaching and Writing Complex Queries/006 Posts by a Particular User__en.srt 1.72KB
  379. 21 - Approaching and Writing Complex Queries/007 Solving for Posts by User.mp4 5.85MB
  380. 21 - Approaching and Writing Complex Queries/007 Solving for Posts by User__en.srt 2.75KB
  381. 21 - Approaching and Writing Complex Queries/008 Likes Per User.mp4 2.25MB
  382. 21 - Approaching and Writing Complex Queries/009 Solution for Likes Per User.mp4 4.37MB
  383. 21 - Approaching and Writing Complex Queries/009 Solution for Likes Per User__en.srt 2.42KB
  384. 21 - Approaching and Writing Complex Queries/28595573-ig.sql 23.51MB
  385. 22 - Understanding the Internals of PostgreSQL/001 Thinking About Performance.mp4 6.48MB
  386. 22 - Understanding the Internals of PostgreSQL/001 Thinking About Performance__en.srt 3.58KB
  387. 22 - Understanding the Internals of PostgreSQL/002 Where Does Postgres Store Data_.mp4 22.62MB
  388. 22 - Understanding the Internals of PostgreSQL/002 Where Does Postgres Store Data___en.srt 8.63KB
  389. 22 - Understanding the Internals of PostgreSQL/003 Heaps, Blocks, and Tuples.mp4 15.16MB
  390. 22 - Understanding the Internals of PostgreSQL/003 Heaps, Blocks, and Tuples__en.srt 5.62KB
  391. 22 - Understanding the Internals of PostgreSQL/004 Block Data Layout.mp4 11.75MB
  392. 22 - Understanding the Internals of PostgreSQL/004 Block Data Layout__en.srt 6.75KB
  393. 01 - Simple - But Powerful - SQL Statements/001 Join Our Community_.html 318B
  394. 22 - Understanding the Internals of PostgreSQL/005 Heap File Layout__en.srt 48.34KB
  395. 23 - A Look at Indexes for Performance/001 Full Table Scans.mp4 23.88MB
  396. 23 - A Look at Indexes for Performance/001 Full Table Scans__en.srt 6.35KB
  397. 23 - A Look at Indexes for Performance/002 What's an Index.mp4 6.34MB
  398. 23 - A Look at Indexes for Performance/002 What's an Index__en.srt 3.89KB
  399. 23 - A Look at Indexes for Performance/003 How an Index Works.mp4 43.22MB
  400. 23 - A Look at Indexes for Performance/003 How an Index Works__en.srt 11.99KB
  401. 23 - A Look at Indexes for Performance/004 Creating an Index.mp4 8.89MB
  402. 23 - A Look at Indexes for Performance/004 Creating an Index__en.srt 6.09KB
  403. 23 - A Look at Indexes for Performance/005 Benchmarking Queries.mp4 14.93MB
  404. 23 - A Look at Indexes for Performance/005 Benchmarking Queries__en.srt 8.29KB
  405. 23 - A Look at Indexes for Performance/006 Downsides of Indexes.mp4 19.87MB
  406. 23 - A Look at Indexes for Performance/006 Downsides of Indexes__en.srt 8.03KB
  407. 23 - A Look at Indexes for Performance/007 Index Types.mp4 4.08MB
  408. 23 - A Look at Indexes for Performance/007 Index Types__en.srt 2.51KB
  409. 23 - A Look at Indexes for Performance/008 Automatically Generated Indexes.mp4 12.81MB
  410. 23 - A Look at Indexes for Performance/008 Automatically Generated Indexes__en.srt 5.59KB
  411. 23 - A Look at Indexes for Performance/009 Behind the Scenes of Indexes.mp4 238.29MB
  412. 23 - A Look at Indexes for Performance/009 Behind the Scenes of Indexes__en.srt 47.52KB
  413. 24 - Basic Query Tuning/001 The Query Processing Pipeline.mp4 16.08MB
  414. 24 - Basic Query Tuning/001 The Query Processing Pipeline__en.srt 7.95KB
  415. 24 - Basic Query Tuning/002 Explain and Explain Analyze.mp4 27.15MB
  416. 24 - Basic Query Tuning/002 Explain and Explain Analyze__en.srt 8.13KB
  417. 24 - Basic Query Tuning/003 Solving an Explain Mystery.mp4 49.05MB
  418. 24 - Basic Query Tuning/003 Solving an Explain Mystery__en.srt 13.66KB
  419. 25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost.mp4 64.58MB
  420. 25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost__en.srt 19.88KB
  421. 25 - Advanced Query Tuning/002 Calculating Cost by Hand.mp4 32.19MB
  422. 25 - Advanced Query Tuning/002 Calculating Cost by Hand__en.srt 9.82KB
  423. 25 - Advanced Query Tuning/003 A Touch More on Costs.mp4 55.34MB
  424. 25 - Advanced Query Tuning/003 A Touch More on Costs__en.srt 11.17KB
  425. 25 - Advanced Query Tuning/004 Startup vs Total Costs.mp4 28.66MB
  426. 25 - Advanced Query Tuning/004 Startup vs Total Costs__en.srt 8.87KB
  427. 25 - Advanced Query Tuning/005 Costs Flow Up.mp4 6.35MB
  428. 25 - Advanced Query Tuning/005 Costs Flow Up__en.srt 3.03KB
  429. 25 - Advanced Query Tuning/006 Use My Index_.mp4 25.95MB
  430. 25 - Advanced Query Tuning/006 Use My Index___en.srt 12.43KB
  431. 26 - Simple Common Table Expressions/001 Common Table Expressions.mp4 7.00MB
  432. 26 - Simple Common Table Expressions/001 Common Table Expressions__en.srt 2.89KB
  433. 26 - Simple Common Table Expressions/002 A Quick Solution.mp4 8.70MB
  434. 26 - Simple Common Table Expressions/002 A Quick Solution__en.srt 5.49KB
  435. 26 - Simple Common Table Expressions/003 So What's a CTE_.mp4 20.53MB
  436. 26 - Simple Common Table Expressions/003 So What's a CTE___en.srt 5.62KB
  437. 27 - Recursive Common Table Expressions/001 Recursive CTE's.mp4 7.78MB
  438. 27 - Recursive Common Table Expressions/001 Recursive CTE's__en.srt 4.91KB
  439. 27 - Recursive Common Table Expressions/002 Recursive CTE's Step by Step.mp4 40.08MB
  440. 27 - Recursive Common Table Expressions/002 Recursive CTE's Step by Step__en.srt 15.15KB
  441. 27 - Recursive Common Table Expressions/003 Why Use Recursive CTE's_.mp4 27.27MB
  442. 27 - Recursive Common Table Expressions/004 Writing the Query.mp4 23.59MB
  443. 27 - Recursive Common Table Expressions/004 Writing the Query__en.srt 11.58KB
  444. 27 - Recursive Common Table Expressions/005 Walking Through Recursion.mp4 65.98MB
  445. 27 - Recursive Common Table Expressions/005 Walking Through Recursion__en.srt 14.59KB
  446. 28 - Simplifying Queries with Views/001 Most Popular Users.mp4 16.57MB
  447. 28 - Simplifying Queries with Views/001 Most Popular Users__en.srt 9.59KB
  448. 28 - Simplifying Queries with Views/002 A Possible Solution for Merging Tables.mp4 22.31MB
  449. 28 - Simplifying Queries with Views/002 A Possible Solution for Merging Tables__en.srt 6.07KB
  450. 28 - Simplifying Queries with Views/003 Creating a View.mp4 21.25MB
  451. 28 - Simplifying Queries with Views/003 Creating a View__en.srt 8.29KB
  452. 28 - Simplifying Queries with Views/004 When to Use a View_.mp4 13.04MB
  453. 28 - Simplifying Queries with Views/004 When to Use a View___en.srt 4.85KB
  454. 28 - Simplifying Queries with Views/005 Deleting and Changing Views.mp4 7.92MB
  455. 28 - Simplifying Queries with Views/005 Deleting and Changing Views__en.srt 3.60KB
  456. 29 - Optimizing Queries with Materialized Views/001 Materialized Views.mp4 5.60MB
  457. 29 - Optimizing Queries with Materialized Views/001 Materialized Views__en.srt 3.77KB
  458. 29 - Optimizing Queries with Materialized Views/002 Grouping by Week.mp4 22.12MB
  459. 29 - Optimizing Queries with Materialized Views/002 Grouping by Week__en.srt 6.21KB
  460. 29 - Optimizing Queries with Materialized Views/003 Reminder on Left Joins.mp4 10.50MB
  461. 29 - Optimizing Queries with Materialized Views/003 Reminder on Left Joins__en.srt 6.71KB
  462. 29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query.mp4 35.07MB
  463. 29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query__en.srt 13.61KB
  464. 29 - Optimizing Queries with Materialized Views/005 Creating and Refreshing Materialized Views.mp4 22.49MB
  465. 30 - Handling Concurrency and Reversibility with Transactions/001 What are Transactions Used For_.mp4 15.45MB
  466. 30 - Handling Concurrency and Reversibility with Transactions/001 What are Transactions Used For___en.srt 6.25KB
  467. 30 - Handling Concurrency and Reversibility with Transactions/002 Some Sample Data.mp4 3.78MB
  468. 30 - Handling Concurrency and Reversibility with Transactions/002 Some Sample Data__en.srt 3.06KB
  469. 30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions.mp4 42.15MB
  470. 30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions__en.srt 14.76KB
  471. 30 - Handling Concurrency and Reversibility with Transactions/004 Transaction Cleanup on Crash.mp4 20.21MB
  472. 30 - Handling Concurrency and Reversibility with Transactions/004 Transaction Cleanup on Crash__en.srt 5.97KB
  473. 30 - Handling Concurrency and Reversibility with Transactions/005 Closing Aborted Transactions.mp4 4.83MB
  474. 30 - Handling Concurrency and Reversibility with Transactions/005 Closing Aborted Transactions__en.srt 2.68KB
  475. 31 - Managing Database Design with Schema Migrations/001 A Story on Migrations.mp4 88.61MB
  476. 31 - Managing Database Design with Schema Migrations/001 A Story on Migrations__en.srt 27.19KB
  477. 31 - Managing Database Design with Schema Migrations/002 Migration Files.mp4 28.84MB
  478. 31 - Managing Database Design with Schema Migrations/002 Migration Files__en.srt 7.33KB
  479. 31 - Managing Database Design with Schema Migrations/003 Issues Solved by Migrations.mp4 6.69MB
  480. 31 - Managing Database Design with Schema Migrations/003 Issues Solved by Migrations__en.srt 4.40KB
  481. 31 - Managing Database Design with Schema Migrations/004 A Few Notes on Migrations Libraries.mp4 21.69MB
  482. 31 - Managing Database Design with Schema Migrations/004 A Few Notes on Migrations Libraries__en.srt 7.60KB
  483. 31 - Managing Database Design with Schema Migrations/005 A Note About Node Installation.html 264B
  484. 31 - Managing Database Design with Schema Migrations/006 Project Creation.mp4 6.23MB
  485. 31 - Managing Database Design with Schema Migrations/006 Project Creation__en.srt 4.40KB
  486. 31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations.mp4 28.53MB
  487. 31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations__en.srt 10.20KB
  488. 31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations.mp4 40.15MB
  489. 31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations__en.srt 10.91KB
  490. 31 - Managing Database Design with Schema Migrations/009 Generating and Applying a Second Migration.mp4 10.78MB
  491. 31 - Managing Database Design with Schema Migrations/009 Generating and Applying a Second Migration__en.srt 5.04KB
  492. 32 - Schema vs Data Migrations/001 Schema vs Data Migrations.mp4 13.43MB
  493. 32 - Schema vs Data Migrations/001 Schema vs Data Migrations__en.srt 6.25KB
  494. 32 - Schema vs Data Migrations/002 Dangers Around Data Migrations.mp4 44.32MB
  495. 32 - Schema vs Data Migrations/002 Dangers Around Data Migrations__en.srt 14.15KB
  496. 32 - Schema vs Data Migrations/003 Properly Running Data and Schema Migrations.mp4 13.60MB
  497. 32 - Schema vs Data Migrations/003 Properly Running Data and Schema Migrations__en.srt 8.64KB
  498. 32 - Schema vs Data Migrations/004 Creating a Posts Table.mp4 14.37MB
  499. 32 - Schema vs Data Migrations/004 Creating a Posts Table__en.srt 6.67KB
  500. 32 - Schema vs Data Migrations/005 A Small Web Server.mp4 40.67MB
  501. 32 - Schema vs Data Migrations/005 A Small Web Server__en.srt 20.38KB
  502. 32 - Schema vs Data Migrations/006 Web Server Setup Instructions.html 1.02KB
  503. 32 - Schema vs Data Migrations/007 Adding the Loc Column.mp4 14.20MB
  504. 32 - Schema vs Data Migrations/007 Adding the Loc Column__en.srt 5.90KB
  505. 32 - Schema vs Data Migrations/008 Writing Values to Both Columns.mp4 10.66MB
  506. 32 - Schema vs Data Migrations/008 Writing Values to Both Columns__en.srt 6.30KB
  507. 32 - Schema vs Data Migrations/009 Transaction Locks.mp4 62.64MB
  508. 32 - Schema vs Data Migrations/009 Transaction Locks__en.srt 21.70KB
  509. 32 - Schema vs Data Migrations/010 Updating Values.mp4 10.13MB
  510. 32 - Schema vs Data Migrations/010 Updating Values__en.srt 6.27KB
  511. 32 - Schema vs Data Migrations/011 Migrations Setup Instructions.html 925B
  512. 32 - Schema vs Data Migrations/012 Updating the App Server.mp4 8.80MB
  513. 32 - Schema vs Data Migrations/012 Updating the App Server__en.srt 6.43KB
  514. 32 - Schema vs Data Migrations/013 Dropping the Last Columns.mp4 7.58MB
  515. 32 - Schema vs Data Migrations/28595583-005-index.js 1.32KB
  516. 32 - Schema vs Data Migrations/28595585-01-lng-lat-to-loc.js 364B
  517. 33 - Accessing PostgreSQL From API's/001 Section Goal.mp4 1.96MB
  518. 33 - Accessing PostgreSQL From API's/001 Section Goal__en.srt 1.48KB
  519. 33 - Accessing PostgreSQL From API's/002 Initial Setup.mp4 1.71MB
  520. 33 - Accessing PostgreSQL From API's/003 One Fast Migration.mp4 15.66MB
  521. 33 - Accessing PostgreSQL From API's/003 One Fast Migration__en.srt 7.09KB
  522. 33 - Accessing PostgreSQL From API's/004 Building the Users Router.mp4 18.61MB
  523. 33 - Accessing PostgreSQL From API's/004 Building the Users Router__en.srt 6.59KB
  524. 33 - Accessing PostgreSQL From API's/005 Understanding Connection Pools.mp4 16.03MB
  525. 33 - Accessing PostgreSQL From API's/005 Understanding Connection Pools__en.srt 10.34KB
  526. 33 - Accessing PostgreSQL From API's/006 Validating Connection Credentials.mp4 27.90MB
  527. 33 - Accessing PostgreSQL From API's/006 Validating Connection Credentials__en.srt 10.34KB
  528. 33 - Accessing PostgreSQL From API's/007 Query and Close__en.srt 3.03KB
  529. 33 - Accessing PostgreSQL From API's/28571947-008-access.zip 62.00KB
  530. 33 - Accessing PostgreSQL From API's/28571973-005-access-social-repo.zip 61.31KB
  531. 34 - Data Access Pattern - Repositories/001 The Repository Pattern.mp4 11.69MB
  532. 34 - Data Access Pattern - Repositories/001 The Repository Pattern__en.srt 5.54KB
  533. 34 - Data Access Pattern - Repositories/002 Creating a Repository.mp4 16.66MB
  534. 34 - Data Access Pattern - Repositories/002 Creating a Repository__en.srt 12.30KB
  535. 34 - Data Access Pattern - Repositories/003 Accessing the API.mp4 14.68MB
  536. 34 - Data Access Pattern - Repositories/004 Casing Issues.mp4 11.97MB
  537. 34 - Data Access Pattern - Repositories/004 Casing Issues__en.srt 6.85KB
  538. 34 - Data Access Pattern - Repositories/005 Fixing Casing.mp4 30.31MB
  539. 34 - Data Access Pattern - Repositories/005 Fixing Casing__en.srt 9.31KB
  540. 34 - Data Access Pattern - Repositories/006 Finding Particular Users.mp4 12.00MB
  541. 34 - Data Access Pattern - Repositories/006 Finding Particular Users__en.srt 7.97KB
  542. 34 - Data Access Pattern - Repositories/28571891-010-access.zip 62.58KB
  543. 35 - Security Around PostgreSQL/001 SQL Injection Exploits.mp4 20.45MB
  544. 35 - Security Around PostgreSQL/001 SQL Injection Exploits__en.srt 10.52KB
  545. 35 - Security Around PostgreSQL/002 Handling SQL Injection with Prepared Statements.mp4 25.48MB
  546. 35 - Security Around PostgreSQL/002 Handling SQL Injection with Prepared Statements__en.srt 12.46KB
  547. 35 - Security Around PostgreSQL/003 Preventing SQL Injection.mp4 22.48MB
  548. 35 - Security Around PostgreSQL/003 Preventing SQL Injection__en.srt 11.26KB
  549. 35 - Security Around PostgreSQL/004 Reminder on Post Requests.mp4 9.24MB
  550. 35 - Security Around PostgreSQL/004 Reminder on Post Requests__en.srt 4.06KB
  551. 35 - Security Around PostgreSQL/005 Inserting Users.mp4 9.98MB
  552. 35 - Security Around PostgreSQL/005 Inserting Users__en.srt 6.11KB
  553. 35 - Security Around PostgreSQL/006 Handling Updates.mp4 10.78MB
  554. 35 - Security Around PostgreSQL/006 Handling Updates__en.srt 6.62KB
  555. 35 - Security Around PostgreSQL/007 And, Finally, Delete.mp4 11.52MB
  556. 35 - Security Around PostgreSQL/007 And, Finally, Delete__en.srt 6.13KB
  557. 35 - Security Around PostgreSQL/28571907-021-access.zip 63.66KB
  558. 35 - Security Around PostgreSQL/28571915-019-access.zip 63.56KB
  559. 36 - Fast Parallel Testing/001 A Note on Testing.mp4 5.36MB
  560. 36 - Fast Parallel Testing/001 A Note on Testing__en.srt 4.84KB
  561. 36 - Fast Parallel Testing/002 Assertions Around User Count.mp4 26.88MB
  562. 36 - Fast Parallel Testing/002 Assertions Around User Count__en.srt 10.32KB
  563. 36 - Fast Parallel Testing/003 Connecting to a DB For Tests.mp4 32.00MB
  564. 36 - Fast Parallel Testing/003 Connecting to a DB For Tests__en.srt 7.98KB
  565. 36 - Fast Parallel Testing/004 Disconnecting After Tests.mp4 8.24MB
  566. 36 - Fast Parallel Testing/004 Disconnecting After Tests__en.srt 4.48KB
  567. 36 - Fast Parallel Testing/005 Multi-DB Setup.mp4 14.14MB
  568. 36 - Fast Parallel Testing/005 Multi-DB Setup__en.srt 7.31KB
  569. 36 - Fast Parallel Testing/006 Assumptions Around Content.mp4 20.64MB
  570. 36 - Fast Parallel Testing/006 Assumptions Around Content__en.srt 8.00KB
  571. 36 - Fast Parallel Testing/007 Issues with Parallel Tests.mp4 22.82MB
  572. 36 - Fast Parallel Testing/007 Issues with Parallel Tests__en.srt 7.72KB
  573. 36 - Fast Parallel Testing/008 Isolation with Schemas.mp4 18.07MB
  574. 36 - Fast Parallel Testing/008 Isolation with Schemas__en.srt 6.39KB
  575. 36 - Fast Parallel Testing/009 Creating and Accessing Schemas.mp4 12.81MB
  576. 36 - Fast Parallel Testing/009 Creating and Accessing Schemas__en.srt 7.81KB
  577. 36 - Fast Parallel Testing/010 Controlling Schema Access with Search Paths.mp4 20.15MB
  578. 36 - Fast Parallel Testing/010 Controlling Schema Access with Search Paths__en.srt 8.55KB
  579. 36 - Fast Parallel Testing/011 Routing Schema Access.mp4 24.75MB
  580. 36 - Fast Parallel Testing/011 Routing Schema Access__en.srt 6.43KB
  581. 36 - Fast Parallel Testing/012 Strategy for Isolation.mp4 11.66MB
  582. 36 - Fast Parallel Testing/012 Strategy for Isolation__en.srt 7.01KB
  583. 36 - Fast Parallel Testing/013 Programmatic Schema Creation.mp4 41.17MB
  584. 36 - Fast Parallel Testing/013 Programmatic Schema Creation__en.srt 17.71KB
  585. 36 - Fast Parallel Testing/014 Escaping Identifiers.mp4 15.94MB
  586. 36 - Fast Parallel Testing/014 Escaping Identifiers__en.srt 6.23KB
  587. 36 - Fast Parallel Testing/015 Test Helpers.mp4 26.41MB
  588. 36 - Fast Parallel Testing/015 Test Helpers__en.srt 7.74KB
  589. 36 - Fast Parallel Testing/016 Cleaning up Schemas and Roles.mp4 19.43MB
  590. 36 - Fast Parallel Testing/016 Cleaning up Schemas and Roles__en.srt 7.96KB
  591. 36 - Fast Parallel Testing/017 Finally... Parallel Tests_.mp4 11.63MB
  592. 36 - Fast Parallel Testing/017 Finally... Parallel Tests___en.srt 5.15KB
  593. 36 - Fast Parallel Testing/28571893-037-access.zip 66.59KB
  594. 36 - Fast Parallel Testing/28571899-034-access.zip 66.14KB
  595. 36 - Fast Parallel Testing/28571901-038-access.zip 66.57KB
  596. 36 - Fast Parallel Testing/28571903-027-access.zip 64.52KB
  597. 36 - Fast Parallel Testing/28571917-024-access.zip 64.50KB
  598. 36 - Fast Parallel Testing/28571925-025-access.zip 64.51KB
  599. 36 - Fast Parallel Testing/28571937-028-access.zip 65.77KB
  600. 36 - Fast Parallel Testing/28571943-036-access.zip 66.48KB
  601. 36 - Fast Parallel Testing/28571955-035-access.zip 66.14KB
  602. 36 - Fast Parallel Testing/28572037-026-access.zip 64.52KB
  603. 37 - Bonus_/001 Bonus_.html 4.11KB