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

磁力链接/BT种子名称

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

磁力链接/BT种子简介

种子哈希：7137537c2364bb83e449e6813b2f00bb4fea13d0
文件大小： 7.6G
已经下载：870次
下载速度：极快
收录时间：2021-03-07
最近下载：2025-09-08

移花宫入口

移花宫.com邀月.com怜星.com花无缺.comyhgbt.icuyhgbt.top

磁力链接下载

magnet:?xt=urn:btih:7137537C2364BB83E449E6813B2F00BB4FEA13D0
推荐使用PIKPAK网盘下载资源，10TB超大空间，不限制资源，无限次数离线下载，视频在线观看

下载BT种子文件

磁力链接 迅雷下载 PIKPAK在线播放 世界之窗 91视频 含羞草 欲漫涩 逼哩逼哩 成人快手 51品茶 抖阴破解版 极乐禁地 91短视频 暗网Xvideo TikTok成人版 PornHub 听泉鉴鲍 少女日记 草榴社区 哆哔涩漫 呦乐园 萝莉岛 悠悠禁区 悠悠禁区 拔萝卜 疯马秀

最近搜索

文件列表

  • 22. Understanding the Internals of PostgreSQL/6. Heap File Layout.mp4 362.0 MB
  • 23. A Look at Indexes for Performance/10. Behind the Scenes of Indexes.mp4 261.3 MB
  • 9. Assembling Queries with SubQueries/27. Probably Too Much About Correlated Subqueries.mp4 126.9 MB
  • 31. Managing Database Design with Schema Migrations/1. A Story on Migrations.mp4 117.7 MB
  • 4. Relating Records with Joins/11. Four Kinds of Joins.mp4 90.6 MB
  • 25. Advanced Query Tuning/1. Developing an Intuitive Understanding of Cost.mp4 88.5 MB
  • 27. Recursive Common Table Expressions/5. Walking Through Recursion.mp4 80.8 MB
  • 36. Fast Parallel Testing/13. Programmatic Schema Creation.mp4 79.9 MB
  • 32. Schema vs Data Migrations/5. A Small Web Server.mp4 75.2 MB
  • 32. Schema vs Data Migrations/9. Transaction Locks.mp4 74.6 MB
  • 27. Recursive Common Table Expressions/2. Recursive CTE's Step by Step.mp4 73.5 MB
  • 20. Implementing Database Design Patterns/2. Creating Tables with Checks.mp4 70.8 MB
  • 18. How to Build a 'Hashtag' System/1. Designing a Hashtag System.mp4 70.8 MB
  • 24. Basic Query Tuning/4. Solving an Explain Mystery.mp4 68.6 MB
  • 17. How to Build a 'Mention' System/3. Photo Mentions vs Caption Mentions.mp4 66.3 MB
  • 29. Optimizing Queries with Materialized Views/4. Writing a Slow Query.mp4 65.6 MB
  • 25. Advanced Query Tuning/3. A Touch More on Costs.mp4 61.0 MB
  • 32. Schema vs Data Migrations/2. Dangers Around Data Migrations.mp4 60.9 MB
  • 23. A Look at Indexes for Performance/3. How an Index Works.mp4 59.9 MB
  • 17. How to Build a 'Mention' System/1. Additional Features Around Posts.mp4 59.1 MB
  • 13. PostgreSQL Complex Datatypes/4. More on Number Data Types.mp4 58.3 MB
  • 30. Handling Concurrency and Reversibility with Transactions/3. Opening and Closing Transactions.mp4 57.3 MB
  • 4. Relating Records with Joins/19. Three Way Joins.mp4 57.0 MB
  • 9. Assembling Queries with SubQueries/28. More on Correlated Subqueries.mp4 56.8 MB
  • 3. Working with Tables/9. Understanding Foreign Keys.mp4 53.0 MB
  • 3. Working with Tables/2. Approaching Database Design.mp4 52.9 MB
  • 4. Relating Records with Joins/3. Joining Data from Different Tables.mp4 50.5 MB
  • 29. Optimizing Queries with Materialized Views/5. Creating and Refreshing Materialized Views.mp4 50.1 MB
  • 17. How to Build a 'Mention' System/4. Considerations on Photo Tags vs Caption Tags.mp4 49.8 MB
  • 9. Assembling Queries with SubQueries/8. Subqueries in a From.mp4 49.2 MB
  • 20. Implementing Database Design Patterns/3. Posts Creation.mp4 47.6 MB
  • 27. Recursive Common Table Expressions/4. Writing the Query.mp4 47.4 MB
  • 36. Fast Parallel Testing/16. Cleaning up Schemas and Roles.mp4 47.2 MB
  • 9. Assembling Queries with SubQueries/10. Example of a Subquery in a From.mp4 46.7 MB
  • 18. How to Build a 'Hashtag' System/4. A Few More User Columns.mp4 46.7 MB
  • 9. Assembling Queries with SubQueries/21. A New Where Operator.mp4 45.6 MB
  • 31. Managing Database Design with Schema Migrations/8. Applying and Reverting Migrations.mp4 45.1 MB
  • 9. Assembling Queries with SubQueries/15. More Useful - Subqueries with Where.mp4 45.1 MB
  • 25. Advanced Query Tuning/7. Use My Index!.mp4 44.5 MB
  • 16. How to Build a 'Like' System/7. Polymorphic Association Alternative Implementation.mp4 44.5 MB
  • 25. Advanced Query Tuning/2. Calculating Cost by Hand.mp4 43.9 MB
  • 35. Security Around PostgreSQL/2. Handling SQL Injection with Prepared Statements.mp4 43.6 MB
  • 35. Security Around PostgreSQL/3. Preventing SQL Injection.mp4 42.0 MB
  • 34. Data Access Pattern - Repositories/5. Fixing Casing.mp4 41.3 MB
  • 22. Understanding the Internals of PostgreSQL/2. Where Does Postgres Store Data.mp4 40.8 MB
  • 31. Managing Database Design with Schema Migrations/7. Generating and Writing Migrations.mp4 40.5 MB
  • 3. Working with Tables/4. One-to-Many and Many-to-One Relationships.mp4 40.4 MB
  • 15. Database Structure Design Patterns/2. Using a SQL Design Tool.mp4 40.0 MB
  • 34. Data Access Pattern - Repositories/2. Creating a Repository.mp4 40.0 MB
  • 4. Relating Records with Joins/18. Where with Join.mp4 39.6 MB
  • 4. Relating Records with Joins/13. Does Order Matter.mp4 39.1 MB
  • 4. Relating Records with Joins/9. Missing Data in Joins.mp4 38.5 MB
  • 5. Aggregation of Records/16. More on Having!.mp4 38.3 MB
  • 28. Simplifying Queries with Views/3. Creating a View.mp4 38.2 MB
  • 14. Database-Side Validation and Constraints/2. Creating and Viewing Tables in PGAdmin.mp4 38.0 MB
  • 16. How to Build a 'Like' System/6. Polymorphic Associations.mp4 38.0 MB
  • 25. Advanced Query Tuning/5. Startup vs Total Costs.mp4 37.5 MB
  • 3. Working with Tables/6. One-to-One and Many-to-Many Relationships.mp4 37.4 MB
  • 15. Database Structure Design Patterns/3. A Config-based Schema Designer.mp4 37.4 MB
  • 36. Fast Parallel Testing/15. Test Helpers.mp4 37.3 MB
  • 9. Assembling Queries with SubQueries/1. What's a Subquery.mp4 37.2 MB
  • 1. Simple - But Powerful - SQL Statements/3. Database Design.mp4 37.1 MB
  • 9. Assembling Queries with SubQueries/16. Data Structure with Where Subqueries.mp4 37.1 MB
  • 20. Implementing Database Design Patterns/5. Likes Creation.mp4 37.1 MB
  • 36. Fast Parallel Testing/2. Assertions Around User Count.mp4 37.0 MB
  • 9. Assembling Queries with SubQueries/22. Finally Some!.mp4 37.0 MB
  • 3. Working with Tables/8. Primary Keys and Foreign Keys.mp4 36.0 MB
  • 4. Relating Records with Joins/12. Each Join in Practice.mp4 35.9 MB
  • 36. Fast Parallel Testing/3. Connecting to a DB For Tests.mp4 35.7 MB
  • 36. Fast Parallel Testing/10. Controlling Schema Access with Search Paths.mp4 35.7 MB
  • 19. How to Design a 'Follower' System/1. Designing a Follower System.mp4 35.2 MB
  • 24. Basic Query Tuning/1. The Query Processing Pipeline.mp4 34.9 MB
  • 35. Security Around PostgreSQL/1. SQL Injection Exploits.mp4 34.8 MB
  • 5. Aggregation of Records/2. Picturing Group By.mp4 34.8 MB
  • 33. Accessing PostgreSQL From API's/6. Validating Connection Credentials.mp4 34.0 MB
  • 31. Managing Database Design with Schema Migrations/2. Migration Files.mp4 34.0 MB
  • 14. Database-Side Validation and Constraints/3. Applying a Null Constraint.mp4 33.7 MB
  • 3. Working with Tables/13. Running Queries on Associated Data.mp4 33.2 MB
  • 3. Working with Tables/11. Auto-Generated ID's.mp4 33.1 MB
  • 15. Database Structure Design Patterns/5. Rebuilding Some Schema.mp4 32.8 MB
  • 14. Database-Side Validation and Constraints/7. Applying a Unique Constraint to One column.mp4 32.6 MB
  • 14. Database-Side Validation and Constraints/13. So Where Are We Applying Validation.mp4 32.5 MB
  • 24. Basic Query Tuning/2. Explain and Explain Analyze.mp4 32.0 MB
  • 17. How to Build a 'Mention' System/5. Update For Tags.mp4 31.8 MB
  • 16. How to Build a 'Like' System/3. Designing a Like System.mp4 31.8 MB
  • 28. Simplifying Queries with Views/2. A Possible Solution for Merging Tables.mp4 31.8 MB
  • 16. How to Build a 'Like' System/1. Requirements of a Like System.mp4 31.5 MB
  • 28. Simplifying Queries with Views/1. Most Popular Users.mp4 31.5 MB
  • 36. Fast Parallel Testing/9. Creating and Accessing Schemas.mp4 31.5 MB
  • 35. Security Around PostgreSQL/6. Handling Updates.mp4 31.4 MB
  • 36. Fast Parallel Testing/14. Escaping Identifiers.mp4 31.3 MB
  • 33. Accessing PostgreSQL From API's/3. One Fast Migration.mp4 31.1 MB
  • 8. Unions and Intersections with Sets/4. Removing Commonalities with Except.mp4 31.1 MB
  • 36. Fast Parallel Testing/7. Issues with Parallel Tests.mp4 31.0 MB
  • 3. Working with Tables/18. Constraints Around Deletion.mp4 30.8 MB
  • 20. Implementing Database Design Patterns/7. Creating Hashtags, Hashtag Posts, and Followers.mp4 30.8 MB
  • 27. Recursive Common Table Expressions/3. Why Use Recursive CTE's.mp4 30.5 MB
  • 31. Managing Database Design with Schema Migrations/4. A Few Notes on Migrations Libraries.mp4 30.3 MB
  • 14. Database-Side Validation and Constraints/1. Thinking About Validation.mp4 30.1 MB
  • 20. Implementing Database Design Patterns/6. Photo Tags and Caption Tags.mp4 29.8 MB
  • 34. Data Access Pattern - Repositories/6. Finding Particular Users.mp4 29.8 MB
  • 36. Fast Parallel Testing/5. Multi-DB Setup.mp4 29.6 MB
  • 9. Assembling Queries with SubQueries/4. Subqueries in a Select.mp4 29.5 MB
  • 4. Relating Records with Joins/8. Alternate Forms of Syntax.mp4 29.4 MB
  • 23. A Look at Indexes for Performance/5. Benchmarking Queries.mp4 29.1 MB
  • 30. Handling Concurrency and Reversibility with Transactions/4. Transaction Cleanup on Crash.mp4 28.9 MB
  • 7. Sorting Records/3. Offset and Limit.mp4 28.9 MB
  • 3. Working with Tables/17. Foreign Key Constraints Around Insertion.mp4 28.8 MB
  • 26. Simple Common Table Expressions/3. So What's a CTE.mp4 28.6 MB
  • 36. Fast Parallel Testing/6. Assumptions Around Content.mp4 28.6 MB
  • 32. Schema vs Data Migrations/3. Properly Running Data and Schema Migrations.mp4 28.5 MB
  • 13. PostgreSQL Complex Datatypes/7. Times, Dates, and Timestamps.mp4 28.4 MB
  • 8. Unions and Intersections with Sets/1. Handling Sets with Union.mp4 28.3 MB
  • 12. Local PostgreSQL Installation/1. PostgreSQL Installation on macOS.mp4 28.2 MB
  • 23. A Look at Indexes for Performance/1. Full Table Scans.mp4 28.1 MB
  • 12. Local PostgreSQL Installation/3. Postgres installation on Windows.mp4 27.9 MB
  • 36. Fast Parallel Testing/17. Finally... Parallel Tests!.mp4 27.8 MB
  • 36. Fast Parallel Testing/11. Routing Schema Access.mp4 27.6 MB
  • 4. Relating Records with Joins/20. A Bit of Practice.mp4 27.6 MB
  • 28. Simplifying Queries with Views/4. When to Use a View.mp4 27.4 MB
  • 9. Assembling Queries with SubQueries/2. Thinking About the Structure of Data.mp4 27.3 MB
  • 5. Aggregation of Records/14. Filtering Groups with Having.mp4 27.3 MB
  • 35. Security Around PostgreSQL/7. And, Finally, Delete.mp4 27.2 MB
  • 3. Working with Tables/20. Testing Deletion Constraints.mp4 26.8 MB
  • 29. Optimizing Queries with Materialized Views/2. Grouping by Week.mp4 26.5 MB
  • 33. Accessing PostgreSQL From API's/4. Building the Users Router.mp4 26.5 MB
  • 36. Fast Parallel Testing/12. Strategy for Isolation.mp4 26.4 MB
  • 9. Assembling Queries with SubQueries/20. The Not In Operator with a List.mp4 26.3 MB
  • 13. PostgreSQL Complex Datatypes/5. Reminder on Character Types.mp4 26.1 MB
  • 35. Security Around PostgreSQL/5. Inserting Users.mp4 26.0 MB
  • 16. How to Build a 'Like' System/10. So Which Approach.mp4 26.0 MB
  • 23. A Look at Indexes for Performance/6. Downsides of Indexes.mp4 26.0 MB
  • 29. Optimizing Queries with Materialized Views/3. Reminder on Left Joins.mp4 25.7 MB
  • 13. PostgreSQL Complex Datatypes/2. Data Types.mp4 25.7 MB
  • 9. Assembling Queries with SubQueries/14. Subqueries in a Join Clause.mp4 25.6 MB
  • 1. Simple - But Powerful - SQL Statements/14. String Operators and Functions.mp4 25.6 MB
  • 12. Local PostgreSQL Installation/2. PGAdmin Setup on macOS.mp4 25.4 MB
  • 33. Accessing PostgreSQL From API's/5. Understanding Connection Pools.mp4 25.4 MB
  • 32. Schema vs Data Migrations/4. Creating a Posts Table.mp4 25.3 MB
  • 2. Filtering Records/3. Compound Where Clauses.mp4 25.2 MB
  • 13. PostgreSQL Complex Datatypes/8. Really Awesome Intervals.mp4 25.1 MB
  • 21. Approaching and Writing Complex Queries/3. Restoring from Scratch.mp4 24.9 MB
  • 14. Database-Side Validation and Constraints/11. Checks Over Multiple Columns.mp4 24.8 MB
  • 14. Database-Side Validation and Constraints/10. Adding a Validation Check.mp4 24.7 MB
  • 21. Approaching and Writing Complex Queries/1.1 ig.sql 24.7 MB
  • 3. Working with Tables/12. Creating Foreign Key Columns.mp4 24.4 MB
  • 34. Data Access Pattern - Repositories/4. Casing Issues.mp4 24.3 MB
  • 13. PostgreSQL Complex Datatypes/1. What'd We Just Do.mp4 24.0 MB
  • 32. Schema vs Data Migrations/12. Updating the App Server.mp4 23.6 MB
  • 5. Aggregation of Records/5. Combining Group By and Aggregates.mp4 23.3 MB
  • 18. How to Build a 'Hashtag' System/5. Why No Number of Followers or Posts.mp4 23.2 MB
  • 36. Fast Parallel Testing/8. Isolation with Schemas.mp4 23.1 MB
  • 1. Simple - But Powerful - SQL Statements/2. What is PostgreSQL All About.mp4 22.8 MB
  • 4. Relating Records with Joins/2. Queries with Joins and Aggregations.mp4 22.8 MB
  • 16. How to Build a 'Like' System/8. The Simplest Alternative.mp4 22.7 MB
  • 32. Schema vs Data Migrations/8. Writing Values to Both Columns.mp4 22.6 MB
  • 21. Approaching and Writing Complex Queries/2. Adding Some Data.mp4 22.5 MB
  • 32. Schema vs Data Migrations/1. Schema vs Data Migrations.mp4 22.4 MB
  • 14. Database-Side Validation and Constraints/8. Multi-Column Uniqueness.mp4 22.3 MB
  • 23. A Look at Indexes for Performance/8. Automatically Generated Indexes.mp4 22.2 MB
  • 4. Relating Records with Joins/17. Two Possible Solutions.mp4 22.2 MB
  • 34. Data Access Pattern - Repositories/1. The Repository Pattern.mp4 22.0 MB
  • 8. Unions and Intersections with Sets/2. A Few Notes on Union.mp4 22.0 MB
  • 22. Understanding the Internals of PostgreSQL/5. Block Data Layout.mp4 22.0 MB
  • 2. Filtering Records/13. Updating Rows.mp4 21.9 MB
  • 4. Relating Records with Joins/10. Why Wasn't It Included.mp4 21.8 MB
  • 26. Simple Common Table Expressions/2. A Quick Solution.mp4 21.7 MB
  • 14. Database-Side Validation and Constraints/4. Solving a Gotcha with Null Constraints.mp4 21.5 MB
  • 18. How to Build a 'Hashtag' System/3. Including the Hashtag Table.mp4 21.3 MB
  • 31. Managing Database Design with Schema Migrations/9. Generating and Applying a Second Migration.mp4 21.0 MB
  • 1. Simple - But Powerful - SQL Statements/7. Inserting Data Into a Table.mp4 20.7 MB
  • 16. How to Build a 'Like' System/2. How Not to Design a Like System.mp4 20.6 MB
  • 32. Schema vs Data Migrations/10. Updating Values.mp4 20.5 MB
  • 5. Aggregation of Records/17. A Having Exercise Overview.mp4 20.4 MB
  • 23. A Look at Indexes for Performance/4. Creating an Index.mp4 20.3 MB
  • 1. Simple - But Powerful - SQL Statements/6. Analyzing CREATE TABLE.mp4 20.1 MB
  • 11. Utility Operators, Keywords, and Functions/3. The Case Keyword.mp4 20.0 MB
  • 30. Handling Concurrency and Reversibility with Transactions/1. What are Transactions Used For.mp4 19.7 MB
  • 14. Database-Side Validation and Constraints/6. Default Column Values.mp4 19.6 MB
  • 1. Simple - But Powerful - SQL Statements/10. Calculated Columns.mp4 19.6 MB
  • 1. Simple - But Powerful - SQL Statements/5. Creating Tables.mp4 19.5 MB
  • 32. Schema vs Data Migrations/7. Adding the Loc Column.mp4 19.0 MB
  • 2. Filtering Records/14. Deleting Rows.mp4 18.9 MB
  • 10. Selecting Distinct Records/1. Selecting Distinct Values.mp4 18.8 MB
  • 22. Understanding the Internals of PostgreSQL/3. Heaps, Blocks, and Tuples.mp4 18.8 MB
  • 34. Data Access Pattern - Repositories/3. Accessing the API.mp4 18.0 MB
  • 8. Unions and Intersections with Sets/3. Commonalities with Intersect.mp4 17.9 MB
  • 27. Recursive Common Table Expressions/1. Recursive CTE's.mp4 17.8 MB
  • 36. Fast Parallel Testing/4. Disconnecting After Tests.mp4 17.8 MB
  • 2. Filtering Records/1. Filtering Rows with Where.mp4 17.7 MB
  • 18. How to Build a 'Hashtag' System/2. Tables for Hashtags.mp4 17.6 MB
  • 28. Simplifying Queries with Views/5. Deleting and Changing Views.mp4 17.3 MB
  • 35. Security Around PostgreSQL/4. Reminder on Post Requests.mp4 17.1 MB
  • 15. Database Structure Design Patterns/1. Approaching More Complicated Designs.mp4 16.4 MB
  • 5. Aggregation of Records/4. Aggregate Functions.mp4 15.9 MB
  • 5. Aggregation of Records/7. Visualizing More Grouping.mp4 15.9 MB
  • 3. Working with Tables/21. Setting Foreign Keys to Null on Delete.mp4 15.4 MB
  • 11. Utility Operators, Keywords, and Functions/1. The Greatest Value in a List.mp4 15.3 MB
  • 6. Working with Large Datasets/6. Remember Joins.mp4 15.2 MB
  • 15. Database Structure Design Patterns/4. Here's the Plan.mp4 15.2 MB
  • 32. Schema vs Data Migrations/13. Dropping the Last Columns.mp4 15.2 MB
  • 4. Relating Records with Joins/4. Another Quick Join.mp4 14.9 MB
  • 7. Sorting Records/2. Two Variations on Sorting.mp4 14.9 MB
  • 31. Managing Database Design with Schema Migrations/6. Project Creation.mp4 14.5 MB
  • 21. Approaching and Writing Complex Queries/7. Solving for Posts by User.mp4 14.4 MB
  • 25. Advanced Query Tuning/6. Costs Flow Up.mp4 14.1 MB
  • 31. Managing Database Design with Schema Migrations/3. Issues Solved by Migrations.mp4 14.1 MB
  • 9. Assembling Queries with SubQueries/9. From Subqueries that Return a Value.mp4 14.0 MB
  • 3. Working with Tables/23. Adding Some Complexity.mp4 13.9 MB
  • 13. PostgreSQL Complex Datatypes/6. Boolean Data Types.mp4 13.8 MB
  • 2. Filtering Records/2. More on the Where Keyword.mp4 13.7 MB
  • 23. A Look at Indexes for Performance/2. What's an Index.mp4 13.6 MB
  • 13. PostgreSQL Complex Datatypes/3. Fast Rules on Numeric Data Types.mp4 13.5 MB
  • 6. Working with Large Datasets/5. Group By Review Solution.mp4 13.2 MB
  • 9. Assembling Queries with SubQueries/29. A Select Without a From.mp4 13.1 MB
  • 4. Relating Records with Joins/22. Exercise Solution.mp4 12.5 MB
  • 26. Simple Common Table Expressions/1. Common Table Expressions.mp4 12.5 MB
  • 17. How to Build a 'Mention' System/2. Adding Captions and Locations.mp4 12.4 MB
  • 5. Aggregation of Records/15. Having In Action.mp4 12.3 MB
  • 3. Working with Tables/14. Exercise Overview.mp4 12.2 MB
  • 3. Working with Tables/16. Foreign Key Creation Solution.mp4 12.1 MB
  • 6. Working with Large Datasets/2. Investigating This Dataset.mp4 11.6 MB
  • 29. Optimizing Queries with Materialized Views/1. Materialized Views.mp4 11.6 MB
  • 7. Sorting Records/1. The Basics of Sorting.mp4 11.1 MB
  • 5. Aggregation of Records/19. A Quick Solution.mp4 11.0 MB
  • 36. Fast Parallel Testing/1. A Note on Testing.mp4 11.0 MB
  • 20. Implementing Database Design Patterns/4. Comments Creation.mp4 10.9 MB
  • 20. Implementing Database Design Patterns/1. Back to Postgres.mp4 10.6 MB
  • 30. Handling Concurrency and Reversibility with Transactions/5. Closing Aborted Transactions.mp4 10.4 MB
  • 5. Aggregation of Records/1. Aggregating and Grouping.mp4 10.4 MB
  • 23. A Look at Indexes for Performance/7. Index Types.mp4 10.3 MB
  • 22. Understanding the Internals of PostgreSQL/1. Thinking About Performance.mp4 9.9 MB
  • 1. Simple - But Powerful - SQL Statements/8. Retrieving Data with Select.mp4 9.7 MB
  • 9. Assembling Queries with SubQueries/19. Exercise Solution.mp4 9.6 MB
  • 16. How to Build a 'Like' System/5. Making a Reaction System Instead.mp4 9.4 MB
  • 33. Accessing PostgreSQL From API's/7. Query and Close.mp4 9.3 MB
  • 3. Working with Tables/1. The Plan Moving Forward.mp4 9.2 MB
  • 4. Relating Records with Joins/7. A Joinful Solution.mp4 9.1 MB
  • 11. Utility Operators, Keywords, and Functions/2. And the Least Value in a List!.mp4 9.1 MB
  • 2. Filtering Records/12. Solving Calculations.mp4 8.7 MB
  • 21. Approaching and Writing Complex Queries/9. Solution for Likes Per User.mp4 8.6 MB
  • 5. Aggregation of Records/6. A Gotcha with Count.mp4 8.5 MB
  • 21. Approaching and Writing Complex Queries/4. Highest User ID's Exercise.mp4 8.2 MB
  • 4. Relating Records with Joins/5. Exercise Overview.mp4 8.2 MB
  • 30. Handling Concurrency and Reversibility with Transactions/2. Some Sample Data.mp4 8.0 MB
  • 9. Assembling Queries with SubQueries/13. Exercise Solution.mp4 7.9 MB
  • 2. Filtering Records/9. A Where With Lists Solution.mp4 7.7 MB
  • 2. Filtering Records/16. A Solution for Updating Rows.mp4 7.6 MB
  • 8. Unions and Intersections with Sets/7. Exercise Solution.mp4 7.3 MB
  • 6. Working with Large Datasets/8. Of Course You Remember!.mp4 7.3 MB
  • 21. Approaching and Writing Complex Queries/6. Posts by a Particular User.mp4 7.2 MB
  • 2. Filtering Records/10. Calculations in Where Clauses.mp4 6.7 MB
  • 21. Approaching and Writing Complex Queries/5. Solution for User ID's.mp4 6.7 MB
  • 8. Unions and Intersections with Sets/5. Union Exercise Overview.mp4 6.4 MB
  • 9. Assembling Queries with SubQueries/26. A Quick Solution.mp4 6.3 MB
  • 9. Assembling Queries with SubQueries/7. Select Solution.mp4 5.9 MB
  • 1. Simple - But Powerful - SQL Statements/11. Calculating Phone Revenue.mp4 5.8 MB
  • 2. Filtering Records/18. Solution for Deleting Rows.mp4 5.7 MB
  • 9. Assembling Queries with SubQueries/5. Exercise Overview.mp4 5.4 MB
  • 9. Assembling Queries with SubQueries/32. Exercise Solution.mp4 5.3 MB
  • 9. Assembling Queries with SubQueries/11. Exercise Overview.mp4 5.3 MB
  • 7. Sorting Records/6. Exercise Solution.mp4 5.3 MB
  • 5. Aggregation of Records/13. Solution.mp4 5.3 MB
  • 21. Approaching and Writing Complex Queries/8. Likes Per User.mp4 5.0 MB
  • 5. Aggregation of Records/10. Grouping Solution.mp4 4.6 MB
  • 9. Assembling Queries with SubQueries/17. Exercise Overview.mp4 4.5 MB
  • 6. Working with Large Datasets/3. Some Group By Practice.mp4 4.5 MB
  • 1. Simple - But Powerful - SQL Statements/13. Exercise Solution.mp4 4.4 MB
  • 2. Filtering Records/6. A Where Solution.mp4 3.9 MB
  • 33. Accessing PostgreSQL From API's/2. Initial Setup.mp4 3.6 MB
  • 4. Relating Records with Joins/15. Exercise Overview.mp4 3.6 MB
  • 33. Accessing PostgreSQL From API's/1. Section Goal.mp4 3.5 MB
  • 9. Assembling Queries with SubQueries/30. Exercise Overview.mp4 3.1 MB
  • 5. Aggregation of Records/11. Adding a Layer of Difficulty.mp4 2.8 MB
  • 10. Selecting Distinct Records/4. A Distinct Solution.mp4 2.8 MB
  • 5. Aggregation of Records/8. Exercise Overview.mp4 2.8 MB
  • 2. Filtering Records/4. A Where Exercise Overview.mp4 2.6 MB
  • 2. Filtering Records/7. Where With Lists.mp4 2.2 MB
  • 10. Selecting Distinct Records/2. Exercise Overview.mp4 2.1 MB
  • 9. Assembling Queries with SubQueries/24. Exercise Overview.mp4 1.8 MB
  • 7. Sorting Records/4. Exercise Overview.mp4 1.6 MB
  • 4. Relating Records with Joins/11.1 009_-_joins_-_cheatsheet.pdf 195.1 kB
  • 36. Fast Parallel Testing/16.1 037_-_access.zip 68.2 kB
  • 36. Fast Parallel Testing/17.1 038_-_access.zip 68.2 kB
  • 36. Fast Parallel Testing/15.1 036_-_access.zip 68.1 kB
  • 36. Fast Parallel Testing/14.1 035_-_access.zip 67.7 kB
  • 36. Fast Parallel Testing/13.1 034_-_access.zip 67.7 kB
  • 36. Fast Parallel Testing/7.1 028_-_access.zip 67.3 kB
  • 36. Fast Parallel Testing/6.1 027_-_access.zip 66.1 kB
  • 36. Fast Parallel Testing/5.1 026_-_access.zip 66.1 kB
  • 36. Fast Parallel Testing/4.1 025_-_access.zip 66.1 kB
  • 36. Fast Parallel Testing/3.1 024_-_access.zip 66.0 kB
  • 35. Security Around PostgreSQL/7.1 021_-_access.zip 65.2 kB
  • 35. Security Around PostgreSQL/5.1 019_-_access.zip 65.1 kB
  • 34. Data Access Pattern - Repositories/2.1 010_-_access.zip 64.1 kB
  • 33. Accessing PostgreSQL From API's/7.1 008_-_access.zip 63.5 kB
  • 33. Accessing PostgreSQL From API's/4.1 005_-_access_-_social-repo.zip 62.8 kB
  • 22. Understanding the Internals of PostgreSQL/6. Heap File Layout.srt 49.5 kB
  • 23. A Look at Indexes for Performance/10. Behind the Scenes of Indexes.srt 48.7 kB
  • 31. Managing Database Design with Schema Migrations/1. A Story on Migrations.srt 27.8 kB
  • 9. Assembling Queries with SubQueries/27. Probably Too Much About Correlated Subqueries.srt 25.2 kB
  • 32. Schema vs Data Migrations/9. Transaction Locks.srt 22.2 kB
  • 20. Implementing Database Design Patterns/2. Creating Tables with Checks.srt 20.9 kB
  • 32. Schema vs Data Migrations/5. A Small Web Server.srt 20.9 kB
  • 25. Advanced Query Tuning/1. Developing an Intuitive Understanding of Cost.srt 20.4 kB
  • 36. Fast Parallel Testing/13. Programmatic Schema Creation.srt 18.1 kB
  • 6. Working with Large Datasets/1. A New Dataset.html 17.5 kB
  • 6. Working with Large Datasets/2.1 001 - sq - data.sql 16.2 kB
  • 27. Recursive Common Table Expressions/2. Recursive CTE's Step by Step.srt 15.5 kB
  • 30. Handling Concurrency and Reversibility with Transactions/3. Opening and Closing Transactions.srt 15.1 kB
  • 27. Recursive Common Table Expressions/5. Walking Through Recursion.srt 14.9 kB
  • 4. Relating Records with Joins/11. Four Kinds of Joins.srt 14.7 kB
  • 13. PostgreSQL Complex Datatypes/4. More on Number Data Types.srt 14.7 kB
  • 32. Schema vs Data Migrations/2. Dangers Around Data Migrations.srt 14.5 kB
  • 24. Basic Query Tuning/4. Solving an Explain Mystery.srt 14.0 kB
  • 29. Optimizing Queries with Materialized Views/4. Writing a Slow Query.srt 13.9 kB
  • 9. Assembling Queries with SubQueries/10. Example of a Subquery in a From.srt 13.7 kB
  • 9. Assembling Queries with SubQueries/15. More Useful - Subqueries with Where.srt 13.6 kB
  • 9. Assembling Queries with SubQueries/28. More on Correlated Subqueries.srt 13.1 kB
  • 3. Working with Tables/9. Understanding Foreign Keys.srt 12.9 kB
  • 35. Security Around PostgreSQL/2. Handling SQL Injection with Prepared Statements.srt 12.8 kB
  • 25. Advanced Query Tuning/7. Use My Index!.srt 12.7 kB
  • 20. Implementing Database Design Patterns/3. Posts Creation.srt 12.7 kB
  • 17. How to Build a 'Mention' System/3. Photo Mentions vs Caption Mentions.srt 12.6 kB
  • 34. Data Access Pattern - Repositories/2. Creating a Repository.srt 12.6 kB
  • 23. A Look at Indexes for Performance/3. How an Index Works.srt 12.3 kB
  • 4. Relating Records with Joins/19. Three Way Joins.srt 12.2 kB
  • 3. Working with Tables/2. Approaching Database Design.srt 12.0 kB
  • 9. Assembling Queries with SubQueries/8. Subqueries in a From.srt 12.0 kB
  • 18. How to Build a 'Hashtag' System/1. Designing a Hashtag System.srt 11.9 kB
  • 27. Recursive Common Table Expressions/4. Writing the Query.srt 11.9 kB
  • 4. Relating Records with Joins/3. Joining Data from Different Tables.srt 11.8 kB
  • 15. Database Structure Design Patterns/3. A Config-based Schema Designer.srt 11.8 kB
  • 17. How to Build a 'Mention' System/4. Considerations on Photo Tags vs Caption Tags.srt 11.6 kB
  • 35. Security Around PostgreSQL/3. Preventing SQL Injection.srt 11.5 kB
  • 14. Database-Side Validation and Constraints/2. Creating and Viewing Tables in PGAdmin.srt 11.5 kB
  • 25. Advanced Query Tuning/3. A Touch More on Costs.srt 11.4 kB
  • 31. Managing Database Design with Schema Migrations/8. Applying and Reverting Migrations.srt 11.2 kB
  • 16. How to Build a 'Like' System/7. Polymorphic Association Alternative Implementation.srt 10.9 kB
  • 35. Security Around PostgreSQL/1. SQL Injection Exploits.srt 10.8 kB
  • 33. Accessing PostgreSQL From API's/6. Validating Connection Credentials.srt 10.6 kB
  • 33. Accessing PostgreSQL From API's/5. Understanding Connection Pools.srt 10.6 kB
  • 15. Database Structure Design Patterns/5. Rebuilding Some Schema.srt 10.6 kB
  • 36. Fast Parallel Testing/2. Assertions Around User Count.srt 10.6 kB
  • 31. Managing Database Design with Schema Migrations/7. Generating and Writing Migrations.srt 10.4 kB
  • 5. Aggregation of Records/16. More on Having!.srt 10.4 kB
  • 3. Working with Tables/13. Running Queries on Associated Data.srt 10.3 kB
  • 4. Relating Records with Joins/18. Where with Join.srt 10.3 kB
  • 14. Database-Side Validation and Constraints/3. Applying a Null Constraint.srt 10.2 kB
  • 3. Working with Tables/4. One-to-Many and Many-to-One Relationships.srt 10.1 kB
  • 25. Advanced Query Tuning/2. Calculating Cost by Hand.srt 10.1 kB
  • 17. How to Build a 'Mention' System/1. Additional Features Around Posts.srt 10.0 kB
  • 20. Implementing Database Design Patterns/5. Likes Creation.srt 10.0 kB
  • 12. Local PostgreSQL Installation/1. PostgreSQL Installation on macOS.srt 9.9 kB
  • 15. Database Structure Design Patterns/2. Using a SQL Design Tool.srt 9.9 kB
  • 14. Database-Side Validation and Constraints/13. So Where Are We Applying Validation.srt 9.9 kB
  • 1. Simple - But Powerful - SQL Statements/14. String Operators and Functions.srt 9.9 kB
  • 28. Simplifying Queries with Views/1. Most Popular Users.srt 9.8 kB
  • 18. How to Build a 'Hashtag' System/4. A Few More User Columns.srt 9.8 kB
  • 4. Relating Records with Joins/9. Missing Data in Joins.srt 9.8 kB
  • 9. Assembling Queries with SubQueries/21. A New Where Operator.srt 9.6 kB
  • 16. How to Build a 'Like' System/6. Polymorphic Associations.srt 9.6 kB
  • 34. Data Access Pattern - Repositories/5. Fixing Casing.srt 9.5 kB
  • 8. Unions and Intersections with Sets/4. Removing Commonalities with Except.srt 9.4 kB
  • 4. Relating Records with Joins/8. Alternate Forms of Syntax.srt 9.3 kB
  • 19. How to Design a 'Follower' System/1. Designing a Follower System.srt 9.2 kB
  • 25. Advanced Query Tuning/5. Startup vs Total Costs.srt 9.1 kB
  • 20. Implementing Database Design Patterns/7. Creating Hashtags, Hashtag Posts, and Followers.srt 9.0 kB
  • 13. PostgreSQL Complex Datatypes/8. Really Awesome Intervals.srt 9.0 kB
  • 9. Assembling Queries with SubQueries/16. Data Structure with Where Subqueries.srt 8.9 kB
  • 3. Working with Tables/11. Auto-Generated ID's.srt 8.9 kB
  • 9. Assembling Queries with SubQueries/1. What's a Subquery.srt 8.9 kB
  • 32. Schema vs Data Migrations/3. Properly Running Data and Schema Migrations.srt 8.8 kB
  • 14. Database-Side Validation and Constraints/7. Applying a Unique Constraint to One column.srt 8.8 kB
  • 22. Understanding the Internals of PostgreSQL/2. Where Does Postgres Store Data.srt 8.8 kB
  • 36. Fast Parallel Testing/10. Controlling Schema Access with Search Paths.srt 8.8 kB
  • 8. Unions and Intersections with Sets/1. Handling Sets with Union.srt 8.7 kB
  • 3. Working with Tables/6. One-to-One and Many-to-Many Relationships.srt 8.7 kB
  • 3. Working with Tables/17. Foreign Key Constraints Around Insertion.srt 8.7 kB
  • 9. Assembling Queries with SubQueries/4. Subqueries in a Select.srt 8.5 kB
  • 23. A Look at Indexes for Performance/5. Benchmarking Queries.srt 8.5 kB
  • 28. Simplifying Queries with Views/3. Creating a View.srt 8.5 kB
  • 13. PostgreSQL Complex Datatypes/7. Times, Dates, and Timestamps.srt 8.3 kB
  • 24. Basic Query Tuning/2. Explain and Explain Analyze.srt 8.3 kB
  • 16. How to Build a 'Like' System/3. Designing a Like System.srt 8.3 kB
  • 5. Aggregation of Records/2. Picturing Group By.srt 8.2 kB
  • 20. Implementing Database Design Patterns/6. Photo Tags and Caption Tags.srt 8.2 kB
  • 9. Assembling Queries with SubQueries/22. Finally Some!.srt 8.2 kB
  • 23. A Look at Indexes for Performance/6. Downsides of Indexes.srt 8.2 kB
  • 36. Fast Parallel Testing/6. Assumptions Around Content.srt 8.2 kB
  • 36. Fast Parallel Testing/3. Connecting to a DB For Tests.srt 8.2 kB
  • 1. Simple - But Powerful - SQL Statements/3. Database Design.srt 8.2 kB
  • 34. Data Access Pattern - Repositories/6. Finding Particular Users.srt 8.2 kB
  • 36. Fast Parallel Testing/16. Cleaning up Schemas and Roles.srt 8.2 kB
  • 24. Basic Query Tuning/1. The Query Processing Pipeline.srt 8.1 kB
  • 36. Fast Parallel Testing/9. Creating and Accessing Schemas.srt 8.0 kB
  • 36. Fast Parallel Testing/15. Test Helpers.srt 7.9 kB
  • 36. Fast Parallel Testing/7. Issues with Parallel Tests.srt 7.9 kB
  • 3. Working with Tables/8. Primary Keys and Foreign Keys.srt 7.9 kB
  • 31. Managing Database Design with Schema Migrations/4. A Few Notes on Migrations Libraries.srt 7.8 kB
  • 4. Relating Records with Joins/12.1 010 - sql - cumulative.sql 7.8 kB
  • 4. Relating Records with Joins/9.1 007 - joins - cumulative.sql 7.7 kB
  • 5. Aggregation of Records/14. Filtering Groups with Having.srt 7.7 kB
  • 12. Local PostgreSQL Installation/2. PGAdmin Setup on macOS.srt 7.7 kB
  • 16. How to Build a 'Like' System/1. Requirements of a Like System.srt 7.7 kB
  • 4. Relating Records with Joins/1. Adding Some Data.html 7.7 kB
  • 1. Simple - But Powerful - SQL Statements/5. Creating Tables.srt 7.7 kB
  • 4. Relating Records with Joins/20. A Bit of Practice.srt 7.6 kB
  • 3. Working with Tables/18. Constraints Around Deletion.srt 7.6 kB
  • 14. Database-Side Validation and Constraints/11. Checks Over Multiple Columns.srt 7.6 kB
  • 2. Filtering Records/3. Compound Where Clauses.srt 7.6 kB
  • 1. Simple - But Powerful - SQL Statements/7. Inserting Data Into a Table.srt 7.5 kB
  • 9. Assembling Queries with SubQueries/2. Thinking About the Structure of Data.srt 7.5 kB
  • 31. Managing Database Design with Schema Migrations/2. Migration Files.srt 7.5 kB
  • 13. PostgreSQL Complex Datatypes/5. Reminder on Character Types.srt 7.5 kB
  • 36. Fast Parallel Testing/5. Multi-DB Setup.srt 7.5 kB
  • 3. Working with Tables/12. Creating Foreign Key Columns.srt 7.4 kB
  • 1. Simple - But Powerful - SQL Statements/2. What is PostgreSQL All About.srt 7.4 kB
  • 17. How to Build a 'Mention' System/5. Update For Tags.srt 7.4 kB
  • 1. Simple - But Powerful - SQL Statements/10. Calculated Columns.srt 7.3 kB
  • 33. Accessing PostgreSQL From API's/3. One Fast Migration.srt 7.3 kB
  • 5. Aggregation of Records/5. Combining Group By and Aggregates.srt 7.2 kB
  • 36. Fast Parallel Testing/12. Strategy for Isolation.srt 7.2 kB
  • 13. PostgreSQL Complex Datatypes/2. Data Types.srt 7.1 kB
  • 34. Data Access Pattern - Repositories/4. Casing Issues.srt 7.0 kB
  • 16. How to Build a 'Like' System/10. So Which Approach.srt 7.0 kB
  • 21. Approaching and Writing Complex Queries/3. Restoring from Scratch.srt 7.0 kB
  • 22. Understanding the Internals of PostgreSQL/5. Block Data Layout.srt 6.9 kB
  • 29. Optimizing Queries with Materialized Views/3. Reminder on Left Joins.srt 6.9 kB
  • 32. Schema vs Data Migrations/4. Creating a Posts Table.srt 6.8 kB
  • 14. Database-Side Validation and Constraints/1. Thinking About Validation.srt 6.8 kB
  • 9. Assembling Queries with SubQueries/14. Subqueries in a Join Clause.srt 6.8 kB
  • 35. Security Around PostgreSQL/6. Handling Updates.srt 6.8 kB
  • 33. Accessing PostgreSQL From API's/4. Building the Users Router.srt 6.7 kB
  • 3. Working with Tables/20. Testing Deletion Constraints.srt 6.7 kB
  • 11. Utility Operators, Keywords, and Functions/3. The Case Keyword.srt 6.7 kB
  • 21. Approaching and Writing Complex Queries/2. Adding Some Data.srt 6.6 kB
  • 36. Fast Parallel Testing/11. Routing Schema Access.srt 6.6 kB
  • 32. Schema vs Data Migrations/12. Updating the App Server.srt 6.6 kB
  • 12. Local PostgreSQL Installation/3. Postgres installation on Windows.srt 6.6 kB
  • 36. Fast Parallel Testing/8. Isolation with Schemas.srt 6.5 kB
  • 13. PostgreSQL Complex Datatypes/1. What'd We Just Do.srt 6.5 kB
  • 23. A Look at Indexes for Performance/1. Full Table Scans.srt 6.5 kB
  • 10. Selecting Distinct Records/1. Selecting Distinct Values.srt 6.5 kB
  • 32. Schema vs Data Migrations/8. Writing Values to Both Columns.srt 6.5 kB
  • 14. Database-Side Validation and Constraints/4. Solving a Gotcha with Null Constraints.srt 6.4 kB
  • 2. Filtering Records/13. Updating Rows.srt 6.4 kB
  • 9. Assembling Queries with SubQueries/20. The Not In Operator with a List.srt 6.4 kB
  • 32. Schema vs Data Migrations/10. Updating Values.srt 6.4 kB
  • 4. Relating Records with Joins/13. Does Order Matter.srt 6.4 kB
  • 30. Handling Concurrency and Reversibility with Transactions/1. What are Transactions Used For.srt 6.4 kB
  • 32. Schema vs Data Migrations/1. Schema vs Data Migrations.srt 6.4 kB
  • 36. Fast Parallel Testing/14. Escaping Identifiers.srt 6.4 kB
  • 29. Optimizing Queries with Materialized Views/2. Grouping by Week.srt 6.4 kB
  • 35. Security Around PostgreSQL/7. And, Finally, Delete.srt 6.3 kB
  • 4. Relating Records with Joins/12. Each Join in Practice.srt 6.3 kB
  • 35. Security Around PostgreSQL/5. Inserting Users.srt 6.3 kB
  • 23. A Look at Indexes for Performance/4. Creating an Index.srt 6.2 kB
  • 28. Simplifying Queries with Views/2. A Possible Solution for Merging Tables.srt 6.2 kB
  • 30. Handling Concurrency and Reversibility with Transactions/4. Transaction Cleanup on Crash.srt 6.1 kB
  • 14. Database-Side Validation and Constraints/10. Adding a Validation Check.srt 6.1 kB
  • 16. How to Build a 'Like' System/8. The Simplest Alternative.srt 6.1 kB
  • 18. How to Build a 'Hashtag' System/5. Why No Number of Followers or Posts.srt 6.0 kB
  • 32. Schema vs Data Migrations/7. Adding the Loc Column.srt 6.0 kB
  • 18. How to Build a 'Hashtag' System/3. Including the Hashtag Table.srt 5.9 kB
  • 18. How to Build a 'Hashtag' System/2. Tables for Hashtags.srt 5.8 kB
  • 2. Filtering Records/1. Filtering Rows with Where.srt 5.8 kB
  • 26. Simple Common Table Expressions/3. So What's a CTE.srt 5.8 kB
  • 22. Understanding the Internals of PostgreSQL/3. Heaps, Blocks, and Tuples.srt 5.8 kB
  • 23. A Look at Indexes for Performance/8. Automatically Generated Indexes.srt 5.7 kB
  • 34. Data Access Pattern - Repositories/1. The Repository Pattern.srt 5.7 kB
  • 8. Unions and Intersections with Sets/2. A Few Notes on Union.srt 5.7 kB
  • 26. Simple Common Table Expressions/2. A Quick Solution.srt 5.6 kB
  • 1. Simple - But Powerful - SQL Statements/6. Analyzing CREATE TABLE.srt 5.5 kB
  • 5. Aggregation of Records/17. A Having Exercise Overview.srt 5.5 kB
  • 9. Assembling Queries with SubQueries/29. A Select Without a From.srt 5.3 kB
  • 36. Fast Parallel Testing/17. Finally... Parallel Tests!.srt 5.3 kB
  • 14. Database-Side Validation and Constraints/8. Multi-Column Uniqueness.srt 5.2 kB
  • 4. Relating Records with Joins/2. Queries with Joins and Aggregations.srt 5.2 kB
  • 31. Managing Database Design with Schema Migrations/9. Generating and Applying a Second Migration.srt 5.2 kB
  • 11. Utility Operators, Keywords, and Functions/1. The Greatest Value in a List.srt 5.0 kB
  • 27. Recursive Common Table Expressions/1. Recursive CTE's.srt 5.0 kB
  • 8. Unions and Intersections with Sets/3. Commonalities with Intersect.srt 5.0 kB
  • 2. Filtering Records/14. Deleting Rows.srt 5.0 kB
  • 28. Simplifying Queries with Views/4. When to Use a View.srt 5.0 kB
  • 36. Fast Parallel Testing/1. A Note on Testing.srt 5.0 kB
  • 16. How to Build a 'Like' System/2. How Not to Design a Like System.srt 4.8 kB
  • 3. Working with Tables/23. Adding Some Complexity.srt 4.8 kB
  • 4. Relating Records with Joins/17. Two Possible Solutions.srt 4.7 kB
  • 36. Fast Parallel Testing/4. Disconnecting After Tests.srt 4.6 kB
  • 5. Aggregation of Records/7. Visualizing More Grouping.srt 4.6 kB
  • 5. Aggregation of Records/4. Aggregate Functions.srt 4.5 kB
  • 31. Managing Database Design with Schema Migrations/6. Project Creation.srt 4.5 kB
  • 31. Managing Database Design with Schema Migrations/3. Issues Solved by Migrations.srt 4.5 kB
  • 3. Working with Tables/21. Setting Foreign Keys to Null on Delete.srt 4.4 kB
  • 9. Assembling Queries with SubQueries/9. From Subqueries that Return a Value.srt 4.3 kB
  • 15. Database Structure Design Patterns/4. Here's the Plan.srt 4.2 kB
  • 35. Security Around PostgreSQL/4. Reminder on Post Requests.srt 4.2 kB
  • 5. Aggregation of Records/6. A Gotcha with Count.srt 4.1 kB
  • 7. Sorting Records/2. Two Variations on Sorting.srt 4.1 kB
  • 23. A Look at Indexes for Performance/2. What's an Index.srt 4.0 kB
  • 4. Relating Records with Joins/22. Exercise Solution.srt 4.0 kB
  • 5. Aggregation of Records/15. Having In Action.srt 4.0 kB
  • 13. PostgreSQL Complex Datatypes/6. Boolean Data Types.srt 3.9 kB
  • 29. Optimizing Queries with Materialized Views/1. Materialized Views.srt 3.9 kB
  • 2. Filtering Records/2. More on the Where Keyword.srt 3.8 kB
  • 5. Aggregation of Records/19. A Quick Solution.srt 3.8 kB
  • 4. Relating Records with Joins/10. Why Wasn't It Included.srt 3.8 kB
  • 28. Simplifying Queries with Views/5. Deleting and Changing Views.srt 3.7 kB
  • 22. Understanding the Internals of PostgreSQL/1. Thinking About Performance.srt 3.7 kB
  • 7. Sorting Records/1. The Basics of Sorting.srt 3.6 kB
  • 13. PostgreSQL Complex Datatypes/3. Fast Rules on Numeric Data Types.srt 3.6 kB
  • 5. Aggregation of Records/1. Aggregating and Grouping.srt 3.5 kB
  • 6. Working with Large Datasets/6. Remember Joins.srt 3.5 kB
  • 6. Working with Large Datasets/5. Group By Review Solution.srt 3.5 kB
  • 20. Implementing Database Design Patterns/4. Comments Creation.srt 3.4 kB
  • 3. Working with Tables/14. Exercise Overview.srt 3.4 kB
  • 1. Simple - But Powerful - SQL Statements/8. Retrieving Data with Select.srt 3.3 kB
  • 20. Implementing Database Design Patterns/1. Back to Postgres.srt 3.3 kB
  • 4. Relating Records with Joins/4. Another Quick Join.srt 3.2 kB
  • 30. Handling Concurrency and Reversibility with Transactions/2. Some Sample Data.srt 3.1 kB
  • 33. Accessing PostgreSQL From API's/7. Query and Close.srt 3.1 kB
  • 25. Advanced Query Tuning/6. Costs Flow Up.srt 3.1 kB
  • 21. Approaching and Writing Complex Queries/4. Highest User ID's Exercise.srt 3.1 kB
  • 9. Assembling Queries with SubQueries/19. Exercise Solution.srt 3.1 kB
  • 2. Filtering Records/10. Calculations in Where Clauses.srt 3.1 kB
  • 37. Bonus!/1. Bonus!.html 3.0 kB
  • 11. Utility Operators, Keywords, and Functions/2. And the Least Value in a List!.srt 3.0 kB
  • 3. Working with Tables/16. Foreign Key Creation Solution.srt 3.0 kB
  • 26. Simple Common Table Expressions/1. Common Table Expressions.srt 3.0 kB
  • 20. Implementing Database Design Patterns/7.1 007 - db.sql 2.9 kB
  • 21. Approaching and Writing Complex Queries/7. Solving for Posts by User.srt 2.8 kB
  • 3. Working with Tables/1. The Plan Moving Forward.srt 2.8 kB
  • 30. Handling Concurrency and Reversibility with Transactions/5. Closing Aborted Transactions.srt 2.7 kB
  • 17. How to Build a 'Mention' System/2. Adding Captions and Locations.srt 2.6 kB
  • 23. A Look at Indexes for Performance/7. Index Types.srt 2.6 kB
  • 4. Relating Records with Joins/7. A Joinful Solution.srt 2.6 kB
  • 16. How to Build a 'Like' System/5. Making a Reaction System Instead.srt 2.5 kB
  • 21. Approaching and Writing Complex Queries/9. Solution for Likes Per User.srt 2.5 kB
  • 9. Assembling Queries with SubQueries/26. A Quick Solution.srt 2.4 kB
  • 2. Filtering Records/9. A Where With Lists Solution.srt 2.3 kB
  • 20. Implementing Database Design Patterns/6.1 006 - db.sql 2.2 kB
  • 8. Unions and Intersections with Sets/5. Union Exercise Overview.srt 2.2 kB
  • 5. Aggregation of Records/13. Solution.srt 2.2 kB
  • 2. Filtering Records/16. A Solution for Updating Rows.srt 2.2 kB
  • 5. Aggregation of Records/10. Grouping Solution.srt 2.1 kB
  • 6. Working with Large Datasets/8. Of Course You Remember!.srt 2.1 kB
  • 8. Unions and Intersections with Sets/7. Exercise Solution.srt 2.1 kB
  • 7. Sorting Records/6. Exercise Solution.srt 2.0 kB
  • 6. Working with Large Datasets/3. Some Group By Practice.srt 2.0 kB
  • 2. Filtering Records/18. Solution for Deleting Rows.srt 2.0 kB
  • 9. Assembling Queries with SubQueries/11. Exercise Overview.srt 1.9 kB
  • 21. Approaching and Writing Complex Queries/5. Solution for User ID's.srt 1.8 kB
  • 9. Assembling Queries with SubQueries/7. Select Solution.srt 1.8 kB
  • 4. Relating Records with Joins/5. Exercise Overview.srt 1.8 kB
  • 21. Approaching and Writing Complex Queries/6. Posts by a Particular User.srt 1.8 kB
  • 9. Assembling Queries with SubQueries/32. Exercise Solution.srt 1.7 kB
  • 9. Assembling Queries with SubQueries/5. Exercise Overview.srt 1.7 kB
  • 1. Simple - But Powerful - SQL Statements/13. Exercise Solution.srt 1.6 kB
  • 20. Implementing Database Design Patterns/5.1 005 - db.sql 1.6 kB
  • 1. Simple - But Powerful - SQL Statements/11. Calculating Phone Revenue.srt 1.6 kB
  • 33. Accessing PostgreSQL From API's/1. Section Goal.srt 1.5 kB
  • 4. Relating Records with Joins/15. Exercise Overview.srt 1.5 kB
  • 32. Schema vs Data Migrations/5.1 005 - index.js 1.3 kB
  • 2. Filtering Records/6. A Where Solution.srt 1.3 kB
  • 3. Working with Tables/21.1 015 - tables - cumulative.sql 1.3 kB
  • 9. Assembling Queries with SubQueries/30. Exercise Overview.srt 1.2 kB
  • 5. Aggregation of Records/8. Exercise Overview.srt 1.1 kB
  • 20. Implementing Database Design Patterns/4.1 004 - db.sql 1.1 kB
  • 5. Aggregation of Records/11. Adding a Layer of Difficulty.srt 1.1 kB
  • 2. Filtering Records/7. Where With Lists.srt 1.0 kB
  • 32. Schema vs Data Migrations/6. Web Server Setup Instructions.html 1.0 kB
  • 3. Working with Tables/20.1 014 - tables - cumulative.sql 994 Bytes
  • 2. Filtering Records/4. A Where Exercise Overview.srt 960 Bytes
  • 10. Selecting Distinct Records/4. A Distinct Solution.srt 929 Bytes
  • 32. Schema vs Data Migrations/11. Migrations Setup Instructions.html 925 Bytes
  • 10. Selecting Distinct Records/2. Exercise Overview.srt 874 Bytes
  • 20. Implementing Database Design Patterns/3.1 003 - db.sql 791 Bytes
  • 9. Assembling Queries with SubQueries/24. Exercise Overview.srt 741 Bytes
  • 7. Sorting Records/4. Exercise Overview.srt 690 Bytes
  • 3. Working with Tables/19. Commands You’ll Need for the Next Video.html 676 Bytes
  • 3. Working with Tables/17.2 012 - tables - cumulative.sql 600 Bytes
  • 3. Working with Tables/13.2 009 - tables - cumulative.sql 536 Bytes
  • 3. Working with Tables/20.2 014 - tables.sql 469 Bytes
  • 15. Database Structure Design Patterns/5.1 005 - design.dbml 455 Bytes
  • 1. Simple - But Powerful - SQL Statements/14.1 012 - sql.sql 404 Bytes
  • 1. Simple - But Powerful - SQL Statements/7.2 005 - sql - cumulative.sql 384 Bytes
  • 20. Implementing Database Design Patterns/2.1 002 - db.sql 375 Bytes
  • 32. Schema vs Data Migrations/11.1 01-lng-lat-to-loc.js 364 Bytes
  • 3. Working with Tables/12.2 008 - tables - cumulative.sql 348 Bytes
  • 3. Working with Tables/21.2 015 - tables.sql 340 Bytes
  • 3. Working with Tables/13.1 009 - tables.sql 326 Bytes
  • 1. Simple - But Powerful - SQL Statements/7.1 005 - sql.sql 278 Bytes
  • 1. Simple - But Powerful - SQL Statements/1. Join Our Community!.html 271 Bytes
  • 31. Managing Database Design with Schema Migrations/5. A Note About Node Installation.html 264 Bytes
  • 21. Approaching and Writing Complex Queries/1. Quick Note About Adding Some Data.html 251 Bytes
  • 3. Working with Tables/17.1 012 - tables.sql 199 Bytes
  • 3. Working with Tables/12.1 008 - tables.sql 197 Bytes
  • 3. Working with Tables/11.2 007 - tables.sql 194 Bytes
  • 3. Working with Tables/11.1 007 - tables - cumulative.sql 172 Bytes
  • 0. Websites you may like/[FCS Forum].url 133 Bytes
  • 1. Simple - But Powerful - SQL Statements/12. Using Calculated Columns.html 129 Bytes
  • 1. Simple - But Powerful - SQL Statements/4. Database Terminology.html 129 Bytes
  • 1. Simple - But Powerful - SQL Statements/9. Create, Insert, and Select!.html 129 Bytes
  • 10. Selecting Distinct Records/3. Some Practice with Distinct.html 129 Bytes
  • 14. Database-Side Validation and Constraints/12. Does It Pass a Check.html 129 Bytes
  • 14. Database-Side Validation and Constraints/5. Creating NULL Constraints.html 129 Bytes
  • 14. Database-Side Validation and Constraints/9. Is It Unique.html 129 Bytes
  • 16. How to Build a 'Like' System/4. Building a Similar System.html 129 Bytes
  • 16. How to Build a 'Like' System/9. Polymorphic Associations.html 129 Bytes
  • 2. Filtering Records/11. Trying Calculations in Where Clauses.html 129 Bytes
  • 2. Filtering Records/15. Try Updating Records In a Table!.html 129 Bytes
  • 2. Filtering Records/17. Practice Deleting Records.html 129 Bytes
  • 2. Filtering Records/5. Practicing Where Statements.html 129 Bytes
  • 2. Filtering Records/8. A More Challenging 'Where'.html 129 Bytes
  • 22. Understanding the Internals of PostgreSQL/4. Terminology Check.html 129 Bytes
  • 23. A Look at Indexes for Performance/9. Using Automatically Created Indexes.html 129 Bytes
  • 24. Basic Query Tuning/3. Explain Vs Explain Analyze.html 129 Bytes
  • 25. Advanced Query Tuning/4. Calculating Costs.html 129 Bytes
  • 29. Optimizing Queries with Materialized Views/6. Views vs Materialized Views.html 129 Bytes
  • 3. Working with Tables/10. Foreign Keys; How Do They Work.html 129 Bytes
  • 3. Working with Tables/15. Creating and Using Foreign Keys.html 129 Bytes
  • 3. Working with Tables/22. What Happens On Delete.html 129 Bytes
  • 3. Working with Tables/3. Let's Design Some Schema.html 129 Bytes
  • 3. Working with Tables/5. A 'Has One' or 'Has Many'.html 129 Bytes
  • 3. Working with Tables/7. Identifying One-to-One and Many-to-Many Relationships.html 129 Bytes
  • 4. Relating Records with Joins/14. Test Your Joining Knowledge.html 129 Bytes
  • 4. Relating Records with Joins/16. Joins, Joins, Join!.html 129 Bytes
  • 4. Relating Records with Joins/21. Three Way Exercise.html 129 Bytes
  • 4. Relating Records with Joins/6. Practice Joining Data.html 129 Bytes
  • 5. Aggregation of Records/12. Grouping With a Join!.html 129 Bytes
  • 5. Aggregation of Records/18. Practice Yourself Some Having.html 129 Bytes
  • 5. Aggregation of Records/3. Selecting Columns After Grouping.html 129 Bytes
  • 5. Aggregation of Records/9. Practice For Grouping and Aggregating.html 129 Bytes
  • 6. Working with Large Datasets/4. Group By Review.html 129 Bytes
  • 6. Working with Large Datasets/7. Inner Join Review.html 129 Bytes
  • 7. Sorting Records/5. Sorting, Offsetting, and Limiting.html 129 Bytes
  • 8. Unions and Intersections with Sets/6. Merging Results with Union.html 129 Bytes
  • 9. Assembling Queries with SubQueries/12. Subquery From's.html 129 Bytes
  • 9. Assembling Queries with SubQueries/18. Subquery Where's.html 129 Bytes
  • 9. Assembling Queries with SubQueries/23. Is It A Valid Subquery.html 129 Bytes
  • 9. Assembling Queries with SubQueries/25. Practice Your Subqueries!.html 129 Bytes
  • 9. Assembling Queries with SubQueries/3. What's the Data Look Like.html 129 Bytes
  • 9. Assembling Queries with SubQueries/31. From-less Selects.html 129 Bytes
  • 9. Assembling Queries with SubQueries/6. Embedding in Select.html 129 Bytes
  • 0. Websites you may like/[FreeCourseSite.com].url 127 Bytes
  • 0. Websites you may like/[CourseClub.ME].url 122 Bytes
  • 1. Simple - But Powerful - SQL Statements/5.1 003 - sql.sql 104 Bytes
  • 2. Filtering Records/1.1 013 - sql.sql 48 Bytes

随机展示

相关说明

本站不存储任何资源内容，只收集BT种子元数据(例如文件名和文件大小)和磁力链接(BT种子标识符)，并提供查询服务，是一个完全合法的搜索引擎系统。 网站不提供种子下载服务，用户可以通过第三方链接或磁力链接获取到相关的种子资源。本站也不对BT种子真实性及合法性负责，请用户注意甄别！