589689.xyz

[] Udemy - SQL and PostgreSQL The Complete Developer's Guide

  • 收录时间:2021-05-25 03:58:50
  • 文件大小:8GB
  • 下载次数:1
  • 最近下载:2021-05-25 03:58:49
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 22. Understanding the Internals of PostgreSQL/6. Heap File Layout.mp4 345MB
  2. 23. A Look at Indexes for Performance/10. Behind the Scenes of Indexes.mp4 249MB
  3. 9. Assembling Queries with SubQueries/27. Probably Too Much About Correlated Subqueries.mp4 121MB
  4. 31. Managing Database Design with Schema Migrations/1. A Story on Migrations.mp4 112MB
  5. 4. Relating Records with Joins/11. Four Kinds of Joins.mp4 86MB
  6. 25. Advanced Query Tuning/1. Developing an Intuitive Understanding of Cost.mp4 84MB
  7. 27. Recursive Common Table Expressions/5. Walking Through Recursion.mp4 77MB
  8. 36. Fast Parallel Testing/13. Programmatic Schema Creation.mp4 76MB
  9. 32. Schema vs Data Migrations/5. A Small Web Server.mp4 72MB
  10. 32. Schema vs Data Migrations/9. Transaction Locks.mp4 71MB
  11. 27. Recursive Common Table Expressions/2. Recursive CTE's Step by Step.mp4 70MB
  12. 20. Implementing Database Design Patterns/2. Creating Tables with Checks.mp4 68MB
  13. 18. How to Build a 'Hashtag' System/1. Designing a Hashtag System.mp4 68MB
  14. 24. Basic Query Tuning/4. Solving an Explain Mystery.mp4 65MB
  15. 17. How to Build a 'Mention' System/3. Photo Mentions vs Caption Mentions.mp4 63MB
  16. 29. Optimizing Queries with Materialized Views/4. Writing a Slow Query.mp4 63MB
  17. 25. Advanced Query Tuning/3. A Touch More on Costs.mp4 58MB
  18. 32. Schema vs Data Migrations/2. Dangers Around Data Migrations.mp4 58MB
  19. 23. A Look at Indexes for Performance/3. How an Index Works.mp4 57MB
  20. 17. How to Build a 'Mention' System/1. Additional Features Around Posts.mp4 56MB
  21. 13. PostgreSQL Complex Datatypes/4. More on Number Data Types.mp4 56MB
  22. 30. Handling Concurrency and Reversibility with Transactions/3. Opening and Closing Transactions.mp4 55MB
  23. 4. Relating Records with Joins/19. Three Way Joins.mp4 54MB
  24. 9. Assembling Queries with SubQueries/28. More on Correlated Subqueries.mp4 54MB
  25. 3. Working with Tables/9. Understanding Foreign Keys.mp4 51MB
  26. 3. Working with Tables/2. Approaching Database Design.mp4 50MB
  27. 4. Relating Records with Joins/3. Joining Data from Different Tables.mp4 48MB
  28. 29. Optimizing Queries with Materialized Views/5. Creating and Refreshing Materialized Views.mp4 48MB
  29. 17. How to Build a 'Mention' System/4. Considerations on Photo Tags vs Caption Tags.mp4 47MB
  30. 9. Assembling Queries with SubQueries/8. Subqueries in a From.mp4 47MB
  31. 20. Implementing Database Design Patterns/3. Posts Creation.mp4 45MB
  32. 27. Recursive Common Table Expressions/4. Writing the Query.mp4 45MB
  33. 36. Fast Parallel Testing/16. Cleaning up Schemas and Roles.mp4 45MB
  34. 9. Assembling Queries with SubQueries/10. Example of a Subquery in a From.mp4 45MB
  35. 18. How to Build a 'Hashtag' System/4. A Few More User Columns.mp4 45MB
  36. 9. Assembling Queries with SubQueries/21. A New Where Operator.mp4 44MB
  37. 31. Managing Database Design with Schema Migrations/8. Applying and Reverting Migrations.mp4 43MB
  38. 9. Assembling Queries with SubQueries/15. More Useful - Subqueries with Where.mp4 43MB
  39. 25. Advanced Query Tuning/7. Use My Index!.mp4 42MB
  40. 16. How to Build a 'Like' System/7. Polymorphic Association Alternative Implementation.mp4 42MB
  41. 25. Advanced Query Tuning/2. Calculating Cost by Hand.mp4 42MB
  42. 35. Security Around PostgreSQL/2. Handling SQL Injection with Prepared Statements.mp4 42MB
  43. 35. Security Around PostgreSQL/3. Preventing SQL Injection.mp4 40MB
  44. 34. Data Access Pattern - Repositories/5. Fixing Casing.mp4 39MB
  45. 22. Understanding the Internals of PostgreSQL/2. Where Does Postgres Store Data.mp4 39MB
  46. 31. Managing Database Design with Schema Migrations/7. Generating and Writing Migrations.mp4 39MB
  47. 3. Working with Tables/4. One-to-Many and Many-to-One Relationships.mp4 39MB
  48. 15. Database Structure Design Patterns/2. Using a SQL Design Tool.mp4 38MB
  49. 34. Data Access Pattern - Repositories/2. Creating a Repository.mp4 38MB
  50. 4. Relating Records with Joins/18. Where with Join.mp4 38MB
  51. 4. Relating Records with Joins/13. Does Order Matter.mp4 37MB
  52. 4. Relating Records with Joins/9. Missing Data in Joins.mp4 37MB
  53. 5. Aggregation of Records/16. More on Having!.mp4 37MB
  54. 28. Simplifying Queries with Views/3. Creating a View.mp4 36MB
  55. 14. Database-Side Validation and Constraints/2. Creating and Viewing Tables in PGAdmin.mp4 36MB
  56. 16. How to Build a 'Like' System/6. Polymorphic Associations.mp4 36MB
  57. 25. Advanced Query Tuning/5. Startup vs Total Costs.mp4 36MB
  58. 3. Working with Tables/6. One-to-One and Many-to-Many Relationships.mp4 36MB
  59. 15. Database Structure Design Patterns/3. A Config-based Schema Designer.mp4 36MB
  60. 36. Fast Parallel Testing/15. Test Helpers.mp4 36MB
  61. 9. Assembling Queries with SubQueries/1. What's a Subquery.mp4 35MB
  62. 1. Simple - But Powerful - SQL Statements/3. Database Design.mp4 35MB
  63. 9. Assembling Queries with SubQueries/16. Data Structure with Where Subqueries.mp4 35MB
  64. 20. Implementing Database Design Patterns/5. Likes Creation.mp4 35MB
  65. 36. Fast Parallel Testing/2. Assertions Around User Count.mp4 35MB
  66. 9. Assembling Queries with SubQueries/22. Finally Some!.mp4 35MB
  67. 3. Working with Tables/8. Primary Keys and Foreign Keys.mp4 34MB
  68. 4. Relating Records with Joins/12. Each Join in Practice.mp4 34MB
  69. 36. Fast Parallel Testing/3. Connecting to a DB For Tests.mp4 34MB
  70. 36. Fast Parallel Testing/10. Controlling Schema Access with Search Paths.mp4 34MB
  71. 19. How to Design a 'Follower' System/1. Designing a Follower System.mp4 34MB
  72. 24. Basic Query Tuning/1. The Query Processing Pipeline.mp4 33MB
  73. 35. Security Around PostgreSQL/1. SQL Injection Exploits.mp4 33MB
  74. 5. Aggregation of Records/2. Picturing Group By.mp4 33MB
  75. 33. Accessing PostgreSQL From API's/6. Validating Connection Credentials.mp4 32MB
  76. 31. Managing Database Design with Schema Migrations/2. Migration Files.mp4 32MB
  77. 14. Database-Side Validation and Constraints/3. Applying a Null Constraint.mp4 32MB
  78. 3. Working with Tables/13. Running Queries on Associated Data.mp4 32MB
  79. 3. Working with Tables/11. Auto-Generated ID's.mp4 32MB
  80. 15. Database Structure Design Patterns/5. Rebuilding Some Schema.mp4 31MB
  81. 14. Database-Side Validation and Constraints/7. Applying a Unique Constraint to One column.mp4 31MB
  82. 14. Database-Side Validation and Constraints/13. So Where Are We Applying Validation.mp4 31MB
  83. 24. Basic Query Tuning/2. Explain and Explain Analyze.mp4 31MB
  84. 17. How to Build a 'Mention' System/5. Update For Tags.mp4 30MB
  85. 16. How to Build a 'Like' System/3. Designing a Like System.mp4 30MB
  86. 28. Simplifying Queries with Views/2. A Possible Solution for Merging Tables.mp4 30MB
  87. 16. How to Build a 'Like' System/1. Requirements of a Like System.mp4 30MB
  88. 28. Simplifying Queries with Views/1. Most Popular Users.mp4 30MB
  89. 36. Fast Parallel Testing/9. Creating and Accessing Schemas.mp4 30MB
  90. 35. Security Around PostgreSQL/6. Handling Updates.mp4 30MB
  91. 36. Fast Parallel Testing/14. Escaping Identifiers.mp4 30MB
  92. 33. Accessing PostgreSQL From API's/3. One Fast Migration.mp4 30MB
  93. 8. Unions and Intersections with Sets/4. Removing Commonalities with Except.mp4 30MB
  94. 36. Fast Parallel Testing/7. Issues with Parallel Tests.mp4 30MB
  95. 3. Working with Tables/18. Constraints Around Deletion.mp4 29MB
  96. 20. Implementing Database Design Patterns/7. Creating Hashtags, Hashtag Posts, and Followers.mp4 29MB
  97. 27. Recursive Common Table Expressions/3. Why Use Recursive CTE's.mp4 29MB
  98. 31. Managing Database Design with Schema Migrations/4. A Few Notes on Migrations Libraries.mp4 29MB
  99. 14. Database-Side Validation and Constraints/1. Thinking About Validation.mp4 29MB
  100. 20. Implementing Database Design Patterns/6. Photo Tags and Caption Tags.mp4 28MB
  101. 34. Data Access Pattern - Repositories/6. Finding Particular Users.mp4 28MB
  102. 36. Fast Parallel Testing/5. Multi-DB Setup.mp4 28MB
  103. 9. Assembling Queries with SubQueries/4. Subqueries in a Select.mp4 28MB
  104. 4. Relating Records with Joins/8. Alternate Forms of Syntax.mp4 28MB
  105. 23. A Look at Indexes for Performance/5. Benchmarking Queries.mp4 28MB
  106. 30. Handling Concurrency and Reversibility with Transactions/4. Transaction Cleanup on Crash.mp4 28MB
  107. 7. Sorting Records/3. Offset and Limit.mp4 28MB
  108. 3. Working with Tables/17. Foreign Key Constraints Around Insertion.mp4 28MB
  109. 26. Simple Common Table Expressions/3. So What's a CTE.mp4 27MB
  110. 36. Fast Parallel Testing/6. Assumptions Around Content.mp4 27MB
  111. 32. Schema vs Data Migrations/3. Properly Running Data and Schema Migrations.mp4 27MB
  112. 13. PostgreSQL Complex Datatypes/7. Times, Dates, and Timestamps.mp4 27MB
  113. 8. Unions and Intersections with Sets/1. Handling Sets with Union.mp4 27MB
  114. 12. Local PostgreSQL Installation/1. PostgreSQL Installation on macOS.mp4 27MB
  115. 23. A Look at Indexes for Performance/1. Full Table Scans.mp4 27MB
  116. 12. Local PostgreSQL Installation/3. Postgres installation on Windows.mp4 27MB
  117. 36. Fast Parallel Testing/17. Finally... Parallel Tests!.mp4 27MB
  118. 36. Fast Parallel Testing/11. Routing Schema Access.mp4 26MB
  119. 4. Relating Records with Joins/20. A Bit of Practice.mp4 26MB
  120. 28. Simplifying Queries with Views/4. When to Use a View.mp4 26MB
  121. 9. Assembling Queries with SubQueries/2. Thinking About the Structure of Data.mp4 26MB
  122. 5. Aggregation of Records/14. Filtering Groups with Having.mp4 26MB
  123. 35. Security Around PostgreSQL/7. And, Finally, Delete.mp4 26MB
  124. 3. Working with Tables/20. Testing Deletion Constraints.mp4 26MB
  125. 29. Optimizing Queries with Materialized Views/2. Grouping by Week.mp4 25MB
  126. 33. Accessing PostgreSQL From API's/4. Building the Users Router.mp4 25MB
  127. 36. Fast Parallel Testing/12. Strategy for Isolation.mp4 25MB
  128. 9. Assembling Queries with SubQueries/20. The Not In Operator with a List.mp4 25MB
  129. 13. PostgreSQL Complex Datatypes/5. Reminder on Character Types.mp4 25MB
  130. 35. Security Around PostgreSQL/5. Inserting Users.mp4 25MB
  131. 16. How to Build a 'Like' System/10. So Which Approach.mp4 25MB
  132. 23. A Look at Indexes for Performance/6. Downsides of Indexes.mp4 25MB
  133. 29. Optimizing Queries with Materialized Views/3. Reminder on Left Joins.mp4 25MB
  134. 13. PostgreSQL Complex Datatypes/2. Data Types.mp4 24MB
  135. 9. Assembling Queries with SubQueries/14. Subqueries in a Join Clause.mp4 24MB
  136. 1. Simple - But Powerful - SQL Statements/14. String Operators and Functions.mp4 24MB
  137. 12. Local PostgreSQL Installation/2. PGAdmin Setup on macOS.mp4 24MB
  138. 33. Accessing PostgreSQL From API's/5. Understanding Connection Pools.mp4 24MB
  139. 32. Schema vs Data Migrations/4. Creating a Posts Table.mp4 24MB
  140. 2. Filtering Records/3. Compound Where Clauses.mp4 24MB
  141. 13. PostgreSQL Complex Datatypes/8. Really Awesome Intervals.mp4 24MB
  142. 21. Approaching and Writing Complex Queries/3. Restoring from Scratch.mp4 24MB
  143. 14. Database-Side Validation and Constraints/11. Checks Over Multiple Columns.mp4 24MB
  144. 14. Database-Side Validation and Constraints/10. Adding a Validation Check.mp4 24MB
  145. 21. Approaching and Writing Complex Queries/1.1 ig.sql 24MB
  146. 3. Working with Tables/12. Creating Foreign Key Columns.mp4 23MB
  147. 34. Data Access Pattern - Repositories/4. Casing Issues.mp4 23MB
  148. 13. PostgreSQL Complex Datatypes/1. What'd We Just Do.mp4 23MB
  149. 32. Schema vs Data Migrations/12. Updating the App Server.mp4 23MB
  150. 5. Aggregation of Records/5. Combining Group By and Aggregates.mp4 22MB
  151. 18. How to Build a 'Hashtag' System/5. Why No Number of Followers or Posts.mp4 22MB
  152. 36. Fast Parallel Testing/8. Isolation with Schemas.mp4 22MB
  153. 1. Simple - But Powerful - SQL Statements/2. What is PostgreSQL All About.mp4 22MB
  154. 4. Relating Records with Joins/2. Queries with Joins and Aggregations.mp4 22MB
  155. 16. How to Build a 'Like' System/8. The Simplest Alternative.mp4 22MB
  156. 32. Schema vs Data Migrations/8. Writing Values to Both Columns.mp4 22MB
  157. 21. Approaching and Writing Complex Queries/2. Adding Some Data.mp4 21MB
  158. 32. Schema vs Data Migrations/1. Schema vs Data Migrations.mp4 21MB
  159. 14. Database-Side Validation and Constraints/8. Multi-Column Uniqueness.mp4 21MB
  160. 23. A Look at Indexes for Performance/8. Automatically Generated Indexes.mp4 21MB
  161. 4. Relating Records with Joins/17. Two Possible Solutions.mp4 21MB
  162. 34. Data Access Pattern - Repositories/1. The Repository Pattern.mp4 21MB
  163. 8. Unions and Intersections with Sets/2. A Few Notes on Union.mp4 21MB
  164. 22. Understanding the Internals of PostgreSQL/5. Block Data Layout.mp4 21MB
  165. 2. Filtering Records/13. Updating Rows.mp4 21MB
  166. 4. Relating Records with Joins/10. Why Wasn't It Included.mp4 21MB
  167. 26. Simple Common Table Expressions/2. A Quick Solution.mp4 21MB
  168. 14. Database-Side Validation and Constraints/4. Solving a Gotcha with Null Constraints.mp4 21MB
  169. 18. How to Build a 'Hashtag' System/3. Including the Hashtag Table.mp4 20MB
  170. 31. Managing Database Design with Schema Migrations/9. Generating and Applying a Second Migration.mp4 20MB
  171. 1. Simple - But Powerful - SQL Statements/7. Inserting Data Into a Table.mp4 20MB
  172. 16. How to Build a 'Like' System/2. How Not to Design a Like System.mp4 20MB
  173. 32. Schema vs Data Migrations/10. Updating Values.mp4 20MB
  174. 5. Aggregation of Records/17. A Having Exercise Overview.mp4 19MB
  175. 23. A Look at Indexes for Performance/4. Creating an Index.mp4 19MB
  176. 1. Simple - But Powerful - SQL Statements/6. Analyzing CREATE TABLE.mp4 19MB
  177. 11. Utility Operators, Keywords, and Functions/3. The Case Keyword.mp4 19MB
  178. 30. Handling Concurrency and Reversibility with Transactions/1. What are Transactions Used For.mp4 19MB
  179. 14. Database-Side Validation and Constraints/6. Default Column Values.mp4 19MB
  180. 1. Simple - But Powerful - SQL Statements/10. Calculated Columns.mp4 19MB
  181. 1. Simple - But Powerful - SQL Statements/5. Creating Tables.mp4 19MB
  182. 32. Schema vs Data Migrations/7. Adding the Loc Column.mp4 18MB
  183. 2. Filtering Records/14. Deleting Rows.mp4 18MB
  184. 10. Selecting Distinct Records/1. Selecting Distinct Values.mp4 18MB
  185. 22. Understanding the Internals of PostgreSQL/3. Heaps, Blocks, and Tuples.mp4 18MB
  186. 34. Data Access Pattern - Repositories/3. Accessing the API.mp4 17MB
  187. 8. Unions and Intersections with Sets/3. Commonalities with Intersect.mp4 17MB
  188. 27. Recursive Common Table Expressions/1. Recursive CTE's.mp4 17MB
  189. 36. Fast Parallel Testing/4. Disconnecting After Tests.mp4 17MB
  190. 2. Filtering Records/1. Filtering Rows with Where.mp4 17MB
  191. 18. How to Build a 'Hashtag' System/2. Tables for Hashtags.mp4 17MB
  192. 28. Simplifying Queries with Views/5. Deleting and Changing Views.mp4 17MB
  193. 35. Security Around PostgreSQL/4. Reminder on Post Requests.mp4 16MB
  194. 15. Database Structure Design Patterns/1. Approaching More Complicated Designs.mp4 16MB
  195. 5. Aggregation of Records/4. Aggregate Functions.mp4 15MB
  196. 5. Aggregation of Records/7. Visualizing More Grouping.mp4 15MB
  197. 3. Working with Tables/21. Setting Foreign Keys to Null on Delete.mp4 15MB
  198. 11. Utility Operators, Keywords, and Functions/1. The Greatest Value in a List.mp4 15MB
  199. 6. Working with Large Datasets/6. Remember Joins.mp4 15MB
  200. 15. Database Structure Design Patterns/4. Here's the Plan.mp4 15MB
  201. 32. Schema vs Data Migrations/13. Dropping the Last Columns.mp4 14MB
  202. 4. Relating Records with Joins/4. Another Quick Join.mp4 14MB
  203. 7. Sorting Records/2. Two Variations on Sorting.mp4 14MB
  204. 31. Managing Database Design with Schema Migrations/6. Project Creation.mp4 14MB
  205. 21. Approaching and Writing Complex Queries/7. Solving for Posts by User.mp4 14MB
  206. 25. Advanced Query Tuning/6. Costs Flow Up.mp4 13MB
  207. 31. Managing Database Design with Schema Migrations/3. Issues Solved by Migrations.mp4 13MB
  208. 9. Assembling Queries with SubQueries/9. From Subqueries that Return a Value.mp4 13MB
  209. 3. Working with Tables/23. Adding Some Complexity.mp4 13MB
  210. 13. PostgreSQL Complex Datatypes/6. Boolean Data Types.mp4 13MB
  211. 2. Filtering Records/2. More on the Where Keyword.mp4 13MB
  212. 23. A Look at Indexes for Performance/2. What's an Index.mp4 13MB
  213. 13. PostgreSQL Complex Datatypes/3. Fast Rules on Numeric Data Types.mp4 13MB
  214. 6. Working with Large Datasets/5. Group By Review Solution.mp4 13MB
  215. 9. Assembling Queries with SubQueries/29. A Select Without a From.mp4 12MB
  216. 4. Relating Records with Joins/22. Exercise Solution.mp4 12MB
  217. 26. Simple Common Table Expressions/1. Common Table Expressions.mp4 12MB
  218. 17. How to Build a 'Mention' System/2. Adding Captions and Locations.mp4 12MB
  219. 5. Aggregation of Records/15. Having In Action.mp4 12MB
  220. 3. Working with Tables/14. Exercise Overview.mp4 12MB
  221. 3. Working with Tables/16. Foreign Key Creation Solution.mp4 12MB
  222. 6. Working with Large Datasets/2. Investigating This Dataset.mp4 11MB
  223. 29. Optimizing Queries with Materialized Views/1. Materialized Views.mp4 11MB
  224. 7. Sorting Records/1. The Basics of Sorting.mp4 11MB
  225. 5. Aggregation of Records/19. A Quick Solution.mp4 11MB
  226. 36. Fast Parallel Testing/1. A Note on Testing.mp4 11MB
  227. 20. Implementing Database Design Patterns/4. Comments Creation.mp4 10MB
  228. 20. Implementing Database Design Patterns/1. Back to Postgres.mp4 10MB
  229. 30. Handling Concurrency and Reversibility with Transactions/5. Closing Aborted Transactions.mp4 10MB
  230. 5. Aggregation of Records/1. Aggregating and Grouping.mp4 10MB
  231. 23. A Look at Indexes for Performance/7. Index Types.mp4 10MB
  232. 22. Understanding the Internals of PostgreSQL/1. Thinking About Performance.mp4 9MB
  233. 1. Simple - But Powerful - SQL Statements/8. Retrieving Data with Select.mp4 9MB
  234. 9. Assembling Queries with SubQueries/19. Exercise Solution.mp4 9MB
  235. 16. How to Build a 'Like' System/5. Making a Reaction System Instead.mp4 9MB
  236. 33. Accessing PostgreSQL From API's/7. Query and Close.mp4 9MB
  237. 3. Working with Tables/1. The Plan Moving Forward.mp4 9MB
  238. 4. Relating Records with Joins/7. A Joinful Solution.mp4 9MB
  239. 11. Utility Operators, Keywords, and Functions/2. And the Least Value in a List!.mp4 9MB
  240. 2. Filtering Records/12. Solving Calculations.mp4 8MB
  241. 21. Approaching and Writing Complex Queries/9. Solution for Likes Per User.mp4 8MB
  242. 5. Aggregation of Records/6. A Gotcha with Count.mp4 8MB
  243. 21. Approaching and Writing Complex Queries/4. Highest User ID's Exercise.mp4 8MB
  244. 4. Relating Records with Joins/5. Exercise Overview.mp4 8MB
  245. 30. Handling Concurrency and Reversibility with Transactions/2. Some Sample Data.mp4 8MB
  246. 9. Assembling Queries with SubQueries/13. Exercise Solution.mp4 7MB
  247. 2. Filtering Records/9. A Where With Lists Solution.mp4 7MB
  248. 2. Filtering Records/16. A Solution for Updating Rows.mp4 7MB
  249. 8. Unions and Intersections with Sets/7. Exercise Solution.mp4 7MB
  250. 6. Working with Large Datasets/8. Of Course You Remember!.mp4 7MB
  251. 21. Approaching and Writing Complex Queries/6. Posts by a Particular User.mp4 7MB
  252. 2. Filtering Records/10. Calculations in Where Clauses.mp4 6MB
  253. 21. Approaching and Writing Complex Queries/5. Solution for User ID's.mp4 6MB
  254. 8. Unions and Intersections with Sets/5. Union Exercise Overview.mp4 6MB
  255. 9. Assembling Queries with SubQueries/26. A Quick Solution.mp4 6MB
  256. 9. Assembling Queries with SubQueries/7. Select Solution.mp4 6MB
  257. 1. Simple - But Powerful - SQL Statements/11. Calculating Phone Revenue.mp4 5MB
  258. 2. Filtering Records/18. Solution for Deleting Rows.mp4 5MB
  259. 9. Assembling Queries with SubQueries/5. Exercise Overview.mp4 5MB
  260. 9. Assembling Queries with SubQueries/32. Exercise Solution.mp4 5MB
  261. 9. Assembling Queries with SubQueries/11. Exercise Overview.mp4 5MB
  262. 7. Sorting Records/6. Exercise Solution.mp4 5MB
  263. 5. Aggregation of Records/13. Solution.mp4 5MB
  264. 21. Approaching and Writing Complex Queries/8. Likes Per User.mp4 5MB
  265. 5. Aggregation of Records/10. Grouping Solution.mp4 4MB
  266. 9. Assembling Queries with SubQueries/17. Exercise Overview.mp4 4MB
  267. 6. Working with Large Datasets/3. Some Group By Practice.mp4 4MB
  268. 1. Simple - But Powerful - SQL Statements/13. Exercise Solution.mp4 4MB
  269. 2. Filtering Records/6. A Where Solution.mp4 4MB
  270. 33. Accessing PostgreSQL From API's/2. Initial Setup.mp4 3MB
  271. 4. Relating Records with Joins/15. Exercise Overview.mp4 3MB
  272. 33. Accessing PostgreSQL From API's/1. Section Goal.mp4 3MB
  273. 9. Assembling Queries with SubQueries/30. Exercise Overview.mp4 3MB
  274. 5. Aggregation of Records/11. Adding a Layer of Difficulty.mp4 3MB
  275. 10. Selecting Distinct Records/4. A Distinct Solution.mp4 3MB
  276. 5. Aggregation of Records/8. Exercise Overview.mp4 3MB
  277. 2. Filtering Records/4. A Where Exercise Overview.mp4 2MB
  278. 2. Filtering Records/7. Where With Lists.mp4 2MB
  279. 10. Selecting Distinct Records/2. Exercise Overview.mp4 2MB
  280. 9. Assembling Queries with SubQueries/24. Exercise Overview.mp4 2MB
  281. 7. Sorting Records/4. Exercise Overview.mp4 2MB
  282. 4. Relating Records with Joins/11.1 009_-_joins_-_cheatsheet.pdf 191KB
  283. 36. Fast Parallel Testing/16.1 037_-_access.zip 67KB
  284. 36. Fast Parallel Testing/17.1 038_-_access.zip 67KB
  285. 36. Fast Parallel Testing/15.1 036_-_access.zip 66KB
  286. 36. Fast Parallel Testing/14.1 035_-_access.zip 66KB
  287. 36. Fast Parallel Testing/13.1 034_-_access.zip 66KB
  288. 36. Fast Parallel Testing/7.1 028_-_access.zip 66KB
  289. 36. Fast Parallel Testing/6.1 027_-_access.zip 65KB
  290. 36. Fast Parallel Testing/5.1 026_-_access.zip 65KB
  291. 36. Fast Parallel Testing/4.1 025_-_access.zip 65KB
  292. 36. Fast Parallel Testing/3.1 024_-_access.zip 65KB
  293. 35. Security Around PostgreSQL/7.1 021_-_access.zip 64KB
  294. 35. Security Around PostgreSQL/5.1 019_-_access.zip 64KB
  295. 34. Data Access Pattern - Repositories/2.1 010_-_access.zip 63KB
  296. 33. Accessing PostgreSQL From API's/7.1 008_-_access.zip 62KB
  297. 33. Accessing PostgreSQL From API's/4.1 005_-_access_-_social-repo.zip 61KB
  298. 22. Understanding the Internals of PostgreSQL/6. Heap File Layout.srt 48KB
  299. 23. A Look at Indexes for Performance/10. Behind the Scenes of Indexes.srt 48KB
  300. 31. Managing Database Design with Schema Migrations/1. A Story on Migrations.srt 27KB
  301. 9. Assembling Queries with SubQueries/27. Probably Too Much About Correlated Subqueries.srt 25KB
  302. 32. Schema vs Data Migrations/9. Transaction Locks.srt 22KB
  303. 20. Implementing Database Design Patterns/2. Creating Tables with Checks.srt 20KB
  304. 32. Schema vs Data Migrations/5. A Small Web Server.srt 20KB
  305. 25. Advanced Query Tuning/1. Developing an Intuitive Understanding of Cost.srt 20KB
  306. 36. Fast Parallel Testing/13. Programmatic Schema Creation.srt 18KB
  307. 6. Working with Large Datasets/1. A New Dataset.html 17KB
  308. 6. Working with Large Datasets/2.1 001 - sq - data.sql 16KB
  309. 27. Recursive Common Table Expressions/2. Recursive CTE's Step by Step.srt 15KB
  310. 30. Handling Concurrency and Reversibility with Transactions/3. Opening and Closing Transactions.srt 15KB
  311. 27. Recursive Common Table Expressions/5. Walking Through Recursion.srt 15KB
  312. 4. Relating Records with Joins/11. Four Kinds of Joins.srt 14KB
  313. 13. PostgreSQL Complex Datatypes/4. More on Number Data Types.srt 14KB
  314. 32. Schema vs Data Migrations/2. Dangers Around Data Migrations.srt 14KB
  315. 24. Basic Query Tuning/4. Solving an Explain Mystery.srt 14KB
  316. 29. Optimizing Queries with Materialized Views/4. Writing a Slow Query.srt 14KB
  317. 9. Assembling Queries with SubQueries/10. Example of a Subquery in a From.srt 13KB
  318. 9. Assembling Queries with SubQueries/15. More Useful - Subqueries with Where.srt 13KB
  319. 9. Assembling Queries with SubQueries/28. More on Correlated Subqueries.srt 13KB
  320. 3. Working with Tables/9. Understanding Foreign Keys.srt 13KB
  321. 35. Security Around PostgreSQL/2. Handling SQL Injection with Prepared Statements.srt 12KB
  322. 25. Advanced Query Tuning/7. Use My Index!.srt 12KB
  323. 20. Implementing Database Design Patterns/3. Posts Creation.srt 12KB
  324. 17. How to Build a 'Mention' System/3. Photo Mentions vs Caption Mentions.srt 12KB
  325. 34. Data Access Pattern - Repositories/2. Creating a Repository.srt 12KB
  326. 23. A Look at Indexes for Performance/3. How an Index Works.srt 12KB
  327. 4. Relating Records with Joins/19. Three Way Joins.srt 12KB
  328. 3. Working with Tables/2. Approaching Database Design.srt 12KB
  329. 9. Assembling Queries with SubQueries/8. Subqueries in a From.srt 12KB
  330. 18. How to Build a 'Hashtag' System/1. Designing a Hashtag System.srt 12KB
  331. 27. Recursive Common Table Expressions/4. Writing the Query.srt 12KB
  332. 4. Relating Records with Joins/3. Joining Data from Different Tables.srt 12KB
  333. 15. Database Structure Design Patterns/3. A Config-based Schema Designer.srt 12KB
  334. 17. How to Build a 'Mention' System/4. Considerations on Photo Tags vs Caption Tags.srt 11KB
  335. 35. Security Around PostgreSQL/3. Preventing SQL Injection.srt 11KB
  336. 14. Database-Side Validation and Constraints/2. Creating and Viewing Tables in PGAdmin.srt 11KB
  337. 25. Advanced Query Tuning/3. A Touch More on Costs.srt 11KB
  338. 31. Managing Database Design with Schema Migrations/8. Applying and Reverting Migrations.srt 11KB
  339. 16. How to Build a 'Like' System/7. Polymorphic Association Alternative Implementation.srt 11KB
  340. 35. Security Around PostgreSQL/1. SQL Injection Exploits.srt 11KB
  341. 33. Accessing PostgreSQL From API's/6. Validating Connection Credentials.srt 10KB
  342. 33. Accessing PostgreSQL From API's/5. Understanding Connection Pools.srt 10KB
  343. 15. Database Structure Design Patterns/5. Rebuilding Some Schema.srt 10KB
  344. 36. Fast Parallel Testing/2. Assertions Around User Count.srt 10KB
  345. 31. Managing Database Design with Schema Migrations/7. Generating and Writing Migrations.srt 10KB
  346. 5. Aggregation of Records/16. More on Having!.srt 10KB
  347. 3. Working with Tables/13. Running Queries on Associated Data.srt 10KB
  348. 4. Relating Records with Joins/18. Where with Join.srt 10KB
  349. 14. Database-Side Validation and Constraints/3. Applying a Null Constraint.srt 10KB
  350. 3. Working with Tables/4. One-to-Many and Many-to-One Relationships.srt 10KB
  351. 25. Advanced Query Tuning/2. Calculating Cost by Hand.srt 10KB
  352. 17. How to Build a 'Mention' System/1. Additional Features Around Posts.srt 10KB
  353. 20. Implementing Database Design Patterns/5. Likes Creation.srt 10KB
  354. 12. Local PostgreSQL Installation/1. PostgreSQL Installation on macOS.srt 10KB
  355. 15. Database Structure Design Patterns/2. Using a SQL Design Tool.srt 10KB
  356. 14. Database-Side Validation and Constraints/13. So Where Are We Applying Validation.srt 10KB
  357. 1. Simple - But Powerful - SQL Statements/14. String Operators and Functions.srt 10KB
  358. 28. Simplifying Queries with Views/1. Most Popular Users.srt 10KB
  359. 18. How to Build a 'Hashtag' System/4. A Few More User Columns.srt 10KB
  360. 4. Relating Records with Joins/9. Missing Data in Joins.srt 10KB
  361. 9. Assembling Queries with SubQueries/21. A New Where Operator.srt 9KB
  362. 16. How to Build a 'Like' System/6. Polymorphic Associations.srt 9KB
  363. 34. Data Access Pattern - Repositories/5. Fixing Casing.srt 9KB
  364. 8. Unions and Intersections with Sets/4. Removing Commonalities with Except.srt 9KB
  365. 4. Relating Records with Joins/8. Alternate Forms of Syntax.srt 9KB
  366. 19. How to Design a 'Follower' System/1. Designing a Follower System.srt 9KB
  367. 25. Advanced Query Tuning/5. Startup vs Total Costs.srt 9KB
  368. 20. Implementing Database Design Patterns/7. Creating Hashtags, Hashtag Posts, and Followers.srt 9KB
  369. 13. PostgreSQL Complex Datatypes/8. Really Awesome Intervals.srt 9KB
  370. 9. Assembling Queries with SubQueries/16. Data Structure with Where Subqueries.srt 9KB
  371. 3. Working with Tables/11. Auto-Generated ID's.srt 9KB
  372. 9. Assembling Queries with SubQueries/1. What's a Subquery.srt 9KB
  373. 32. Schema vs Data Migrations/3. Properly Running Data and Schema Migrations.srt 9KB
  374. 14. Database-Side Validation and Constraints/7. Applying a Unique Constraint to One column.srt 9KB
  375. 22. Understanding the Internals of PostgreSQL/2. Where Does Postgres Store Data.srt 9KB
  376. 36. Fast Parallel Testing/10. Controlling Schema Access with Search Paths.srt 9KB
  377. 8. Unions and Intersections with Sets/1. Handling Sets with Union.srt 9KB
  378. 3. Working with Tables/6. One-to-One and Many-to-Many Relationships.srt 9KB
  379. 3. Working with Tables/17. Foreign Key Constraints Around Insertion.srt 9KB
  380. 9. Assembling Queries with SubQueries/4. Subqueries in a Select.srt 8KB
  381. 23. A Look at Indexes for Performance/5. Benchmarking Queries.srt 8KB
  382. 28. Simplifying Queries with Views/3. Creating a View.srt 8KB
  383. 13. PostgreSQL Complex Datatypes/7. Times, Dates, and Timestamps.srt 8KB
  384. 24. Basic Query Tuning/2. Explain and Explain Analyze.srt 8KB
  385. 16. How to Build a 'Like' System/3. Designing a Like System.srt 8KB
  386. 5. Aggregation of Records/2. Picturing Group By.srt 8KB
  387. 20. Implementing Database Design Patterns/6. Photo Tags and Caption Tags.srt 8KB
  388. 9. Assembling Queries with SubQueries/22. Finally Some!.srt 8KB
  389. 23. A Look at Indexes for Performance/6. Downsides of Indexes.srt 8KB
  390. 36. Fast Parallel Testing/6. Assumptions Around Content.srt 8KB
  391. 36. Fast Parallel Testing/3. Connecting to a DB For Tests.srt 8KB
  392. 1. Simple - But Powerful - SQL Statements/3. Database Design.srt 8KB
  393. 34. Data Access Pattern - Repositories/6. Finding Particular Users.srt 8KB
  394. 36. Fast Parallel Testing/16. Cleaning up Schemas and Roles.srt 8KB
  395. 24. Basic Query Tuning/1. The Query Processing Pipeline.srt 8KB
  396. 36. Fast Parallel Testing/9. Creating and Accessing Schemas.srt 8KB
  397. 36. Fast Parallel Testing/15. Test Helpers.srt 8KB
  398. 36. Fast Parallel Testing/7. Issues with Parallel Tests.srt 8KB
  399. 3. Working with Tables/8. Primary Keys and Foreign Keys.srt 8KB
  400. 31. Managing Database Design with Schema Migrations/4. A Few Notes on Migrations Libraries.srt 8KB
  401. 4. Relating Records with Joins/12.1 010 - sql - cumulative.sql 8KB
  402. 4. Relating Records with Joins/9.1 007 - joins - cumulative.sql 8KB
  403. 5. Aggregation of Records/14. Filtering Groups with Having.srt 8KB
  404. 12. Local PostgreSQL Installation/2. PGAdmin Setup on macOS.srt 8KB
  405. 16. How to Build a 'Like' System/1. Requirements of a Like System.srt 8KB
  406. 4. Relating Records with Joins/1. Adding Some Data.html 8KB
  407. 1. Simple - But Powerful - SQL Statements/5. Creating Tables.srt 7KB
  408. 4. Relating Records with Joins/20. A Bit of Practice.srt 7KB
  409. 3. Working with Tables/18. Constraints Around Deletion.srt 7KB
  410. 14. Database-Side Validation and Constraints/11. Checks Over Multiple Columns.srt 7KB
  411. 2. Filtering Records/3. Compound Where Clauses.srt 7KB
  412. 1. Simple - But Powerful - SQL Statements/7. Inserting Data Into a Table.srt 7KB
  413. 9. Assembling Queries with SubQueries/2. Thinking About the Structure of Data.srt 7KB
  414. 31. Managing Database Design with Schema Migrations/2. Migration Files.srt 7KB
  415. 13. PostgreSQL Complex Datatypes/5. Reminder on Character Types.srt 7KB
  416. 36. Fast Parallel Testing/5. Multi-DB Setup.srt 7KB
  417. 3. Working with Tables/12. Creating Foreign Key Columns.srt 7KB
  418. 1. Simple - But Powerful - SQL Statements/2. What is PostgreSQL All About.srt 7KB
  419. 17. How to Build a 'Mention' System/5. Update For Tags.srt 7KB
  420. 1. Simple - But Powerful - SQL Statements/10. Calculated Columns.srt 7KB
  421. 33. Accessing PostgreSQL From API's/3. One Fast Migration.srt 7KB
  422. 5. Aggregation of Records/5. Combining Group By and Aggregates.srt 7KB
  423. 36. Fast Parallel Testing/12. Strategy for Isolation.srt 7KB
  424. 13. PostgreSQL Complex Datatypes/2. Data Types.srt 7KB
  425. 34. Data Access Pattern - Repositories/4. Casing Issues.srt 7KB
  426. 16. How to Build a 'Like' System/10. So Which Approach.srt 7KB
  427. 21. Approaching and Writing Complex Queries/3. Restoring from Scratch.srt 7KB
  428. 22. Understanding the Internals of PostgreSQL/5. Block Data Layout.srt 7KB
  429. 29. Optimizing Queries with Materialized Views/3. Reminder on Left Joins.srt 7KB
  430. 32. Schema vs Data Migrations/4. Creating a Posts Table.srt 7KB
  431. 14. Database-Side Validation and Constraints/1. Thinking About Validation.srt 7KB
  432. 9. Assembling Queries with SubQueries/14. Subqueries in a Join Clause.srt 7KB
  433. 35. Security Around PostgreSQL/6. Handling Updates.srt 7KB
  434. 33. Accessing PostgreSQL From API's/4. Building the Users Router.srt 7KB
  435. 3. Working with Tables/20. Testing Deletion Constraints.srt 7KB
  436. 11. Utility Operators, Keywords, and Functions/3. The Case Keyword.srt 7KB
  437. 21. Approaching and Writing Complex Queries/2. Adding Some Data.srt 6KB
  438. 36. Fast Parallel Testing/11. Routing Schema Access.srt 6KB
  439. 32. Schema vs Data Migrations/12. Updating the App Server.srt 6KB
  440. 12. Local PostgreSQL Installation/3. Postgres installation on Windows.srt 6KB
  441. 36. Fast Parallel Testing/8. Isolation with Schemas.srt 6KB
  442. 13. PostgreSQL Complex Datatypes/1. What'd We Just Do.srt 6KB
  443. 23. A Look at Indexes for Performance/1. Full Table Scans.srt 6KB
  444. 10. Selecting Distinct Records/1. Selecting Distinct Values.srt 6KB
  445. 32. Schema vs Data Migrations/8. Writing Values to Both Columns.srt 6KB
  446. 14. Database-Side Validation and Constraints/4. Solving a Gotcha with Null Constraints.srt 6KB
  447. 2. Filtering Records/13. Updating Rows.srt 6KB
  448. 9. Assembling Queries with SubQueries/20. The Not In Operator with a List.srt 6KB
  449. 32. Schema vs Data Migrations/10. Updating Values.srt 6KB
  450. 4. Relating Records with Joins/13. Does Order Matter.srt 6KB
  451. 30. Handling Concurrency and Reversibility with Transactions/1. What are Transactions Used For.srt 6KB
  452. 32. Schema vs Data Migrations/1. Schema vs Data Migrations.srt 6KB
  453. 36. Fast Parallel Testing/14. Escaping Identifiers.srt 6KB
  454. 29. Optimizing Queries with Materialized Views/2. Grouping by Week.srt 6KB
  455. 35. Security Around PostgreSQL/7. And, Finally, Delete.srt 6KB
  456. 4. Relating Records with Joins/12. Each Join in Practice.srt 6KB
  457. 35. Security Around PostgreSQL/5. Inserting Users.srt 6KB
  458. 23. A Look at Indexes for Performance/4. Creating an Index.srt 6KB
  459. 28. Simplifying Queries with Views/2. A Possible Solution for Merging Tables.srt 6KB
  460. 30. Handling Concurrency and Reversibility with Transactions/4. Transaction Cleanup on Crash.srt 6KB
  461. 14. Database-Side Validation and Constraints/10. Adding a Validation Check.srt 6KB
  462. 16. How to Build a 'Like' System/8. The Simplest Alternative.srt 6KB
  463. 18. How to Build a 'Hashtag' System/5. Why No Number of Followers or Posts.srt 6KB
  464. 32. Schema vs Data Migrations/7. Adding the Loc Column.srt 6KB
  465. 18. How to Build a 'Hashtag' System/3. Including the Hashtag Table.srt 6KB
  466. 18. How to Build a 'Hashtag' System/2. Tables for Hashtags.srt 6KB
  467. 2. Filtering Records/1. Filtering Rows with Where.srt 6KB
  468. 26. Simple Common Table Expressions/3. So What's a CTE.srt 6KB
  469. 22. Understanding the Internals of PostgreSQL/3. Heaps, Blocks, and Tuples.srt 6KB
  470. 23. A Look at Indexes for Performance/8. Automatically Generated Indexes.srt 6KB
  471. 34. Data Access Pattern - Repositories/1. The Repository Pattern.srt 6KB
  472. 8. Unions and Intersections with Sets/2. A Few Notes on Union.srt 6KB
  473. 26. Simple Common Table Expressions/2. A Quick Solution.srt 5KB
  474. 1. Simple - But Powerful - SQL Statements/6. Analyzing CREATE TABLE.srt 5KB
  475. 5. Aggregation of Records/17. A Having Exercise Overview.srt 5KB
  476. 9. Assembling Queries with SubQueries/29. A Select Without a From.srt 5KB
  477. 36. Fast Parallel Testing/17. Finally... Parallel Tests!.srt 5KB
  478. 14. Database-Side Validation and Constraints/8. Multi-Column Uniqueness.srt 5KB
  479. 4. Relating Records with Joins/2. Queries with Joins and Aggregations.srt 5KB
  480. 31. Managing Database Design with Schema Migrations/9. Generating and Applying a Second Migration.srt 5KB
  481. 11. Utility Operators, Keywords, and Functions/1. The Greatest Value in a List.srt 5KB
  482. 27. Recursive Common Table Expressions/1. Recursive CTE's.srt 5KB
  483. 8. Unions and Intersections with Sets/3. Commonalities with Intersect.srt 5KB
  484. 2. Filtering Records/14. Deleting Rows.srt 5KB
  485. 28. Simplifying Queries with Views/4. When to Use a View.srt 5KB
  486. 36. Fast Parallel Testing/1. A Note on Testing.srt 5KB
  487. 16. How to Build a 'Like' System/2. How Not to Design a Like System.srt 5KB
  488. 3. Working with Tables/23. Adding Some Complexity.srt 5KB
  489. 4. Relating Records with Joins/17. Two Possible Solutions.srt 5KB
  490. 36. Fast Parallel Testing/4. Disconnecting After Tests.srt 4KB
  491. 5. Aggregation of Records/7. Visualizing More Grouping.srt 4KB
  492. 5. Aggregation of Records/4. Aggregate Functions.srt 4KB
  493. 31. Managing Database Design with Schema Migrations/6. Project Creation.srt 4KB
  494. 31. Managing Database Design with Schema Migrations/3. Issues Solved by Migrations.srt 4KB
  495. 3. Working with Tables/21. Setting Foreign Keys to Null on Delete.srt 4KB
  496. 9. Assembling Queries with SubQueries/9. From Subqueries that Return a Value.srt 4KB
  497. 15. Database Structure Design Patterns/4. Here's the Plan.srt 4KB
  498. 35. Security Around PostgreSQL/4. Reminder on Post Requests.srt 4KB
  499. 5. Aggregation of Records/6. A Gotcha with Count.srt 4KB
  500. 7. Sorting Records/2. Two Variations on Sorting.srt 4KB
  501. 23. A Look at Indexes for Performance/2. What's an Index.srt 4KB
  502. 4. Relating Records with Joins/22. Exercise Solution.srt 4KB
  503. 5. Aggregation of Records/15. Having In Action.srt 4KB
  504. 13. PostgreSQL Complex Datatypes/6. Boolean Data Types.srt 4KB
  505. 29. Optimizing Queries with Materialized Views/1. Materialized Views.srt 4KB
  506. 2. Filtering Records/2. More on the Where Keyword.srt 4KB
  507. 5. Aggregation of Records/19. A Quick Solution.srt 4KB
  508. 4. Relating Records with Joins/10. Why Wasn't It Included.srt 4KB
  509. 28. Simplifying Queries with Views/5. Deleting and Changing Views.srt 4KB
  510. 22. Understanding the Internals of PostgreSQL/1. Thinking About Performance.srt 4KB
  511. 7. Sorting Records/1. The Basics of Sorting.srt 4KB
  512. 13. PostgreSQL Complex Datatypes/3. Fast Rules on Numeric Data Types.srt 3KB
  513. 5. Aggregation of Records/1. Aggregating and Grouping.srt 3KB
  514. 6. Working with Large Datasets/6. Remember Joins.srt 3KB
  515. 6. Working with Large Datasets/5. Group By Review Solution.srt 3KB
  516. 20. Implementing Database Design Patterns/4. Comments Creation.srt 3KB
  517. 3. Working with Tables/14. Exercise Overview.srt 3KB
  518. 1. Simple - But Powerful - SQL Statements/8. Retrieving Data with Select.srt 3KB
  519. 20. Implementing Database Design Patterns/1. Back to Postgres.srt 3KB
  520. 4. Relating Records with Joins/4. Another Quick Join.srt 3KB
  521. 30. Handling Concurrency and Reversibility with Transactions/2. Some Sample Data.srt 3KB
  522. 33. Accessing PostgreSQL From API's/7. Query and Close.srt 3KB
  523. 25. Advanced Query Tuning/6. Costs Flow Up.srt 3KB
  524. 21. Approaching and Writing Complex Queries/4. Highest User ID's Exercise.srt 3KB
  525. 9. Assembling Queries with SubQueries/19. Exercise Solution.srt 3KB
  526. 2. Filtering Records/10. Calculations in Where Clauses.srt 3KB
  527. 37. Bonus!/1. Bonus!.html 3KB
  528. 11. Utility Operators, Keywords, and Functions/2. And the Least Value in a List!.srt 3KB
  529. 3. Working with Tables/16. Foreign Key Creation Solution.srt 3KB
  530. 26. Simple Common Table Expressions/1. Common Table Expressions.srt 3KB
  531. 20. Implementing Database Design Patterns/7.1 007 - db.sql 3KB
  532. 21. Approaching and Writing Complex Queries/7. Solving for Posts by User.srt 3KB
  533. 3. Working with Tables/1. The Plan Moving Forward.srt 3KB
  534. 30. Handling Concurrency and Reversibility with Transactions/5. Closing Aborted Transactions.srt 3KB
  535. 17. How to Build a 'Mention' System/2. Adding Captions and Locations.srt 3KB
  536. 23. A Look at Indexes for Performance/7. Index Types.srt 3KB
  537. 4. Relating Records with Joins/7. A Joinful Solution.srt 2KB
  538. 16. How to Build a 'Like' System/5. Making a Reaction System Instead.srt 2KB
  539. 21. Approaching and Writing Complex Queries/9. Solution for Likes Per User.srt 2KB
  540. 9. Assembling Queries with SubQueries/26. A Quick Solution.srt 2KB
  541. 2. Filtering Records/9. A Where With Lists Solution.srt 2KB
  542. 20. Implementing Database Design Patterns/6.1 006 - db.sql 2KB
  543. 8. Unions and Intersections with Sets/5. Union Exercise Overview.srt 2KB
  544. 5. Aggregation of Records/13. Solution.srt 2KB
  545. 2. Filtering Records/16. A Solution for Updating Rows.srt 2KB
  546. 5. Aggregation of Records/10. Grouping Solution.srt 2KB
  547. 6. Working with Large Datasets/8. Of Course You Remember!.srt 2KB
  548. 8. Unions and Intersections with Sets/7. Exercise Solution.srt 2KB
  549. 7. Sorting Records/6. Exercise Solution.srt 2KB
  550. 6. Working with Large Datasets/3. Some Group By Practice.srt 2KB
  551. 2. Filtering Records/18. Solution for Deleting Rows.srt 2KB
  552. 9. Assembling Queries with SubQueries/11. Exercise Overview.srt 2KB
  553. 21. Approaching and Writing Complex Queries/5. Solution for User ID's.srt 2KB
  554. 9. Assembling Queries with SubQueries/7. Select Solution.srt 2KB
  555. 4. Relating Records with Joins/5. Exercise Overview.srt 2KB
  556. 21. Approaching and Writing Complex Queries/6. Posts by a Particular User.srt 2KB
  557. 9. Assembling Queries with SubQueries/32. Exercise Solution.srt 2KB
  558. 9. Assembling Queries with SubQueries/5. Exercise Overview.srt 2KB
  559. 1. Simple - But Powerful - SQL Statements/13. Exercise Solution.srt 2KB
  560. 20. Implementing Database Design Patterns/5.1 005 - db.sql 2KB
  561. 1. Simple - But Powerful - SQL Statements/11. Calculating Phone Revenue.srt 2KB
  562. 33. Accessing PostgreSQL From API's/1. Section Goal.srt 1KB
  563. 4. Relating Records with Joins/15. Exercise Overview.srt 1KB
  564. 32. Schema vs Data Migrations/5.1 005 - index.js 1KB
  565. 2. Filtering Records/6. A Where Solution.srt 1KB
  566. 3. Working with Tables/21.1 015 - tables - cumulative.sql 1KB
  567. 9. Assembling Queries with SubQueries/30. Exercise Overview.srt 1KB
  568. 5. Aggregation of Records/8. Exercise Overview.srt 1KB
  569. 20. Implementing Database Design Patterns/4.1 004 - db.sql 1KB
  570. 5. Aggregation of Records/11. Adding a Layer of Difficulty.srt 1KB
  571. 2. Filtering Records/7. Where With Lists.srt 1KB
  572. 32. Schema vs Data Migrations/6. Web Server Setup Instructions.html 1KB
  573. 3. Working with Tables/20.1 014 - tables - cumulative.sql 994B
  574. 2. Filtering Records/4. A Where Exercise Overview.srt 960B
  575. 10. Selecting Distinct Records/4. A Distinct Solution.srt 929B
  576. 32. Schema vs Data Migrations/11. Migrations Setup Instructions.html 925B
  577. 10. Selecting Distinct Records/2. Exercise Overview.srt 874B
  578. 20. Implementing Database Design Patterns/3.1 003 - db.sql 791B
  579. 9. Assembling Queries with SubQueries/24. Exercise Overview.srt 741B
  580. 7. Sorting Records/4. Exercise Overview.srt 690B
  581. 3. Working with Tables/19. Commands You’ll Need for the Next Video.html 676B
  582. 3. Working with Tables/17.2 012 - tables - cumulative.sql 600B
  583. 3. Working with Tables/13.2 009 - tables - cumulative.sql 536B
  584. 3. Working with Tables/20.2 014 - tables.sql 469B
  585. 15. Database Structure Design Patterns/5.1 005 - design.dbml 455B
  586. 1. Simple - But Powerful - SQL Statements/14.1 012 - sql.sql 404B
  587. 1. Simple - But Powerful - SQL Statements/7.2 005 - sql - cumulative.sql 384B
  588. 20. Implementing Database Design Patterns/2.1 002 - db.sql 375B
  589. 32. Schema vs Data Migrations/11.1 01-lng-lat-to-loc.js 364B
  590. 3. Working with Tables/12.2 008 - tables - cumulative.sql 348B
  591. 3. Working with Tables/21.2 015 - tables.sql 340B
  592. 3. Working with Tables/13.1 009 - tables.sql 326B
  593. 1. Simple - But Powerful - SQL Statements/7.1 005 - sql.sql 278B
  594. 1. Simple - But Powerful - SQL Statements/1. Join Our Community!.html 271B
  595. 31. Managing Database Design with Schema Migrations/5. A Note About Node Installation.html 264B
  596. 21. Approaching and Writing Complex Queries/1. Quick Note About Adding Some Data.html 251B
  597. 3. Working with Tables/17.1 012 - tables.sql 199B
  598. 3. Working with Tables/12.1 008 - tables.sql 197B
  599. 3. Working with Tables/11.2 007 - tables.sql 194B
  600. 3. Working with Tables/11.1 007 - tables - cumulative.sql 172B
  601. 0. Websites you may like/[FCS Forum].url 133B
  602. 1. Simple - But Powerful - SQL Statements/12. Using Calculated Columns.html 129B
  603. 1. Simple - But Powerful - SQL Statements/4. Database Terminology.html 129B
  604. 1. Simple - But Powerful - SQL Statements/9. Create, Insert, and Select!.html 129B
  605. 10. Selecting Distinct Records/3. Some Practice with Distinct.html 129B
  606. 14. Database-Side Validation and Constraints/12. Does It Pass a Check.html 129B
  607. 14. Database-Side Validation and Constraints/5. Creating NULL Constraints.html 129B
  608. 14. Database-Side Validation and Constraints/9. Is It Unique.html 129B
  609. 16. How to Build a 'Like' System/4. Building a Similar System.html 129B
  610. 16. How to Build a 'Like' System/9. Polymorphic Associations.html 129B
  611. 2. Filtering Records/11. Trying Calculations in Where Clauses.html 129B
  612. 2. Filtering Records/15. Try Updating Records In a Table!.html 129B
  613. 2. Filtering Records/17. Practice Deleting Records.html 129B
  614. 2. Filtering Records/5. Practicing Where Statements.html 129B
  615. 2. Filtering Records/8. A More Challenging 'Where'.html 129B
  616. 22. Understanding the Internals of PostgreSQL/4. Terminology Check.html 129B
  617. 23. A Look at Indexes for Performance/9. Using Automatically Created Indexes.html 129B
  618. 24. Basic Query Tuning/3. Explain Vs Explain Analyze.html 129B
  619. 25. Advanced Query Tuning/4. Calculating Costs.html 129B
  620. 29. Optimizing Queries with Materialized Views/6. Views vs Materialized Views.html 129B
  621. 3. Working with Tables/10. Foreign Keys; How Do They Work.html 129B
  622. 3. Working with Tables/15. Creating and Using Foreign Keys.html 129B
  623. 3. Working with Tables/22. What Happens On Delete.html 129B
  624. 3. Working with Tables/3. Let's Design Some Schema.html 129B
  625. 3. Working with Tables/5. A 'Has One' or 'Has Many'.html 129B
  626. 3. Working with Tables/7. Identifying One-to-One and Many-to-Many Relationships.html 129B
  627. 4. Relating Records with Joins/14. Test Your Joining Knowledge.html 129B
  628. 4. Relating Records with Joins/16. Joins, Joins, Join!.html 129B
  629. 4. Relating Records with Joins/21. Three Way Exercise.html 129B
  630. 4. Relating Records with Joins/6. Practice Joining Data.html 129B
  631. 5. Aggregation of Records/12. Grouping With a Join!.html 129B
  632. 5. Aggregation of Records/18. Practice Yourself Some Having.html 129B
  633. 5. Aggregation of Records/3. Selecting Columns After Grouping.html 129B
  634. 5. Aggregation of Records/9. Practice For Grouping and Aggregating.html 129B
  635. 6. Working with Large Datasets/4. Group By Review.html 129B
  636. 6. Working with Large Datasets/7. Inner Join Review.html 129B
  637. 7. Sorting Records/5. Sorting, Offsetting, and Limiting.html 129B
  638. 8. Unions and Intersections with Sets/6. Merging Results with Union.html 129B
  639. 9. Assembling Queries with SubQueries/12. Subquery From's.html 129B
  640. 9. Assembling Queries with SubQueries/18. Subquery Where's.html 129B
  641. 9. Assembling Queries with SubQueries/23. Is It A Valid Subquery.html 129B
  642. 9. Assembling Queries with SubQueries/25. Practice Your Subqueries!.html 129B
  643. 9. Assembling Queries with SubQueries/3. What's the Data Look Like.html 129B
  644. 9. Assembling Queries with SubQueries/31. From-less Selects.html 129B
  645. 9. Assembling Queries with SubQueries/6. Embedding in Select.html 129B
  646. 0. Websites you may like/[FreeCourseSite.com].url 127B
  647. 0. Websites you may like/[CourseClub.ME].url 122B
  648. 1. Simple - But Powerful - SQL Statements/5.1 003 - sql.sql 104B
  649. 2. Filtering Records/1.1 013 - sql.sql 48B