589689.xyz

GetFreeCourses.Co-Udemy-SQL and PostgreSQL The Complete Developer's Guide

  • 收录时间:2023-10-05 17:23:23
  • 文件大小:8GB
  • 下载次数:1
  • 最近下载:2023-10-05 17:23:23
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 22 - Understanding the Internals of PostgreSQL/005 Heap File Layout.mp4 597MB
  2. 23 - A Look at Indexes for Performance/009 Behind the Scenes of Indexes.mp4 399MB
  3. 31 - Managing Database Design with Schema Migrations/001 A Story on Migrations.mp4 140MB
  4. 04 - Relating Records with Joins/010 Four Kinds of Joins.mp4 125MB
  5. 27 - Recursive Common Table Expressions/005 Walking Through Recursion.mp4 109MB
  6. 09 - Assembling Queries with SubQueries/021 Probably Too Much About Correlated Subqueries.mp4 107MB
  7. 25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost.mp4 103MB
  8. 18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System.mp4 98MB
  9. 32 - Schema vs Data Migrations/009 Transaction Locks.mp4 96MB
  10. 17 - How to Build a 'Mention' System/001 Additional Features Around Posts.mp4 96MB
  11. 25 - Advanced Query Tuning/003 A Touch More on Costs.mp4 95MB
  12. 24 - Basic Query Tuning/003 Solving an Explain Mystery.mp4 80MB
  13. 17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions.mp4 73MB
  14. 32 - Schema vs Data Migrations/002 Dangers Around Data Migrations.mp4 70MB
  15. 23 - A Look at Indexes for Performance/003 How an Index Works.mp4 69MB
  16. 31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations.mp4 68MB
  17. 17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags.mp4 67MB
  18. 36 - Fast Parallel Testing/013 Programmatic Schema Creation.mp4 66MB
  19. 30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions.mp4 65MB
  20. 16 - How to Build a 'Like' System/006 Polymorphic Association Alternative Implementation.mp4 64MB
  21. 03 - Working with Tables/006 Understanding Foreign Keys.mp4 63MB
  22. 27 - Recursive Common Table Expressions/002 Recursive CTE's Step by Step.mp4 63MB
  23. 32 - Schema vs Data Migrations/005 A Small Web Server.mp4 62MB
  24. 04 - Relating Records with Joins/012 Does Order Matter.mp4 61MB
  25. 20 - Implementing Database Design Patterns/002 Creating Tables with Checks.mp4 61MB
  26. 29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query.mp4 55MB
  27. 36 - Fast Parallel Testing/003 Connecting to a DB For Tests.mp4 54MB
  28. 09 - Assembling Queries with SubQueries/008 Example of a Subquery in a From.mp4 54MB
  29. 16 - How to Build a 'Like' System/005 Polymorphic Associations.mp4 53MB
  30. 25 - Advanced Query Tuning/002 Calculating Cost by Hand.mp4 51MB
  31. 03 - Working with Tables/002 Approaching Database Design.mp4 50MB
  32. 34 - Data Access Pattern - Repositories/005 Fixing Casing.mp4 50MB
  33. 04 - Relating Records with Joins/016 Three Way Joins.mp4 50MB
  34. 01 - Simple - But Powerful - SQL Statements/004 Database Design.mp4 49MB
  35. 13 - PostgreSQL Complex Datatypes/004 More on Number Data Types.mp4 48MB
  36. 15 - Database Structure Design Patterns/002 Using a SQL Design Tool.mp4 47MB
  37. 31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations.mp4 46MB
  38. 33 - Accessing PostgreSQL From API's/006 Validating Connection Credentials.mp4 45MB
  39. 25 - Advanced Query Tuning/004 Startup vs Total Costs.mp4 45MB
  40. 09 - Assembling Queries with SubQueries/006 Subqueries in a From.mp4 44MB
  41. 09 - Assembling Queries with SubQueries/022 More on Correlated Subqueries.mp4 44MB
  42. 31 - Managing Database Design with Schema Migrations/002 Migration Files.mp4 44MB
  43. 09 - Assembling Queries with SubQueries/013 Data Structure with Where Subqueries.mp4 44MB
  44. 36 - Fast Parallel Testing/015 Test Helpers.mp4 43MB
  45. 27 - Recursive Common Table Expressions/003 Why Use Recursive CTE's.mp4 43MB
  46. 14 - Database-Side Validation and Constraints/006 Applying a Unique Constraint to One column.mp4 43MB
  47. 24 - Basic Query Tuning/002 Explain and Explain Analyze.mp4 43MB
  48. 36 - Fast Parallel Testing/002 Assertions Around User Count.mp4 42MB
  49. 20 - Implementing Database Design Patterns/006 Photo Tags and Caption Tags.mp4 41MB
  50. 03 - Working with Tables/003 One-to-Many and Many-to-One Relationships.mp4 41MB
  51. 36 - Fast Parallel Testing/011 Routing Schema Access.mp4 41MB
  52. 04 - Relating Records with Joins/011 Each Join in Practice.mp4 41MB
  53. 03 - Working with Tables/013 Constraints Around Deletion.mp4 41MB
  54. 25 - Advanced Query Tuning/006 Use My Index!.mp4 39MB
  55. 09 - Assembling Queries with SubQueries/017 A New Where Operator.mp4 39MB
  56. 09 - Assembling Queries with SubQueries/016 The Not In Operator with a List.mp4 39MB
  57. 03 - Working with Tables/009 Running Queries on Associated Data.mp4 38MB
  58. 35 - Security Around PostgreSQL/002 Handling SQL Injection with Prepared Statements.mp4 38MB
  59. 23 - A Look at Indexes for Performance/001 Full Table Scans.mp4 37MB
  60. 22 - Understanding the Internals of PostgreSQL/002 Where Does Postgres Store Data.mp4 37MB
  61. 05 - Aggregation of Records/011 Filtering Groups with Having.mp4 37MB
  62. 12 - Local PostgreSQL Installation/002 PGAdmin Setup on macOS.mp4 37MB
  63. 04 - Relating Records with Joins/003 Joining Data from Different Tables.mp4 37MB
  64. 09 - Assembling Queries with SubQueries/012 More Useful - Subqueries with Where.mp4 37MB
  65. 27 - Recursive Common Table Expressions/004 Writing the Query.mp4 37MB
  66. 20 - Implementing Database Design Patterns/003 Posts Creation.mp4 36MB
  67. 29 - Optimizing Queries with Materialized Views/005 Creating and Refreshing Materialized Views.mp4 36MB
  68. 36 - Fast Parallel Testing/007 Issues with Parallel Tests.mp4 36MB
  69. 28 - Simplifying Queries with Views/002 A Possible Solution for Merging Tables.mp4 36MB
  70. 14 - Database-Side Validation and Constraints/001 Thinking About Validation.mp4 35MB
  71. 29 - Optimizing Queries with Materialized Views/002 Grouping by Week.mp4 34MB
  72. 35 - Security Around PostgreSQL/003 Preventing SQL Injection.mp4 34MB
  73. 31 - Managing Database Design with Schema Migrations/004 A Few Notes on Migrations Libraries.mp4 34MB
  74. 26 - Simple Common Table Expressions/003 So What's a CTE.mp4 33MB
  75. 28 - Simplifying Queries with Views/003 Creating a View.mp4 33MB
  76. 36 - Fast Parallel Testing/006 Assumptions Around Content.mp4 33MB
  77. 30 - Handling Concurrency and Reversibility with Transactions/004 Transaction Cleanup on Crash.mp4 33MB
  78. 09 - Assembling Queries with SubQueries/018 Finally Some!.mp4 32MB
  79. 23 - A Look at Indexes for Performance/006 Downsides of Indexes.mp4 32MB
  80. 36 - Fast Parallel Testing/016 Cleaning up Schemas and Roles.mp4 31MB
  81. 04 - Relating Records with Joins/015 Where with Join.mp4 31MB
  82. 36 - Fast Parallel Testing/010 Controlling Schema Access with Search Paths.mp4 31MB
  83. 09 - Assembling Queries with SubQueries/001 What's a Subquery.mp4 31MB
  84. 13 - PostgreSQL Complex Datatypes/002 Data Types.mp4 31MB
  85. 35 - Security Around PostgreSQL/001 SQL Injection Exploits.mp4 30MB
  86. 14 - Database-Side Validation and Constraints/007 Multi-Column Uniqueness.mp4 30MB
  87. 13 - PostgreSQL Complex Datatypes/005 Reminder on Character Types.mp4 30MB
  88. 33 - Accessing PostgreSQL From API's/004 Building the Users Router.mp4 30MB
  89. 03 - Working with Tables/005 Primary Keys and Foreign Keys.mp4 30MB
  90. 05 - Aggregation of Records/002 Picturing Group By.mp4 29MB
  91. 04 - Relating Records with Joins/008 Missing Data in Joins.mp4 29MB
  92. 15 - Database Structure Design Patterns/003 A Config-based Schema Designer.mp4 29MB
  93. 05 - Aggregation of Records/013 More on Having!.mp4 28MB
  94. 14 - Database-Side Validation and Constraints/002 Creating and Viewing Tables in PGAdmin.mp4 28MB
  95. 04 - Relating Records with Joins/002 Queries with Joins and Aggregations.mp4 28MB
  96. 18 - How to Build a 'Hashtag' System/004 A Few More User Columns.mp4 28MB
  97. 36 - Fast Parallel Testing/008 Isolation with Schemas.mp4 27MB
  98. 16 - How to Build a 'Like' System/007 The Simplest Alternative.mp4 27MB
  99. 19 - How to Design a 'Follower' System/001 Designing a Follower System.mp4 26MB
  100. 16 - How to Build a 'Like' System/003 Designing a Like System.mp4 26MB
  101. 16 - How to Build a 'Like' System/001 Requirements of a Like System.mp4 26MB
  102. 24 - Basic Query Tuning/001 The Query Processing Pipeline.mp4 26MB
  103. 36 - Fast Parallel Testing/014 Escaping Identifiers.mp4 26MB
  104. 04 - Relating Records with Joins/007 Alternate Forms of Syntax.mp4 25MB
  105. 28 - Simplifying Queries with Views/001 Most Popular Users.mp4 25MB
  106. 34 - Data Access Pattern - Repositories/002 Creating a Repository.mp4 25MB
  107. 04 - Relating Records with Joins/009 Why Wasn't It Included.mp4 25MB
  108. 03 - Working with Tables/004 One-to-One and Many-to-Many Relationships.mp4 25MB
  109. 33 - Accessing PostgreSQL From API's/003 One Fast Migration.mp4 24MB
  110. 20 - Implementing Database Design Patterns/005 Likes Creation.mp4 24MB
  111. 09 - Assembling Queries with SubQueries/002 Thinking About the Structure of Data.mp4 24MB
  112. 34 - Data Access Pattern - Repositories/003 Accessing the API.mp4 24MB
  113. 21 - Approaching and Writing Complex Queries/001 ig.sql 24MB
  114. 17 - How to Build a 'Mention' System/005 Update For Tags.mp4 23MB
  115. 12 - Local PostgreSQL Installation/003 Postgres installation on Windows.mp4 23MB
  116. 03 - Working with Tables/007 Auto-Generated ID's.mp4 23MB
  117. 33 - Accessing PostgreSQL From API's/005 Understanding Connection Pools.mp4 23MB
  118. 22 - Understanding the Internals of PostgreSQL/003 Heaps, Blocks, and Tuples.mp4 23MB
  119. 23 - A Look at Indexes for Performance/005 Benchmarking Queries.mp4 23MB
  120. 09 - Assembling Queries with SubQueries/003 Subqueries in a Select.mp4 23MB
  121. 30 - Handling Concurrency and Reversibility with Transactions/001 What are Transactions Used For.mp4 23MB
  122. 14 - Database-Side Validation and Constraints/005 Default Column Values.mp4 22MB
  123. 03 - Working with Tables/012 Foreign Key Constraints Around Insertion.mp4 22MB
  124. 14 - Database-Side Validation and Constraints/010 So Where Are We Applying Validation.mp4 22MB
  125. 36 - Fast Parallel Testing/005 Multi-DB Setup.mp4 22MB
  126. 32 - Schema vs Data Migrations/004 Creating a Posts Table.mp4 22MB
  127. 32 - Schema vs Data Migrations/007 Adding the Loc Column.mp4 22MB
  128. 13 - PostgreSQL Complex Datatypes/007 Times, Dates, and Timestamps.mp4 21MB
  129. 21 - Approaching and Writing Complex Queries/003 Restoring from Scratch.mp4 21MB
  130. 28 - Simplifying Queries with Views/004 When to Use a View.mp4 21MB
  131. 12 - Local PostgreSQL Installation/001 PostgreSQL Installation on macOS.mp4 21MB
  132. 14 - Database-Side Validation and Constraints/003 Applying a Null Constraint.mp4 21MB
  133. 15 - Database Structure Design Patterns/005 Rebuilding Some Schema.mp4 21MB
  134. 08 - Unions and Intersections with Sets/004 Removing Commonalities with Except.mp4 20MB
  135. 32 - Schema vs Data Migrations/001 Schema vs Data Migrations.mp4 20MB
  136. 20 - Implementing Database Design Patterns/007 Creating Hashtags, Hashtag Posts, and Followers.mp4 20MB
  137. 23 - A Look at Indexes for Performance/008 Automatically Generated Indexes.mp4 20MB
  138. 32 - Schema vs Data Migrations/003 Properly Running Data and Schema Migrations.mp4 20MB
  139. 08 - Unions and Intersections with Sets/001 Handling Sets with Union.mp4 20MB
  140. 13 - PostgreSQL Complex Datatypes/008 Really Awesome Intervals.mp4 19MB
  141. 07 - Sorting Records/003 Offset and Limit.mp4 19MB
  142. 36 - Fast Parallel Testing/009 Creating and Accessing Schemas.mp4 19MB
  143. 13 - PostgreSQL Complex Datatypes/001 What'd We Just Do.mp4 19MB
  144. 03 - Working with Tables/015 Testing Deletion Constraints.mp4 19MB
  145. 02 - Filtering Records/003 Compound Where Clauses.mp4 19MB
  146. 13 - PostgreSQL Complex Datatypes/003 Fast Rules on Numeric Data Types.mp4 19MB
  147. 36 - Fast Parallel Testing/017 Finally... Parallel Tests! (Final Lecture).mp4 19MB
  148. 34 - Data Access Pattern - Repositories/004 Casing Issues.mp4 19MB
  149. 03 - Working with Tables/008 Creating Foreign Key Columns.mp4 18MB
  150. 35 - Security Around PostgreSQL/007 And, Finally, Delete.mp4 18MB
  151. 14 - Database-Side Validation and Constraints/008 Adding a Validation Check.mp4 18MB
  152. 34 - Data Access Pattern - Repositories/006 Finding Particular Users.mp4 18MB
  153. 01 - Simple - But Powerful - SQL Statements/007 Inserting Data Into a Table.mp4 18MB
  154. 18 - How to Build a 'Hashtag' System/003 Including the Hashtag Table.mp4 18MB
  155. 34 - Data Access Pattern - Repositories/001 The Repository Pattern.mp4 18MB
  156. 04 - Relating Records with Joins/017 A Bit of Practice.mp4 18MB
  157. 01 - Simple - But Powerful - SQL Statements/006 Analyzing CREATE TABLE.mp4 18MB
  158. 36 - Fast Parallel Testing/012 Strategy for Isolation.mp4 18MB
  159. 02 - Filtering Records/010 Updating Rows.mp4 17MB
  160. 22 - Understanding the Internals of PostgreSQL/004 Block Data Layout.mp4 17MB
  161. 14 - Database-Side Validation and Constraints/009 Checks Over Multiple Columns.mp4 17MB
  162. 18 - How to Build a 'Hashtag' System/005 Why No Number of Followers or Posts.mp4 17MB
  163. 21 - Approaching and Writing Complex Queries/002 Adding Some Data.mp4 17MB
  164. 35 - Security Around PostgreSQL/006 Handling Updates.mp4 17MB
  165. 31 - Managing Database Design with Schema Migrations/009 Generating and Applying a Second Migration.mp4 17MB
  166. 09 - Assembling Queries with SubQueries/011 Subqueries in a Join Clause.mp4 17MB
  167. 08 - Unions and Intersections with Sets/002 A Few Notes on Union.mp4 17MB
  168. 04 - Relating Records with Joins/014 Two Possible Solutions.mp4 17MB
  169. 01 - Simple - But Powerful - SQL Statements/012 String Operators and Functions.mp4 16MB
  170. 32 - Schema vs Data Migrations/008 Writing Values to Both Columns.mp4 16MB
  171. 16 - How to Build a 'Like' System/002 How Not to Design a Like System.mp4 16MB
  172. 16 - How to Build a 'Like' System/008 So Which Approach.mp4 16MB
  173. 01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About.mp4 16MB
  174. 29 - Optimizing Queries with Materialized Views/003 Reminder on Left Joins.mp4 16MB
  175. 08 - Unions and Intersections with Sets/003 Commonalities with Intersect.mp4 15MB
  176. 32 - Schema vs Data Migrations/010 Updating Values.mp4 15MB
  177. 35 - Security Around PostgreSQL/005 Inserting Users.mp4 15MB
  178. 01 - Simple - But Powerful - SQL Statements/009 Calculated Columns.mp4 15MB
  179. 05 - Aggregation of Records/004 Combining Group By and Aggregates.mp4 15MB
  180. 18 - How to Build a 'Hashtag' System/002 Tables for Hashtags.mp4 14MB
  181. 35 - Security Around PostgreSQL/004 Reminder on Post Requests.mp4 14MB
  182. 14 - Database-Side Validation and Constraints/004 Solving a Gotcha with Null Constraints.mp4 14MB
  183. 11 - Utility Operators, Keywords, and Functions/003 The Case Keyword.mp4 13MB
  184. 32 - Schema vs Data Migrations/012 Updating the App Server.mp4 13MB
  185. 26 - Simple Common Table Expressions/002 A Quick Solution.mp4 13MB
  186. 23 - A Look at Indexes for Performance/004 Creating an Index.mp4 13MB
  187. 01 - Simple - But Powerful - SQL Statements/005 Creating Tables.mp4 13MB
  188. 36 - Fast Parallel Testing/004 Disconnecting After Tests.mp4 13MB
  189. 05 - Aggregation of Records/014 A Having Exercise Overview.mp4 13MB
  190. 03 - Working with Tables/016 Setting Foreign Keys to Null on Delete.mp4 13MB
  191. 28 - Simplifying Queries with Views/005 Deleting and Changing Views.mp4 13MB
  192. 10 - Selecting Distinct Records/001 Selecting Distinct Values.mp4 12MB
  193. 02 - Filtering Records/001 Filtering Rows with Where.mp4 12MB
  194. 27 - Recursive Common Table Expressions/001 Recursive CTE's.mp4 12MB
  195. 11 - Utility Operators, Keywords, and Functions/001 The Greatest Value in a List.mp4 12MB
  196. 32 - Schema vs Data Migrations/013 Dropping the Last Columns.mp4 12MB
  197. 05 - Aggregation of Records/003 Aggregate Functions.mp4 12MB
  198. 15 - Database Structure Design Patterns/001 Approaching More Complicated Designs.mp4 11MB
  199. 26 - Simple Common Table Expressions/001 Common Table Expressions.mp4 11MB
  200. 02 - Filtering Records/011 Deleting Rows.mp4 11MB
  201. 03 - Working with Tables/001 The Plan Moving Forward.mp4 11MB
  202. 09 - Assembling Queries with SubQueries/010 Exercise Solution.mp4 10MB
  203. 25 - Advanced Query Tuning/005 Costs Flow Up.mp4 10MB
  204. 23 - A Look at Indexes for Performance/002 What's an Index.mp4 10MB
  205. 31 - Managing Database Design with Schema Migrations/003 Issues Solved by Migrations.mp4 10MB
  206. 03 - Working with Tables/017 Adding Some Complexity.mp4 10MB
  207. 31 - Managing Database Design with Schema Migrations/006 Project Creation.mp4 10MB
  208. 05 - Aggregation of Records/006 Visualizing More Grouping.mp4 10MB
  209. 15 - Database Structure Design Patterns/004 Here's the Plan.mp4 10MB
  210. 07 - Sorting Records/002 Two Variations on Sorting.mp4 9MB
  211. 02 - Filtering Records/002 More on the Where Keyword.mp4 9MB
  212. 21 - Approaching and Writing Complex Queries/007 Solving for Posts by User.mp4 9MB
  213. 06 - Working with Large Datasets/005 Remember Joins.mp4 9MB
  214. 22 - Understanding the Internals of PostgreSQL/001 Thinking About Performance.mp4 9MB
  215. 09 - Assembling Queries with SubQueries/023 A Select Without a From.mp4 9MB
  216. 09 - Assembling Queries with SubQueries/007 From Subqueries that Return a Value.mp4 9MB
  217. 04 - Relating Records with Joins/004 Another Quick Join.mp4 9MB
  218. 17 - How to Build a 'Mention' System/002 Adding Captions and Locations.mp4 9MB
  219. 29 - Optimizing Queries with Materialized Views/001 Materialized Views.mp4 8MB
  220. 03 - Working with Tables/011 Foreign Key Creation Solution.mp4 8MB
  221. 03 - Working with Tables/010 Exercise Overview.mp4 8MB
  222. 13 - PostgreSQL Complex Datatypes/006 Boolean Data Types.mp4 8MB
  223. 06 - Working with Large Datasets/002 Investigating This Dataset.mp4 8MB
  224. 06 - Working with Large Datasets/004 Group By Review Solution.mp4 8MB
  225. 05 - Aggregation of Records/001 Aggregating and Grouping.mp4 8MB
  226. 01 - Simple - But Powerful - SQL Statements/002 diagrams.zip 8MB
  227. 04 - Relating Records with Joins/018 Exercise Solution.mp4 8MB
  228. 36 - Fast Parallel Testing/001 A Note on Testing.mp4 8MB
  229. 30 - Handling Concurrency and Reversibility with Transactions/005 Closing Aborted Transactions.mp4 7MB
  230. 05 - Aggregation of Records/015 A Quick Solution.mp4 7MB
  231. 20 - Implementing Database Design Patterns/004 Comments Creation.mp4 7MB
  232. 21 - Approaching and Writing Complex Queries/004 Highest User ID's Exercise.mp4 7MB
  233. 05 - Aggregation of Records/012 Having In Action.mp4 7MB
  234. 20 - Implementing Database Design Patterns/001 Back to Postgres.mp4 7MB
  235. 07 - Sorting Records/001 The Basics of Sorting.mp4 7MB
  236. 21 - Approaching and Writing Complex Queries/009 Solution for Likes Per User.mp4 7MB
  237. 23 - A Look at Indexes for Performance/007 Index Types.mp4 6MB
  238. 16 - How to Build a 'Like' System/004 Making a Reaction System Instead.mp4 6MB
  239. 09 - Assembling Queries with SubQueries/015 Exercise Solution.mp4 6MB
  240. 01 - Simple - But Powerful - SQL Statements/008 Retrieving Data with Select.mp4 6MB
  241. 02 - Filtering Records/009 Solving Calculations.mp4 6MB
  242. 33 - Accessing PostgreSQL From API's/007 Query and Close.mp4 6MB
  243. 11 - Utility Operators, Keywords, and Functions/002 And the Least Value in a List!.mp4 6MB
  244. 05 - Aggregation of Records/005 A Gotcha with Count.mp4 5MB
  245. 30 - Handling Concurrency and Reversibility with Transactions/002 Some Sample Data.mp4 5MB
  246. 04 - Relating Records with Joins/006 A Joinful Solution.mp4 5MB
  247. 02 - Filtering Records/007 A Where With Lists Solution.mp4 5MB
  248. 02 - Filtering Records/012 A Solution for Updating Rows.mp4 5MB
  249. 04 - Relating Records with Joins/005 Exercise Overview.mp4 5MB
  250. 21 - Approaching and Writing Complex Queries/006 Posts by a Particular User.mp4 5MB
  251. 08 - Unions and Intersections with Sets/006 Exercise Solution.mp4 5MB
  252. 02 - Filtering Records/008 Calculations in Where Clauses.mp4 5MB
  253. 21 - Approaching and Writing Complex Queries/005 Solution for User ID's.mp4 5MB
  254. 06 - Working with Large Datasets/006 Of Course You Remember!.mp4 4MB
  255. 09 - Assembling Queries with SubQueries/020 A Quick Solution.mp4 4MB
  256. 08 - Unions and Intersections with Sets/005 Union Exercise Overview.mp4 4MB
  257. 02 - Filtering Records/013 Solution for Deleting Rows.mp4 4MB
  258. 09 - Assembling Queries with SubQueries/005 Select Solution.mp4 4MB
  259. 05 - Aggregation of Records/010 Solution.mp4 4MB
  260. 21 - Approaching and Writing Complex Queries/008 Likes Per User.mp4 4MB
  261. 09 - Assembling Queries with SubQueries/025 Exercise Solution.mp4 4MB
  262. 09 - Assembling Queries with SubQueries/009 Exercise Overview.mp4 3MB
  263. 01 - Simple - But Powerful - SQL Statements/010 Calculating Phone Revenue.mp4 3MB
  264. 07 - Sorting Records/005 Exercise Solution.mp4 3MB
  265. 05 - Aggregation of Records/008 Grouping Solution.mp4 3MB
  266. 01 - Simple - But Powerful - SQL Statements/011 Exercise Solution.mp4 3MB
  267. 06 - Working with Large Datasets/003 Some Group By Practice.mp4 3MB
  268. 09 - Assembling Queries with SubQueries/004 Exercise Overview.mp4 3MB
  269. 09 - Assembling Queries with SubQueries/014 Exercise Overview.mp4 3MB
  270. 33 - Accessing PostgreSQL From API's/001 Section Goal.mp4 3MB
  271. 02 - Filtering Records/005 A Where Solution.mp4 3MB
  272. 04 - Relating Records with Joins/013 Exercise Overview.mp4 2MB
  273. 33 - Accessing PostgreSQL From API's/002 Initial Setup.mp4 2MB
  274. 09 - Assembling Queries with SubQueries/024 Exercise Overview.mp4 2MB
  275. 10 - Selecting Distinct Records/003 A Distinct Solution.mp4 2MB
  276. 05 - Aggregation of Records/009 Adding a Layer of Difficulty.mp4 2MB
  277. 02 - Filtering Records/004 A Where Exercise Overview.mp4 2MB
  278. 05 - Aggregation of Records/007 Exercise Overview.mp4 2MB
  279. 02 - Filtering Records/006 Where With Lists.mp4 2MB
  280. 10 - Selecting Distinct Records/002 Exercise Overview.mp4 1MB
  281. 09 - Assembling Queries with SubQueries/019 Exercise Overview.mp4 1MB
  282. 07 - Sorting Records/004 Exercise Overview.mp4 1MB
  283. 04 - Relating Records with Joins/010 009-joins-cheatsheet.pdf 191KB
  284. 36 - Fast Parallel Testing/016 037-access.zip 67KB
  285. 36 - Fast Parallel Testing/015 036-access.zip 66KB
  286. 36 - Fast Parallel Testing/014 035-access.zip 66KB
  287. 36 - Fast Parallel Testing/013 034-access.zip 66KB
  288. 36 - Fast Parallel Testing/007 028-access.zip 66KB
  289. 36 - Fast Parallel Testing/006 027-access.zip 65KB
  290. 36 - Fast Parallel Testing/005 026-access.zip 65KB
  291. 36 - Fast Parallel Testing/004 025-access.zip 65KB
  292. 36 - Fast Parallel Testing/003 024-access.zip 65KB
  293. 35 - Security Around PostgreSQL/007 021-access.zip 64KB
  294. 35 - Security Around PostgreSQL/005 019-access.zip 64KB
  295. 34 - Data Access Pattern - Repositories/002 010-access.zip 63KB
  296. 33 - Accessing PostgreSQL From API's/007 008-access.zip 62KB
  297. 33 - Accessing PostgreSQL From API's/004 005-access-social-repo.zip 61KB
  298. 22 - Understanding the Internals of PostgreSQL/005 Heap File Layout_en.srt 51KB
  299. 31 - Managing Database Design with Schema Migrations/001 A Story on Migrations_en.srt 28KB
  300. 09 - Assembling Queries with SubQueries/021 Probably Too Much About Correlated Subqueries_en.srt 26KB
  301. 32 - Schema vs Data Migrations/009 Transaction Locks_en.srt 22KB
  302. 20 - Implementing Database Design Patterns/002 Creating Tables with Checks_en.srt 21KB
  303. 25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost_en.srt 20KB
  304. 36 - Fast Parallel Testing/013 Programmatic Schema Creation_en.srt 19KB
  305. 06 - Working with Large Datasets/001 A New Dataset.html 18KB
  306. 27 - Recursive Common Table Expressions/002 Recursive CTE's Step by Step_en.srt 16KB
  307. 06 - Working with Large Datasets/002 001-sq-data.sql 16KB
  308. 13 - PostgreSQL Complex Datatypes/004 More on Number Data Types_en.srt 15KB
  309. 04 - Relating Records with Joins/010 Four Kinds of Joins_en.srt 15KB
  310. 30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions_en.srt 15KB
  311. 27 - Recursive Common Table Expressions/005 Walking Through Recursion_en.srt 15KB
  312. 32 - Schema vs Data Migrations/002 Dangers Around Data Migrations_en.srt 15KB
  313. 24 - Basic Query Tuning/003 Solving an Explain Mystery_en.srt 14KB
  314. 29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query_en.srt 14KB
  315. 09 - Assembling Queries with SubQueries/008 Example of a Subquery in a From_en.srt 14KB
  316. 09 - Assembling Queries with SubQueries/012 More Useful - Subqueries with Where_en.srt 14KB
  317. 09 - Assembling Queries with SubQueries/022 More on Correlated Subqueries_en.srt 14KB
  318. 03 - Working with Tables/006 Understanding Foreign Keys_en.srt 13KB
  319. 23 - A Look at Indexes for Performance/003 How an Index Works_en.srt 13KB
  320. 20 - Implementing Database Design Patterns/003 Posts Creation_en.srt 13KB
  321. 35 - Security Around PostgreSQL/002 Handling SQL Injection with Prepared Statements_en.srt 13KB
  322. 34 - Data Access Pattern - Repositories/002 Creating a Repository_en.srt 13KB
  323. 17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions_en.srt 13KB
  324. 25 - Advanced Query Tuning/006 Use My Index!_en.srt 13KB
  325. 27 - Recursive Common Table Expressions/004 Writing the Query_en.srt 12KB
  326. 09 - Assembling Queries with SubQueries/006 Subqueries in a From_en.srt 12KB
  327. 04 - Relating Records with Joins/016 Three Way Joins_en.srt 12KB
  328. 35 - Security Around PostgreSQL/003 Preventing SQL Injection_en.srt 12KB
  329. 18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System_en.srt 12KB
  330. 03 - Working with Tables/002 Approaching Database Design_en.srt 12KB
  331. 15 - Database Structure Design Patterns/003 A Config-based Schema Designer_en.srt 12KB
  332. 04 - Relating Records with Joins/003 Joining Data from Different Tables_en.srt 12KB
  333. 17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags_en.srt 12KB
  334. 14 - Database-Side Validation and Constraints/002 Creating and Viewing Tables in PGAdmin_en.srt 12KB
  335. 31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations_en.srt 12KB
  336. 36 - Fast Parallel Testing/002 Assertions Around User Count_en.srt 11KB
  337. 16 - How to Build a 'Like' System/006 Polymorphic Association Alternative Implementation_en.srt 11KB
  338. 25 - Advanced Query Tuning/003 A Touch More on Costs_en.srt 11KB
  339. 05 - Aggregation of Records/013 More on Having!_en.srt 11KB
  340. 15 - Database Structure Design Patterns/005 Rebuilding Some Schema_en.srt 11KB
  341. 35 - Security Around PostgreSQL/001 SQL Injection Exploits_en.srt 11KB
  342. 33 - Accessing PostgreSQL From API's/005 Understanding Connection Pools_en.srt 11KB
  343. 03 - Working with Tables/009 Running Queries on Associated Data_en.srt 11KB
  344. 04 - Relating Records with Joins/015 Where with Join_en.srt 11KB
  345. 33 - Accessing PostgreSQL From API's/006 Validating Connection Credentials_en.srt 11KB
  346. 20 - Implementing Database Design Patterns/005 Likes Creation_en.srt 11KB
  347. 31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations_en.srt 10KB
  348. 14 - Database-Side Validation and Constraints/003 Applying a Null Constraint_en.srt 10KB
  349. 17 - How to Build a 'Mention' System/001 Additional Features Around Posts_en.srt 10KB
  350. 28 - Simplifying Queries with Views/001 Most Popular Users_en.srt 10KB
  351. 01 - Simple - But Powerful - SQL Statements/012 String Operators and Functions_en.srt 10KB
  352. 07 - Sorting Records/003 Offset and Limit_en.srt 10KB
  353. 03 - Working with Tables/003 One-to-Many and Many-to-One Relationships_en.srt 10KB
  354. 09 - Assembling Queries with SubQueries/017 A New Where Operator_en.srt 10KB
  355. 04 - Relating Records with Joins/008 Missing Data in Joins_en.srt 10KB
  356. 25 - Advanced Query Tuning/002 Calculating Cost by Hand_en.srt 10KB
  357. 15 - Database Structure Design Patterns/002 Using a SQL Design Tool_en.srt 10KB
  358. 34 - Data Access Pattern - Repositories/005 Fixing Casing_en.srt 10KB
  359. 18 - How to Build a 'Hashtag' System/004 A Few More User Columns_en.srt 10KB
  360. 12 - Local PostgreSQL Installation/001 PostgreSQL Installation on macOS_en.srt 10KB
  361. 29 - Optimizing Queries with Materialized Views/005 Creating and Refreshing Materialized Views_en.srt 10KB
  362. 14 - Database-Side Validation and Constraints/010 So Where Are We Applying Validation_en.srt 10KB
  363. 08 - Unions and Intersections with Sets/004 Removing Commonalities with Except_en.srt 9KB
  364. 16 - How to Build a 'Like' System/005 Polymorphic Associations_en.srt 9KB
  365. 20 - Implementing Database Design Patterns/007 Creating Hashtags, Hashtag Posts, and Followers_en.srt 9KB
  366. 19 - How to Design a 'Follower' System/001 Designing a Follower System_en.srt 9KB
  367. 14 - Database-Side Validation and Constraints/006 Applying a Unique Constraint to One column_en.srt 9KB
  368. 04 - Relating Records with Joins/007 Alternate Forms of Syntax_en.srt 9KB
  369. 03 - Working with Tables/007 Auto-Generated ID's_en.srt 9KB
  370. 13 - PostgreSQL Complex Datatypes/008 Really Awesome Intervals_en.srt 9KB
  371. 09 - Assembling Queries with SubQueries/013 Data Structure with Where Subqueries_en.srt 9KB
  372. 08 - Unions and Intersections with Sets/001 Handling Sets with Union_en.srt 9KB
  373. 25 - Advanced Query Tuning/004 Startup vs Total Costs_en.srt 9KB
  374. 03 - Working with Tables/004 One-to-One and Many-to-Many Relationships_en.srt 9KB
  375. 36 - Fast Parallel Testing/010 Controlling Schema Access with Search Paths_en.srt 9KB
  376. 28 - Simplifying Queries with Views/003 Creating a View_en.srt 9KB
  377. 22 - Understanding the Internals of PostgreSQL/002 Where Does Postgres Store Data_en.srt 9KB
  378. 03 - Working with Tables/012 Foreign Key Constraints Around Insertion_en.srt 9KB
  379. 32 - Schema vs Data Migrations/003 Properly Running Data and Schema Migrations_en.srt 9KB
  380. 09 - Assembling Queries with SubQueries/001 What's a Subquery_en.srt 9KB
  381. 09 - Assembling Queries with SubQueries/003 Subqueries in a Select_en.srt 9KB
  382. 20 - Implementing Database Design Patterns/006 Photo Tags and Caption Tags_en.srt 9KB
  383. 36 - Fast Parallel Testing/016 Cleaning up Schemas and Roles_en.srt 8KB
  384. 13 - PostgreSQL Complex Datatypes/007 Times, Dates, and Timestamps_en.srt 8KB
  385. 23 - A Look at Indexes for Performance/005 Benchmarking Queries_en.srt 8KB
  386. 24 - Basic Query Tuning/002 Explain and Explain Analyze_en.srt 8KB
  387. 16 - How to Build a 'Like' System/003 Designing a Like System_en.srt 8KB
  388. 34 - Data Access Pattern - Repositories/006 Finding Particular Users_en.srt 8KB
  389. 36 - Fast Parallel Testing/007 Issues with Parallel Tests_en.srt 8KB
  390. 24 - Basic Query Tuning/001 The Query Processing Pipeline_en.srt 8KB
  391. 05 - Aggregation of Records/002 Picturing Group By_en.srt 8KB
  392. 01 - Simple - But Powerful - SQL Statements/004 Database Design_en.srt 8KB
  393. 36 - Fast Parallel Testing/009 Creating and Accessing Schemas_en.srt 8KB
  394. 36 - Fast Parallel Testing/003 Connecting to a DB For Tests_en.srt 8KB
  395. 36 - Fast Parallel Testing/015 Test Helpers_en.srt 8KB
  396. 36 - Fast Parallel Testing/006 Assumptions Around Content_en.srt 8KB
  397. 12 - Local PostgreSQL Installation/002 PGAdmin Setup on macOS_en.srt 8KB
  398. 14 - Database-Side Validation and Constraints/009 Checks Over Multiple Columns_en.srt 8KB
  399. 03 - Working with Tables/005 Primary Keys and Foreign Keys_en.srt 8KB
  400. 09 - Assembling Queries with SubQueries/018 Finally Some!_en.srt 8KB
  401. 13 - PostgreSQL Complex Datatypes/005 Reminder on Character Types_en.srt 8KB
  402. 23 - A Look at Indexes for Performance/006 Downsides of Indexes_en.srt 8KB
  403. 04 - Relating Records with Joins/017 A Bit of Practice_en.srt 8KB
  404. 03 - Working with Tables/013 Constraints Around Deletion_en.srt 8KB
  405. 05 - Aggregation of Records/011 Filtering Groups with Having_en.srt 8KB
  406. 01 - Simple - But Powerful - SQL Statements/005 Creating Tables_en.srt 8KB
  407. 04 - Relating Records with Joins/001 Adding Some Data.html 8KB
  408. 16 - How to Build a 'Like' System/001 Requirements of a Like System_en.srt 8KB
  409. 17 - How to Build a 'Mention' System/005 Update For Tags_en.srt 8KB
  410. 03 - Working with Tables/008 Creating Foreign Key Columns_en.srt 8KB
  411. 01 - Simple - But Powerful - SQL Statements/007 Inserting Data Into a Table_en.srt 8KB
  412. 04 - Relating Records with Joins/011 010-sql-cumulative.sql 8KB
  413. 27 - Recursive Common Table Expressions/003 Why Use Recursive CTE's_en.srt 8KB
  414. 02 - Filtering Records/003 Compound Where Clauses_en.srt 8KB
  415. 31 - Managing Database Design with Schema Migrations/004 A Few Notes on Migrations Libraries_en.srt 8KB
  416. 04 - Relating Records with Joins/008 007-joins-cumulative.sql 8KB
  417. 09 - Assembling Queries with SubQueries/002 Thinking About the Structure of Data_en.srt 8KB
  418. 31 - Managing Database Design with Schema Migrations/002 Migration Files_en.srt 7KB
  419. 36 - Fast Parallel Testing/005 Multi-DB Setup_en.srt 7KB
  420. 01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About_en.srt 7KB
  421. 01 - Simple - But Powerful - SQL Statements/009 Calculated Columns_en.srt 7KB
  422. 22 - Understanding the Internals of PostgreSQL/004 Block Data Layout_en.srt 7KB
  423. 36 - Fast Parallel Testing/012 Strategy for Isolation_en.srt 7KB
  424. 21 - Approaching and Writing Complex Queries/003 Restoring from Scratch_en.srt 7KB
  425. 29 - Optimizing Queries with Materialized Views/003 Reminder on Left Joins_en.srt 7KB
  426. 32 - Schema vs Data Migrations/004 Creating a Posts Table_en.srt 7KB
  427. 16 - How to Build a 'Like' System/008 So Which Approach_en.srt 7KB
  428. 03 - Working with Tables/015 Testing Deletion Constraints_en.srt 7KB
  429. 33 - Accessing PostgreSQL From API's/004 Building the Users Router_en.srt 7KB
  430. 05 - Aggregation of Records/004 Combining Group By and Aggregates_en.srt 7KB
  431. 09 - Assembling Queries with SubQueries/011 Subqueries in a Join Clause_en.srt 7KB
  432. 13 - PostgreSQL Complex Datatypes/002 Data Types_en.srt 7KB
  433. 35 - Security Around PostgreSQL/006 Handling Updates_en.srt 7KB
  434. 11 - Utility Operators, Keywords, and Functions/003 The Case Keyword_en.srt 7KB
  435. 34 - Data Access Pattern - Repositories/004 Casing Issues_en.srt 7KB
  436. 21 - Approaching and Writing Complex Queries/002 Adding Some Data_en.srt 7KB
  437. 04 - Relating Records with Joins/011 Each Join in Practice_en.srt 7KB
  438. 12 - Local PostgreSQL Installation/003 Postgres installation on Windows_en.srt 7KB
  439. 36 - Fast Parallel Testing/014 Escaping Identifiers_en.srt 7KB
  440. 32 - Schema vs Data Migrations/008 Writing Values to Both Columns_en.srt 7KB
  441. 35 - Security Around PostgreSQL/007 And, Finally, Delete_en.srt 7KB
  442. 14 - Database-Side Validation and Constraints/001 Thinking About Validation_en.srt 7KB
  443. 14 - Database-Side Validation and Constraints/004 Solving a Gotcha with Null Constraints_en.srt 7KB
  444. 36 - Fast Parallel Testing/008 Isolation with Schemas_en.srt 7KB
  445. 10 - Selecting Distinct Records/001 Selecting Distinct Values_en.srt 7KB
  446. 32 - Schema vs Data Migrations/012 Updating the App Server_en.srt 7KB
  447. 23 - A Look at Indexes for Performance/004 Creating an Index_en.srt 7KB
  448. 29 - Optimizing Queries with Materialized Views/002 Grouping by Week_en.srt 7KB
  449. 35 - Security Around PostgreSQL/005 Inserting Users_en.srt 7KB
  450. 36 - Fast Parallel Testing/011 Routing Schema Access_en.srt 6KB
  451. 13 - PostgreSQL Complex Datatypes/001 What'd We Just Do_en.srt 6KB
  452. 32 - Schema vs Data Migrations/010 Updating Values_en.srt 6KB
  453. 23 - A Look at Indexes for Performance/001 Full Table Scans_en.srt 6KB
  454. 04 - Relating Records with Joins/012 Does Order Matter_en.srt 6KB
  455. 30 - Handling Concurrency and Reversibility with Transactions/001 What are Transactions Used For_en.srt 6KB
  456. 14 - Database-Side Validation and Constraints/008 Adding a Validation Check_en.srt 6KB
  457. 09 - Assembling Queries with SubQueries/016 The Not In Operator with a List_en.srt 6KB
  458. 02 - Filtering Records/010 Updating Rows_en.srt 6KB
  459. 32 - Schema vs Data Migrations/007 Adding the Loc Column_en.srt 6KB
  460. 34 - Data Access Pattern - Repositories/003 Accessing the API_en.srt 6KB
  461. 26 - Simple Common Table Expressions/003 So What's a CTE_en.srt 6KB
  462. 28 - Simplifying Queries with Views/002 A Possible Solution for Merging Tables_en.srt 6KB
  463. 16 - How to Build a 'Like' System/007 The Simplest Alternative_en.srt 6KB
  464. 18 - How to Build a 'Hashtag' System/005 Why No Number of Followers or Posts_en.srt 6KB
  465. 02 - Filtering Records/001 Filtering Rows with Where_en.srt 6KB
  466. 22 - Understanding the Internals of PostgreSQL/003 Heaps, Blocks, and Tuples_en.srt 6KB
  467. 18 - How to Build a 'Hashtag' System/002 Tables for Hashtags_en.srt 6KB
  468. 26 - Simple Common Table Expressions/002 A Quick Solution_en.srt 6KB
  469. 08 - Unions and Intersections with Sets/002 A Few Notes on Union_en.srt 6KB
  470. 18 - How to Build a 'Hashtag' System/003 Including the Hashtag Table_en.srt 6KB
  471. 34 - Data Access Pattern - Repositories/001 The Repository Pattern_en.srt 6KB
  472. 23 - A Look at Indexes for Performance/008 Automatically Generated Indexes_en.srt 6KB
  473. 14 - Database-Side Validation and Constraints/007 Multi-Column Uniqueness_en.srt 6KB
  474. 01 - Simple - But Powerful - SQL Statements/006 Analyzing CREATE TABLE_en.srt 6KB
  475. 05 - Aggregation of Records/014 A Having Exercise Overview_en.srt 6KB
  476. 31 - Managing Database Design with Schema Migrations/009 Generating and Applying a Second Migration_en.srt 5KB
  477. 15 - Database Structure Design Patterns/001 Approaching More Complicated Designs_en.srt 5KB
  478. 04 - Relating Records with Joins/002 Queries with Joins and Aggregations_en.srt 5KB
  479. 02 - Filtering Records/011 Deleting Rows_en.srt 5KB
  480. 09 - Assembling Queries with SubQueries/023 A Select Without a From_en.srt 5KB
  481. 14 - Database-Side Validation and Constraints/005 Default Column Values_en.srt 5KB
  482. 36 - Fast Parallel Testing/017 Finally... Parallel Tests! (Final Lecture)_en.srt 5KB
  483. 11 - Utility Operators, Keywords, and Functions/001 The Greatest Value in a List_en.srt 5KB
  484. 36 - Fast Parallel Testing/001 A Note on Testing_en.srt 5KB
  485. 28 - Simplifying Queries with Views/004 When to Use a View_en.srt 5KB
  486. 08 - Unions and Intersections with Sets/003 Commonalities with Intersect_en.srt 5KB
  487. 16 - How to Build a 'Like' System/002 How Not to Design a Like System_en.srt 5KB
  488. 36 - Fast Parallel Testing/004 Disconnecting After Tests_en.srt 5KB
  489. 03 - Working with Tables/017 Adding Some Complexity_en.srt 5KB
  490. 05 - Aggregation of Records/006 Visualizing More Grouping_en.srt 5KB
  491. 32 - Schema vs Data Migrations/013 Dropping the Last Columns_en.srt 5KB
  492. 05 - Aggregation of Records/003 Aggregate Functions_en.srt 5KB
  493. 03 - Working with Tables/016 Setting Foreign Keys to Null on Delete_en.srt 5KB
  494. 31 - Managing Database Design with Schema Migrations/003 Issues Solved by Migrations_en.srt 5KB
  495. 31 - Managing Database Design with Schema Migrations/006 Project Creation_en.srt 5KB
  496. 13 - PostgreSQL Complex Datatypes/006 Boolean Data Types_en.srt 4KB
  497. 04 - Relating Records with Joins/018 Exercise Solution_en.srt 4KB
  498. 35 - Security Around PostgreSQL/004 Reminder on Post Requests_en.srt 4KB
  499. 09 - Assembling Queries with SubQueries/007 From Subqueries that Return a Value_en.srt 4KB
  500. 05 - Aggregation of Records/005 A Gotcha with Count_en.srt 4KB
  501. 15 - Database Structure Design Patterns/004 Here's the Plan_en.srt 4KB
  502. 07 - Sorting Records/002 Two Variations on Sorting_en.srt 4KB
  503. 05 - Aggregation of Records/012 Having In Action_en.srt 4KB
  504. 06 - Working with Large Datasets/002 Investigating This Dataset_en.srt 4KB
  505. 29 - Optimizing Queries with Materialized Views/001 Materialized Views_en.srt 4KB
  506. 23 - A Look at Indexes for Performance/002 What's an Index_en.srt 4KB
  507. 04 - Relating Records with Joins/009 Why Wasn't It Included_en.srt 4KB
  508. 02 - Filtering Records/002 More on the Where Keyword_en.srt 4KB
  509. 05 - Aggregation of Records/015 A Quick Solution_en.srt 4KB
  510. 06 - Working with Large Datasets/004 Group By Review Solution_en.srt 4KB
  511. 07 - Sorting Records/001 The Basics of Sorting_en.srt 4KB
  512. 06 - Working with Large Datasets/005 Remember Joins_en.srt 4KB
  513. 13 - PostgreSQL Complex Datatypes/003 Fast Rules on Numeric Data Types_en.srt 4KB
  514. 05 - Aggregation of Records/001 Aggregating and Grouping_en.srt 4KB
  515. 20 - Implementing Database Design Patterns/004 Comments Creation_en.srt 4KB
  516. 22 - Understanding the Internals of PostgreSQL/001 Thinking About Performance_en.srt 4KB
  517. 01 - Simple - But Powerful - SQL Statements/008 Retrieving Data with Select_en.srt 3KB
  518. 04 - Relating Records with Joins/004 Another Quick Join_en.srt 3KB
  519. 37 - Bonus!/001 Bonus!.html 3KB
  520. 30 - Handling Concurrency and Reversibility with Transactions/002 Some Sample Data_en.srt 3KB
  521. 03 - Working with Tables/010 Exercise Overview_en.srt 3KB
  522. 20 - Implementing Database Design Patterns/001 Back to Postgres_en.srt 3KB
  523. 33 - Accessing PostgreSQL From API's/007 Query and Close_en.srt 3KB
  524. 21 - Approaching and Writing Complex Queries/004 Highest User ID's Exercise_en.srt 3KB
  525. 11 - Utility Operators, Keywords, and Functions/002 And the Least Value in a List!_en.srt 3KB
  526. 03 - Working with Tables/011 Foreign Key Creation Solution_en.srt 3KB
  527. 09 - Assembling Queries with SubQueries/015 Exercise Solution_en.srt 3KB
  528. 02 - Filtering Records/008 Calculations in Where Clauses_en.srt 3KB
  529. 25 - Advanced Query Tuning/005 Costs Flow Up_en.srt 3KB
  530. 02 - Filtering Records/009 Solving Calculations_en.srt 3KB
  531. 26 - Simple Common Table Expressions/001 Common Table Expressions_en.srt 3KB
  532. 21 - Approaching and Writing Complex Queries/007 Solving for Posts by User_en.srt 3KB
  533. 30 - Handling Concurrency and Reversibility with Transactions/005 Closing Aborted Transactions_en.srt 3KB
  534. 20 - Implementing Database Design Patterns/007 007-db.sql 3KB
  535. 09 - Assembling Queries with SubQueries/010 Exercise Solution_en.srt 3KB
  536. 03 - Working with Tables/001 The Plan Moving Forward_en.srt 3KB
  537. 04 - Relating Records with Joins/006 A Joinful Solution_en.srt 3KB
  538. 17 - How to Build a 'Mention' System/002 Adding Captions and Locations_en.srt 3KB
  539. 16 - How to Build a 'Like' System/004 Making a Reaction System Instead_en.srt 3KB
  540. 23 - A Look at Indexes for Performance/007 Index Types_en.srt 3KB
  541. 02 - Filtering Records/007 A Where With Lists Solution_en.srt 2KB
  542. 21 - Approaching and Writing Complex Queries/009 Solution for Likes Per User_en.srt 2KB
  543. 33 - Accessing PostgreSQL From API's/002 Initial Setup_en.srt 2KB
  544. 05 - Aggregation of Records/010 Solution_en.srt 2KB
  545. 09 - Assembling Queries with SubQueries/020 A Quick Solution_en.srt 2KB
  546. 02 - Filtering Records/013 Solution for Deleting Rows_en.srt 2KB
  547. 06 - Working with Large Datasets/006 Of Course You Remember!_en.srt 2KB
  548. 05 - Aggregation of Records/008 Grouping Solution_en.srt 2KB
  549. 20 - Implementing Database Design Patterns/006 006-db.sql 2KB
  550. 08 - Unions and Intersections with Sets/006 Exercise Solution_en.srt 2KB
  551. 07 - Sorting Records/005 Exercise Solution_en.srt 2KB
  552. 08 - Unions and Intersections with Sets/005 Union Exercise Overview_en.srt 2KB
  553. 06 - Working with Large Datasets/003 Some Group By Practice_en.srt 2KB
  554. 02 - Filtering Records/012 A Solution for Updating Rows_en.srt 2KB
  555. 09 - Assembling Queries with SubQueries/005 Select Solution_en.srt 2KB
  556. 21 - Approaching and Writing Complex Queries/005 Solution for User ID's_en.srt 2KB
  557. 09 - Assembling Queries with SubQueries/025 Exercise Solution_en.srt 2KB
  558. 04 - Relating Records with Joins/005 Exercise Overview_en.srt 2KB
  559. 09 - Assembling Queries with SubQueries/009 Exercise Overview_en.srt 2KB
  560. 21 - Approaching and Writing Complex Queries/006 Posts by a Particular User_en.srt 2KB
  561. 09 - Assembling Queries with SubQueries/004 Exercise Overview_en.srt 2KB
  562. 01 - Simple - But Powerful - SQL Statements/011 Exercise Solution_en.srt 2KB
  563. 01 - Simple - But Powerful - SQL Statements/010 Calculating Phone Revenue_en.srt 2KB
  564. 33 - Accessing PostgreSQL From API's/001 Section Goal_en.srt 2KB
  565. 20 - Implementing Database Design Patterns/005 005-db.sql 2KB
  566. 04 - Relating Records with Joins/013 Exercise Overview_en.srt 2KB
  567. 09 - Assembling Queries with SubQueries/014 Exercise Overview_en.srt 2KB
  568. 02 - Filtering Records/005 A Where Solution_en.srt 2KB
  569. 32 - Schema vs Data Migrations/005 005-index.js 1KB
  570. 21 - Approaching and Writing Complex Queries/008 Likes Per User_en.srt 1KB
  571. 03 - Working with Tables/016 015-tables-cumulative.sql 1KB
  572. 09 - Assembling Queries with SubQueries/024 Exercise Overview_en.srt 1KB
  573. 01 - Simple - But Powerful - SQL Statements/002 Course Resources.html 1KB
  574. 05 - Aggregation of Records/007 Exercise Overview_en.srt 1KB
  575. 05 - Aggregation of Records/009 Adding a Layer of Difficulty_en.srt 1KB
  576. 20 - Implementing Database Design Patterns/004 004-db.sql 1KB
  577. 02 - Filtering Records/006 Where With Lists_en.srt 1KB
  578. 32 - Schema vs Data Migrations/006 Web Server Setup Instructions.html 1KB
  579. 10 - Selecting Distinct Records/003 A Distinct Solution_en.srt 1006B
  580. 03 - Working with Tables/015 014-tables-cumulative.sql 994B
  581. 02 - Filtering Records/004 A Where Exercise Overview_en.srt 946B
  582. 32 - Schema vs Data Migrations/011 Migrations Setup Instructions.html 925B
  583. 10 - Selecting Distinct Records/002 Exercise Overview_en.srt 879B
  584. 20 - Implementing Database Design Patterns/003 003-db.sql 791B
  585. 09 - Assembling Queries with SubQueries/019 Exercise Overview_en.srt 746B
  586. 03 - Working with Tables/014 Commands You’ll Need for the Next Video.html 691B
  587. 07 - Sorting Records/004 Exercise Overview_en.srt 688B
  588. 03 - Working with Tables/012 012-tables-cumulative.sql 600B
  589. 03 - Working with Tables/009 009-tables-cumulative.sql 536B
  590. 03 - Working with Tables/015 014-tables.sql 469B
  591. 15 - Database Structure Design Patterns/005 005-design.dbml 455B
  592. 01 - Simple - But Powerful - SQL Statements/012 012-sql.sql 404B
  593. 01 - Simple - But Powerful - SQL Statements/007 005-sql-cumulative.sql 384B
  594. 20 - Implementing Database Design Patterns/002 002-db.sql 375B
  595. 32 - Schema vs Data Migrations/011 01-lng-lat-to-loc.js 364B
  596. 03 - Working with Tables/008 008-tables-cumulative.sql 348B
  597. 03 - Working with Tables/016 015-tables.sql 340B
  598. 03 - Working with Tables/009 009-tables.sql 326B
  599. 01 - Simple - But Powerful - SQL Statements/001 Join Our Community!.html 318B
  600. 01 - Simple - But Powerful - SQL Statements/007 005-sql.sql 278B
  601. 31 - Managing Database Design with Schema Migrations/005 A Note About Node Installation.html 264B
  602. 21 - Approaching and Writing Complex Queries/001 Quick Note About Adding Some Data.html 251B
  603. 03 - Working with Tables/012 012-tables.sql 199B
  604. 03 - Working with Tables/008 008-tables.sql 197B
  605. 03 - Working with Tables/007 007-tables.sql 194B
  606. 06 - Working with Large Datasets/How you can help GetFreeCourses.Co.txt 182B
  607. 19 - How to Design a 'Follower' System/How you can help GetFreeCourses.Co.txt 182B
  608. 29 - Optimizing Queries with Materialized Views/How you can help GetFreeCourses.Co.txt 182B
  609. 36 - Fast Parallel Testing/How you can help GetFreeCourses.Co.txt 182B
  610. How you can help GetFreeCourses.Co.txt 182B
  611. 03 - Working with Tables/007 007-tables-cumulative.sql 172B
  612. 06 - Working with Large Datasets/GetFreeCourses.Co.url 116B
  613. 19 - How to Design a 'Follower' System/GetFreeCourses.Co.url 116B
  614. 29 - Optimizing Queries with Materialized Views/GetFreeCourses.Co.url 116B
  615. 36 - Fast Parallel Testing/GetFreeCourses.Co.url 116B
  616. Download Paid Udemy Courses For Free.url 116B
  617. GetFreeCourses.Co.url 116B
  618. 01 - Simple - But Powerful - SQL Statements/005 003-sql.sql 104B
  619. 02 - Filtering Records/001 013-sql.sql 48B