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

磁力链接/BT种子名称

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

磁力链接/BT种子简介

种子哈希：916d182980a7ad02a2b56938e0020c293e60dd26
文件大小： 7.6G
已经下载：1480次
下载速度：极快
收录时间：2021-05-16
最近下载：2024-11-06

移花宫入口

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

磁力链接下载

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

下载BT种子文件

磁力链接 迅雷下载 PIKPAK在线播放 91视频 含羞草 欲漫涩 逼哩逼哩 成人快手 51品茶 抖阴破解版 暗网禁地 91短视频 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种子真实性及合法性负责，请用户注意甄别！
>