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

磁力链接/BT种子名称

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

磁力链接/BT种子简介

种子哈希：676afd50dbab55ed8d01f888bc3f36d8f79a10f3
文件大小： 5.02G
已经下载：1973次
下载速度：极快
收录时间：2022-01-22
最近下载：2025-09-30

移花宫入口

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

磁力链接下载

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

下载BT种子文件

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

最近搜索

文件列表

  • 22 - Understanding the Internals of PostgreSQL/005 Heap File Layout.mp4 355.1 MB
  • 23 - A Look at Indexes for Performance/009 Behind the Scenes of Indexes.mp4 249.9 MB
  • 31 - Managing Database Design with Schema Migrations/001 A Story on Migrations.mp4 92.9 MB
  • 04 - Relating Records with Joins/010 Four Kinds of Joins.mp4 78.9 MB
  • 09 - Assembling Queries with SubQueries/021 Probably Too Much About Correlated Subqueries.mp4 70.1 MB
  • 27 - Recursive Common Table Expressions/005 Walking Through Recursion.mp4 69.2 MB
  • 25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost.mp4 67.7 MB
  • 32 - Schema vs Data Migrations/009 Transaction Locks.mp4 65.7 MB
  • 18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System.mp4 63.5 MB
  • 25 - Advanced Query Tuning/003 A Touch More on Costs.mp4 58.0 MB
  • 17 - How to Build a 'Mention' System/001 Additional Features Around Posts.mp4 56.7 MB
  • 24 - Basic Query Tuning/003 Solving an Explain Mystery.mp4 51.4 MB
  • 32 - Schema vs Data Migrations/002 Dangers Around Data Migrations.mp4 46.5 MB
  • 17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions.mp4 46.4 MB
  • 23 - A Look at Indexes for Performance/003 How an Index Works.mp4 45.3 MB
  • 17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags.mp4 45.0 MB
  • 30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions.mp4 44.2 MB
  • 03 - Working with Tables/006 Understanding Foreign Keys.mp4 43.6 MB
  • 36 - Fast Parallel Testing/013 Programmatic Schema Creation.mp4 43.2 MB
  • 32 - Schema vs Data Migrations/005 A Small Web Server.mp4 42.6 MB
  • 31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations.mp4 42.1 MB
  • 20 - Implementing Database Design Patterns/002 Creating Tables with Checks.mp4 42.0 MB
  • 27 - Recursive Common Table Expressions/002 Recursive CTE's Step by Step.mp4 42.0 MB
  • 16 - How to Build a 'Like' System/006 Polymorphic Association Alternative Implementation.mp4 41.4 MB
  • 04 - Relating Records with Joins/012 Does Order Matter_.mp4 37.7 MB
  • 01 - Simple - But Powerful - SQL Statements/004 Database Design.mp4 37.1 MB
  • 29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query.mp4 36.8 MB
  • 09 - Assembling Queries with SubQueries/008 Example of a Subquery in a From.mp4 36.0 MB
  • 16 - How to Build a 'Like' System/005 Polymorphic Associations.mp4 35.0 MB
  • 15 - Database Structure Design Patterns/002 Using a SQL Design Tool.mp4 34.0 MB
  • 25 - Advanced Query Tuning/002 Calculating Cost by Hand.mp4 33.7 MB
  • 04 - Relating Records with Joins/016 Three Way Joins.mp4 33.6 MB
  • 36 - Fast Parallel Testing/003 Connecting to a DB For Tests.mp4 33.6 MB
  • 05 - Aggregation of Records/002 Picturing Group By.mp4 32.4 MB
  • 13 - PostgreSQL Complex Datatypes/004 More on Number Data Types.mp4 32.0 MB
  • 03 - Working with Tables/002 Approaching Database Design.mp4 32.0 MB
  • 34 - Data Access Pattern - Repositories/005 Fixing Casing.mp4 31.8 MB
  • 31 - Managing Database Design with Schema Migrations/002 Migration Files.mp4 30.2 MB
  • 25 - Advanced Query Tuning/004 Startup vs Total Costs.mp4 30.1 MB
  • 31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations.mp4 29.9 MB
  • 09 - Assembling Queries with SubQueries/006 Subqueries in a From.mp4 29.7 MB
  • 33 - Accessing PostgreSQL From API's/006 Validating Connection Credentials.mp4 29.3 MB
  • 09 - Assembling Queries with SubQueries/022 More on Correlated Subqueries.mp4 29.2 MB
  • 09 - Assembling Queries with SubQueries/013 Data Structure with Where Subqueries.mp4 29.0 MB
  • 04 - Relating Records with Joins/003 Joining Data from Different Tables.mp4 28.7 MB
  • 27 - Recursive Common Table Expressions/003 Why Use Recursive CTE's_.mp4 28.6 MB
  • 24 - Basic Query Tuning/002 Explain and Explain Analyze.mp4 28.5 MB
  • 36 - Fast Parallel Testing/002 Assertions Around User Count.mp4 28.2 MB
  • 14 - Database-Side Validation and Constraints/006 Applying a Unique Constraint to One column.mp4 28.1 MB
  • 36 - Fast Parallel Testing/015 Test Helpers.mp4 27.7 MB
  • 03 - Working with Tables/003 One-to-Many and Many-to-One Relationships.mp4 27.5 MB
  • 03 - Working with Tables/013 Constraints Around Deletion.mp4 27.2 MB
  • 25 - Advanced Query Tuning/006 Use My Index_.mp4 27.2 MB
  • 20 - Implementing Database Design Patterns/006 Photo Tags and Caption Tags.mp4 27.0 MB
  • 35 - Security Around PostgreSQL/002 Handling SQL Injection with Prepared Statements.mp4 26.7 MB
  • 36 - Fast Parallel Testing/011 Routing Schema Access.mp4 25.9 MB
  • 03 - Working with Tables/009 Running Queries on Associated Data.mp4 25.7 MB
  • 20 - Implementing Database Design Patterns/003 Posts Creation.mp4 25.5 MB
  • 09 - Assembling Queries with SubQueries/017 A New Where Operator.mp4 25.4 MB
  • 05 - Aggregation of Records/011 Filtering Groups with Having.mp4 25.1 MB
  • 23 - A Look at Indexes for Performance/001 Full Table Scans.mp4 25.0 MB
  • 09 - Assembling Queries with SubQueries/012 More Useful - Subqueries with Where.mp4 25.0 MB
  • 27 - Recursive Common Table Expressions/004 Writing the Query.mp4 24.7 MB
  • 21 - Approaching and Writing Complex Queries/28595573-ig.sql 24.7 MB
  • 09 - Assembling Queries with SubQueries/016 The Not In Operator with a List.mp4 24.6 MB
  • 04 - Relating Records with Joins/011 Each Join in Practice.mp4 24.6 MB
  • 36 - Fast Parallel Testing/007 Issues with Parallel Tests.mp4 23.9 MB
  • 22 - Understanding the Internals of PostgreSQL/002 Where Does Postgres Store Data_.mp4 23.7 MB
  • 29 - Optimizing Queries with Materialized Views/005 Creating and Refreshing Materialized Views.mp4 23.6 MB
  • 35 - Security Around PostgreSQL/003 Preventing SQL Injection.mp4 23.6 MB
  • 28 - Simplifying Queries with Views/002 A Possible Solution for Merging Tables.mp4 23.4 MB
  • 29 - Optimizing Queries with Materialized Views/002 Grouping by Week.mp4 23.2 MB
  • 12 - Local PostgreSQL Installation/002 PGAdmin Setup on macOS.mp4 23.1 MB
  • 01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About_.mp4 22.8 MB
  • 31 - Managing Database Design with Schema Migrations/004 A Few Notes on Migrations Libraries.mp4 22.7 MB
  • 28 - Simplifying Queries with Views/003 Creating a View.mp4 22.3 MB
  • 36 - Fast Parallel Testing/006 Assumptions Around Content.mp4 21.6 MB
  • 26 - Simple Common Table Expressions/003 So What's a CTE_.mp4 21.5 MB
  • 09 - Assembling Queries with SubQueries/018 Finally Some_.mp4 21.5 MB
  • 35 - Security Around PostgreSQL/001 SQL Injection Exploits.mp4 21.4 MB
  • 04 - Relating Records with Joins/015 Where with Join.mp4 21.2 MB
  • 30 - Handling Concurrency and Reversibility with Transactions/004 Transaction Cleanup on Crash.mp4 21.2 MB
  • 36 - Fast Parallel Testing/010 Controlling Schema Access with Search Paths.mp4 21.1 MB
  • 23 - A Look at Indexes for Performance/006 Downsides of Indexes.mp4 20.8 MB
  • 13 - PostgreSQL Complex Datatypes/002 Data Types.mp4 20.7 MB
  • 36 - Fast Parallel Testing/016 Cleaning up Schemas and Roles.mp4 20.4 MB
  • 09 - Assembling Queries with SubQueries/001 What's a Subquery_.mp4 20.4 MB
  • 15 - Database Structure Design Patterns/003 A Config-based Schema Designer.mp4 20.2 MB
  • 13 - PostgreSQL Complex Datatypes/005 Reminder on Character Types.mp4 20.1 MB
  • 04 - Relating Records with Joins/008 Missing Data in Joins.mp4 20.0 MB
  • 11 - Utility Operators, Keywords, and Functions/003 The Case Keyword.mp4 20.0 MB
  • 03 - Working with Tables/005 Primary Keys and Foreign Keys.mp4 19.7 MB
  • 33 - Accessing PostgreSQL From API's/004 Building the Users Router.mp4 19.5 MB
  • 01 - Simple - But Powerful - SQL Statements/005 Creating Tables.mp4 19.5 MB
  • 05 - Aggregation of Records/013 More on Having_.mp4 19.5 MB
  • 14 - Database-Side Validation and Constraints/002 Creating and Viewing Tables in PGAdmin.mp4 19.5 MB
  • 14 - Database-Side Validation and Constraints/007 Multi-Column Uniqueness.mp4 19.3 MB
  • 36 - Fast Parallel Testing/008 Isolation with Schemas.mp4 18.9 MB
  • 04 - Relating Records with Joins/002 Queries with Joins and Aggregations.mp4 18.6 MB
  • 16 - How to Build a 'Like' System/007 The Simplest Alternative.mp4 18.2 MB
  • 19 - How to Design a 'Follower' System/001 Designing a Follower System.mp4 18.0 MB
  • 03 - Working with Tables/012 Foreign Key Constraints Around Insertion.mp4 17.7 MB
  • 18 - How to Build a 'Hashtag' System/004 A Few More User Columns.mp4 17.7 MB
  • 16 - How to Build a 'Like' System/003 Designing a Like System.mp4 17.6 MB
  • 34 - Data Access Pattern - Repositories/002 Creating a Repository.mp4 17.5 MB
  • 28 - Simplifying Queries with Views/001 Most Popular Users.mp4 17.4 MB
  • 14 - Database-Side Validation and Constraints/001 Thinking About Validation.mp4 17.3 MB
  • 16 - How to Build a 'Like' System/001 Requirements of a Like System.mp4 17.0 MB
  • 24 - Basic Query Tuning/001 The Query Processing Pipeline.mp4 16.9 MB
  • 33 - Accessing PostgreSQL From API's/005 Understanding Connection Pools.mp4 16.8 MB
  • 36 - Fast Parallel Testing/014 Escaping Identifiers.mp4 16.7 MB
  • 20 - Implementing Database Design Patterns/005 Likes Creation.mp4 16.6 MB
  • 33 - Accessing PostgreSQL From API's/003 One Fast Migration.mp4 16.4 MB
  • 30 - Handling Concurrency and Reversibility with Transactions/001 What are Transactions Used For_.mp4 16.2 MB
  • 03 - Working with Tables/004 One-to-One and Many-to-Many Relationships.mp4 16.0 MB
  • 09 - Assembling Queries with SubQueries/002 Thinking About the Structure of Data.mp4 15.9 MB
  • 22 - Understanding the Internals of PostgreSQL/003 Heaps, Blocks, and Tuples.mp4 15.9 MB
  • 09 - Assembling Queries with SubQueries/003 Subqueries in a Select.mp4 15.9 MB
  • 04 - Relating Records with Joins/009 Why Wasn't It Included.mp4 15.7 MB
  • 17 - How to Build a 'Mention' System/005 Update For Tags.mp4 15.7 MB
  • 23 - A Look at Indexes for Performance/005 Benchmarking Queries.mp4 15.7 MB
  • 34 - Data Access Pattern - Repositories/003 Accessing the API.mp4 15.4 MB
  • 03 - Working with Tables/007 Auto-Generated ID's.mp4 15.3 MB
  • 14 - Database-Side Validation and Constraints/010 So Where Are We Applying Validation_.mp4 15.2 MB
  • 04 - Relating Records with Joins/007 Alternate Forms of Syntax.mp4 15.1 MB
  • 32 - Schema vs Data Migrations/004 Creating a Posts Table.mp4 15.1 MB
  • 14 - Database-Side Validation and Constraints/005 Default Column Values.mp4 15.0 MB
  • 13 - PostgreSQL Complex Datatypes/007 Times, Dates, and Timestamps.mp4 15.0 MB
  • 32 - Schema vs Data Migrations/007 Adding the Loc Column.mp4 14.9 MB
  • 03 - Working with Tables/015 Testing Deletion Constraints.mp4 14.9 MB
  • 36 - Fast Parallel Testing/005 Multi-DB Setup.mp4 14.8 MB
  • 12 - Local PostgreSQL Installation/001 PostgreSQL Installation on macOS.mp4 14.8 MB
  • 15 - Database Structure Design Patterns/005 Rebuilding Some Schema.mp4 14.8 MB
  • 14 - Database-Side Validation and Constraints/003 Applying a Null Constraint.mp4 14.8 MB
  • 21 - Approaching and Writing Complex Queries/003 Restoring from Scratch.mp4 14.5 MB
  • 12 - Local PostgreSQL Installation/003 Postgres installation on Windows.mp4 14.4 MB
  • 08 - Unions and Intersections with Sets/004 Removing Commonalities with Except.mp4 14.3 MB
  • 20 - Implementing Database Design Patterns/007 Creating Hashtags, Hashtag Posts, and Followers.mp4 14.3 MB
  • 32 - Schema vs Data Migrations/003 Properly Running Data and Schema Migrations.mp4 14.3 MB
  • 13 - PostgreSQL Complex Datatypes/008 Really Awesome Intervals.mp4 14.1 MB
  • 32 - Schema vs Data Migrations/001 Schema vs Data Migrations.mp4 14.1 MB
  • 07 - Sorting Records/003 Offset and Limit.mp4 13.8 MB
  • 28 - Simplifying Queries with Views/004 When to Use a View_.mp4 13.7 MB
  • 08 - Unions and Intersections with Sets/001 Handling Sets with Union.mp4 13.6 MB
  • 36 - Fast Parallel Testing/009 Creating and Accessing Schemas.mp4 13.4 MB
  • 23 - A Look at Indexes for Performance/008 Automatically Generated Indexes.mp4 13.4 MB
  • 02 - Filtering Records/003 Compound _Where_ Clauses.mp4 13.4 MB
  • 13 - PostgreSQL Complex Datatypes/001 What'd We Just Do_.mp4 13.0 MB
  • 01 - Simple - But Powerful - SQL Statements/007 Inserting Data Into a Table.mp4 12.7 MB
  • 03 - Working with Tables/008 Creating Foreign Key Columns.mp4 12.6 MB
  • 34 - Data Access Pattern - Repositories/006 Finding Particular Users.mp4 12.6 MB
  • 34 - Data Access Pattern - Repositories/004 Casing Issues.mp4 12.6 MB
  • 13 - PostgreSQL Complex Datatypes/003 Fast Rules on Numeric Data Types.mp4 12.5 MB
  • 22 - Understanding the Internals of PostgreSQL/004 Block Data Layout.mp4 12.3 MB
  • 14 - Database-Side Validation and Constraints/008 Adding a Validation Check.mp4 12.3 MB
  • 02 - Filtering Records/010 Updating Rows.mp4 12.3 MB
  • 34 - Data Access Pattern - Repositories/001 The Repository Pattern.mp4 12.3 MB
  • 36 - Fast Parallel Testing/012 Strategy for Isolation.mp4 12.2 MB
  • 36 - Fast Parallel Testing/017 Finally... Parallel Tests_.mp4 12.2 MB
  • 18 - How to Build a 'Hashtag' System/003 Including the Hashtag Table.mp4 12.1 MB
  • 14 - Database-Side Validation and Constraints/009 Checks Over Multiple Columns.mp4 12.1 MB
  • 04 - Relating Records with Joins/017 A Bit of Practice.mp4 12.1 MB
  • 35 - Security Around PostgreSQL/007 And, Finally, Delete.mp4 12.1 MB
  • 01 - Simple - But Powerful - SQL Statements/006 Analyzing CREATE TABLE.mp4 11.9 MB
  • 01 - Simple - But Powerful - SQL Statements/012 String Operators and Functions.mp4 11.9 MB
  • 09 - Assembling Queries with SubQueries/011 Subqueries in a Join Clause.mp4 11.4 MB
  • 21 - Approaching and Writing Complex Queries/002 Adding Some Data.mp4 11.4 MB
  • 08 - Unions and Intersections with Sets/002 A Few Notes on Union.mp4 11.3 MB
  • 31 - Managing Database Design with Schema Migrations/009 Generating and Applying a Second Migration.mp4 11.3 MB
  • 35 - Security Around PostgreSQL/006 Handling Updates.mp4 11.3 MB
  • 32 - Schema vs Data Migrations/008 Writing Values to Both Columns.mp4 11.2 MB
  • 29 - Optimizing Queries with Materialized Views/003 Reminder on Left Joins.mp4 11.0 MB
  • 16 - How to Build a 'Like' System/008 So Which Approach_.mp4 11.0 MB
  • 18 - How to Build a 'Hashtag' System/005 Why No Number of Followers or Posts_.mp4 10.9 MB
  • 01 - Simple - But Powerful - SQL Statements/009 Calculated Columns.mp4 10.9 MB
  • 16 - How to Build a 'Like' System/002 How Not to Design a Like System.mp4 10.8 MB
  • 05 - Aggregation of Records/004 Combining Group By and Aggregates.mp4 10.7 MB
  • 04 - Relating Records with Joins/014 Two Possible Solutions.mp4 10.7 MB
  • 08 - Unions and Intersections with Sets/003 Commonalities with Intersect.mp4 10.6 MB
  • 32 - Schema vs Data Migrations/010 Updating Values.mp4 10.6 MB
  • 18 - How to Build a 'Hashtag' System/002 Tables for Hashtags.mp4 10.5 MB
  • 35 - Security Around PostgreSQL/005 Inserting Users.mp4 10.5 MB
  • 35 - Security Around PostgreSQL/004 Reminder on Post Requests.mp4 9.7 MB
  • 02 - Filtering Records/011 Deleting Rows.mp4 9.6 MB
  • 14 - Database-Side Validation and Constraints/004 Solving a Gotcha with Null Constraints.mp4 9.5 MB
  • 23 - A Look at Indexes for Performance/004 Creating an Index.mp4 9.3 MB
  • 32 - Schema vs Data Migrations/012 Updating the App Server.mp4 9.2 MB
  • 26 - Simple Common Table Expressions/002 A Quick Solution.mp4 9.1 MB
  • 10 - Selecting Distinct Records/001 Selecting Distinct Values.mp4 8.8 MB
  • 02 - Filtering Records/001 Filtering Rows with _Where_.mp4 8.8 MB
  • 05 - Aggregation of Records/014 A Having Exercise Overview.mp4 8.8 MB
  • 03 - Working with Tables/016 Setting Foreign Keys to Null on Delete.mp4 8.7 MB
  • 36 - Fast Parallel Testing/004 Disconnecting After Tests.mp4 8.6 MB
  • 28 - Simplifying Queries with Views/005 Deleting and Changing Views.mp4 8.3 MB
  • 11 - Utility Operators, Keywords, and Functions/001 The Greatest Value in a List.mp4 8.2 MB
  • 27 - Recursive Common Table Expressions/001 Recursive CTE's.mp4 8.2 MB
  • 01 - Simple - But Powerful - SQL Statements/37099256-diagrams.zip 8.1 MB
  • 15 - Database Structure Design Patterns/001 Approaching More Complicated Designs.mp4 8.0 MB
  • 05 - Aggregation of Records/003 Aggregate Functions.mp4 8.0 MB
  • 32 - Schema vs Data Migrations/013 Dropping the Last Columns.mp4 7.9 MB
  • 03 - Working with Tables/001 The Plan Moving Forward.mp4 7.4 MB
  • 26 - Simple Common Table Expressions/001 Common Table Expressions.mp4 7.3 MB
  • 03 - Working with Tables/017 Adding Some Complexity.mp4 7.1 MB
  • 05 - Aggregation of Records/006 Visualizing More Grouping.mp4 7.0 MB
  • 31 - Managing Database Design with Schema Migrations/003 Issues Solved by Migrations.mp4 7.0 MB
  • 09 - Assembling Queries with SubQueries/010 Exercise Solution.mp4 6.9 MB
  • 22 - Understanding the Internals of PostgreSQL/001 Thinking About Performance.mp4 6.8 MB
  • 09 - Assembling Queries with SubQueries/023 A Select Without a From_.mp4 6.8 MB
  • 25 - Advanced Query Tuning/005 Costs Flow Up.mp4 6.7 MB
  • 23 - A Look at Indexes for Performance/002 What's an Index.mp4 6.7 MB
  • 07 - Sorting Records/002 Two Variations on Sorting.mp4 6.6 MB
  • 31 - Managing Database Design with Schema Migrations/006 Project Creation.mp4 6.5 MB
  • 09 - Assembling Queries with SubQueries/007 From Subqueries that Return a Value.mp4 6.4 MB
  • 02 - Filtering Records/002 More on the _Where_ Keyword.mp4 6.3 MB
  • 06 - Working with Large Datasets/005 Remember Joins_.mp4 6.3 MB
  • 15 - Database Structure Design Patterns/004 Here's the Plan.mp4 6.2 MB
  • 21 - Approaching and Writing Complex Queries/007 Solving for Posts by User.mp4 6.1 MB
  • 04 - Relating Records with Joins/004 Another Quick Join.mp4 5.9 MB
  • 29 - Optimizing Queries with Materialized Views/001 Materialized Views.mp4 5.9 MB
  • 04 - Relating Records with Joins/018 Exercise Solution.mp4 5.7 MB
  • 13 - PostgreSQL Complex Datatypes/006 Boolean Data Types.mp4 5.7 MB
  • 06 - Working with Large Datasets/002 Investigating This Dataset.mp4 5.7 MB
  • 03 - Working with Tables/011 Foreign Key Creation Solution.mp4 5.7 MB
  • 36 - Fast Parallel Testing/001 A Note on Testing.mp4 5.6 MB
  • 17 - How to Build a 'Mention' System/002 Adding Captions and Locations.mp4 5.6 MB
  • 05 - Aggregation of Records/001 Aggregating and Grouping.mp4 5.6 MB
  • 03 - Working with Tables/010 Exercise Overview.mp4 5.6 MB
  • 06 - Working with Large Datasets/004 Group By Review Solution.mp4 5.6 MB
  • 05 - Aggregation of Records/015 A Quick Solution.mp4 5.4 MB
  • 20 - Implementing Database Design Patterns/004 Comments Creation.mp4 5.2 MB
  • 30 - Handling Concurrency and Reversibility with Transactions/005 Closing Aborted Transactions.mp4 5.1 MB
  • 21 - Approaching and Writing Complex Queries/004 Highest User ID's Exercise.mp4 5.0 MB
  • 05 - Aggregation of Records/012 Having In Action.mp4 4.9 MB
  • 07 - Sorting Records/001 The Basics of Sorting.mp4 4.9 MB
  • 09 - Assembling Queries with SubQueries/015 Exercise Solution.mp4 4.7 MB
  • 20 - Implementing Database Design Patterns/001 Back to Postgres.mp4 4.6 MB
  • 21 - Approaching and Writing Complex Queries/009 Solution for Likes Per User.mp4 4.6 MB
  • 02 - Filtering Records/009 Solving Calculations.mp4 4.4 MB
  • 16 - How to Build a 'Like' System/004 Making a Reaction System Instead.mp4 4.3 MB
  • 23 - A Look at Indexes for Performance/007 Index Types.mp4 4.3 MB
  • 01 - Simple - But Powerful - SQL Statements/008 Retrieving Data with Select.mp4 4.2 MB
  • 05 - Aggregation of Records/005 A Gotcha with Count.mp4 4.2 MB
  • 30 - Handling Concurrency and Reversibility with Transactions/002 Some Sample Data.mp4 4.0 MB
  • 11 - Utility Operators, Keywords, and Functions/002 And the Least Value in a List_.mp4 3.9 MB
  • 02 - Filtering Records/007 A _Where_ With Lists Solution.mp4 3.7 MB
  • 04 - Relating Records with Joins/006 A Joinful Solution.mp4 3.6 MB
  • 02 - Filtering Records/012 A Solution for Updating Rows.mp4 3.6 MB
  • 02 - Filtering Records/008 Calculations in _Where_ Clauses.mp4 3.6 MB
  • 08 - Unions and Intersections with Sets/006 Exercise Solution.mp4 3.4 MB
  • 04 - Relating Records with Joins/005 Exercise Overview.mp4 3.2 MB
  • 09 - Assembling Queries with SubQueries/020 A Quick Solution.mp4 3.2 MB
  • 06 - Working with Large Datasets/006 Of Course You Remember_.mp4 3.2 MB
  • 21 - Approaching and Writing Complex Queries/005 Solution for User ID's.mp4 3.1 MB
  • 21 - Approaching and Writing Complex Queries/006 Posts by a Particular User.mp4 3.1 MB
  • 08 - Unions and Intersections with Sets/005 Union Exercise Overview.mp4 3.1 MB
  • 02 - Filtering Records/013 Solution for Deleting Rows.mp4 2.9 MB
  • 09 - Assembling Queries with SubQueries/005 Select Solution.mp4 2.8 MB
  • 05 - Aggregation of Records/010 Solution.mp4 2.7 MB
  • 09 - Assembling Queries with SubQueries/025 Exercise Solution.mp4 2.6 MB
  • 07 - Sorting Records/005 Exercise Solution.mp4 2.5 MB
  • 09 - Assembling Queries with SubQueries/009 Exercise Overview.mp4 2.5 MB
  • 21 - Approaching and Writing Complex Queries/008 Likes Per User.mp4 2.4 MB
  • 05 - Aggregation of Records/008 Grouping Solution.mp4 2.3 MB
  • 01 - Simple - But Powerful - SQL Statements/010 Calculating Phone Revenue.mp4 2.3 MB
  • 01 - Simple - But Powerful - SQL Statements/011 Exercise Solution.mp4 2.3 MB
  • 09 - Assembling Queries with SubQueries/004 Exercise Overview.mp4 2.2 MB
  • 06 - Working with Large Datasets/003 Some Group By Practice.mp4 2.2 MB
  • 33 - Accessing PostgreSQL From API's/001 Section Goal.mp4 2.1 MB
  • 09 - Assembling Queries with SubQueries/014 Exercise Overview.mp4 2.0 MB
  • 02 - Filtering Records/005 A _Where_ Solution.mp4 2.0 MB
  • 33 - Accessing PostgreSQL From API's/002 Initial Setup.mp4 1.8 MB
  • 04 - Relating Records with Joins/013 Exercise Overview.mp4 1.6 MB
  • 09 - Assembling Queries with SubQueries/024 Exercise Overview.mp4 1.4 MB
  • 10 - Selecting Distinct Records/003 A Distinct Solution.mp4 1.4 MB
  • 02 - Filtering Records/004 A _Where_ Exercise Overview.mp4 1.3 MB
  • 05 - Aggregation of Records/009 Adding a Layer of Difficulty.mp4 1.2 MB
  • 05 - Aggregation of Records/007 Exercise Overview.mp4 1.2 MB
  • 02 - Filtering Records/006 _Where_ With Lists.mp4 1.2 MB
  • 10 - Selecting Distinct Records/002 Exercise Overview.mp4 984.2 kB
  • 09 - Assembling Queries with SubQueries/019 Exercise Overview.mp4 874.2 kB
  • 07 - Sorting Records/004 Exercise Overview.mp4 830.6 kB
  • 04 - Relating Records with Joins/28571441-009-joins-cheatsheet.pdf 195.1 kB
  • 36 - Fast Parallel Testing/28571893-037-access.zip 68.2 kB
  • 36 - Fast Parallel Testing/28571901-038-access.zip 68.2 kB
  • 36 - Fast Parallel Testing/28571943-036-access.zip 68.1 kB
  • 36 - Fast Parallel Testing/28571955-035-access.zip 67.7 kB
  • 36 - Fast Parallel Testing/28571899-034-access.zip 67.7 kB
  • 36 - Fast Parallel Testing/28571937-028-access.zip 67.3 kB
  • 36 - Fast Parallel Testing/28571903-027-access.zip 66.1 kB
  • 36 - Fast Parallel Testing/28572037-026-access.zip 66.1 kB
  • 36 - Fast Parallel Testing/28571925-025-access.zip 66.1 kB
  • 36 - Fast Parallel Testing/28571917-024-access.zip 66.0 kB
  • 35 - Security Around PostgreSQL/28571907-021-access.zip 65.2 kB
  • 35 - Security Around PostgreSQL/28571915-019-access.zip 65.1 kB
  • 34 - Data Access Pattern - Repositories/28571891-010-access.zip 64.1 kB
  • 33 - Accessing PostgreSQL From API's/28571947-008-access.zip 63.5 kB
  • 33 - Accessing PostgreSQL From API's/28571973-005-access-social-repo.zip 62.8 kB
  • 22 - Understanding the Internals of PostgreSQL/005 Heap File Layout__en.srt 49.5 kB
  • 23 - A Look at Indexes for Performance/009 Behind the Scenes of Indexes__en.srt 48.7 kB
  • 31 - Managing Database Design with Schema Migrations/001 A Story on Migrations__en.srt 27.8 kB
  • 09 - Assembling Queries with SubQueries/021 Probably Too Much About Correlated Subqueries__en.srt 25.2 kB
  • 32 - Schema vs Data Migrations/009 Transaction Locks__en.srt 22.2 kB
  • 20 - Implementing Database Design Patterns/002 Creating Tables with Checks__en.srt 20.9 kB
  • 32 - Schema vs Data Migrations/005 A Small Web Server__en.srt 20.9 kB
  • 25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost__en.srt 20.4 kB
  • 06 - Working with Large Datasets/001 A New Dataset.html 18.3 kB
  • 36 - Fast Parallel Testing/013 Programmatic Schema Creation__en.srt 18.1 kB
  • 06 - Working with Large Datasets/28595541-001-sq-data.sql 16.2 kB
  • 27 - Recursive Common Table Expressions/002 Recursive CTE's Step by Step__en.srt 15.5 kB
  • 30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions__en.srt 15.1 kB
  • 27 - Recursive Common Table Expressions/005 Walking Through Recursion__en.srt 14.9 kB
  • 04 - Relating Records with Joins/010 Four Kinds of Joins__en.srt 14.7 kB
  • 13 - PostgreSQL Complex Datatypes/004 More on Number Data Types__en.srt 14.7 kB
  • 32 - Schema vs Data Migrations/002 Dangers Around Data Migrations__en.srt 14.5 kB
  • 24 - Basic Query Tuning/003 Solving an Explain Mystery__en.srt 14.0 kB
  • 29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query__en.srt 13.9 kB
  • 09 - Assembling Queries with SubQueries/008 Example of a Subquery in a From__en.srt 13.7 kB
  • 09 - Assembling Queries with SubQueries/012 More Useful - Subqueries with Where__en.srt 13.6 kB
  • 09 - Assembling Queries with SubQueries/022 More on Correlated Subqueries__en.srt 13.1 kB
  • 03 - Working with Tables/006 Understanding Foreign Keys__en.srt 12.9 kB
  • 35 - Security Around PostgreSQL/002 Handling SQL Injection with Prepared Statements__en.srt 12.8 kB
  • 25 - Advanced Query Tuning/006 Use My Index___en.srt 12.7 kB
  • 20 - Implementing Database Design Patterns/003 Posts Creation__en.srt 12.7 kB
  • 17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions__en.srt 12.6 kB
  • 34 - Data Access Pattern - Repositories/002 Creating a Repository__en.srt 12.6 kB
  • 23 - A Look at Indexes for Performance/003 How an Index Works__en.srt 12.3 kB
  • 04 - Relating Records with Joins/016 Three Way Joins__en.srt 12.2 kB
  • 03 - Working with Tables/002 Approaching Database Design__en.srt 12.0 kB
  • 09 - Assembling Queries with SubQueries/006 Subqueries in a From__en.srt 12.0 kB
  • 18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System__en.srt 11.9 kB
  • 27 - Recursive Common Table Expressions/004 Writing the Query__en.srt 11.9 kB
  • 04 - Relating Records with Joins/003 Joining Data from Different Tables__en.srt 11.8 kB
  • 15 - Database Structure Design Patterns/003 A Config-based Schema Designer__en.srt 11.8 kB
  • 17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags__en.srt 11.6 kB
  • 35 - Security Around PostgreSQL/003 Preventing SQL Injection__en.srt 11.5 kB
  • 14 - Database-Side Validation and Constraints/002 Creating and Viewing Tables in PGAdmin__en.srt 11.5 kB
  • 25 - Advanced Query Tuning/003 A Touch More on Costs__en.srt 11.4 kB
  • 31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations__en.srt 11.2 kB
  • 16 - How to Build a 'Like' System/006 Polymorphic Association Alternative Implementation__en.srt 10.9 kB
  • 35 - Security Around PostgreSQL/001 SQL Injection Exploits__en.srt 10.8 kB
  • 33 - Accessing PostgreSQL From API's/006 Validating Connection Credentials__en.srt 10.6 kB
  • 33 - Accessing PostgreSQL From API's/005 Understanding Connection Pools__en.srt 10.6 kB
  • 15 - Database Structure Design Patterns/005 Rebuilding Some Schema__en.srt 10.6 kB
  • 36 - Fast Parallel Testing/002 Assertions Around User Count__en.srt 10.6 kB
  • 31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations__en.srt 10.4 kB
  • 05 - Aggregation of Records/013 More on Having___en.srt 10.4 kB
  • 03 - Working with Tables/009 Running Queries on Associated Data__en.srt 10.3 kB
  • 04 - Relating Records with Joins/015 Where with Join__en.srt 10.3 kB
  • 14 - Database-Side Validation and Constraints/003 Applying a Null Constraint__en.srt 10.2 kB
  • 03 - Working with Tables/003 One-to-Many and Many-to-One Relationships__en.srt 10.1 kB
  • 25 - Advanced Query Tuning/002 Calculating Cost by Hand__en.srt 10.1 kB
  • 17 - How to Build a 'Mention' System/001 Additional Features Around Posts__en.srt 10.0 kB
  • 20 - Implementing Database Design Patterns/005 Likes Creation__en.srt 10.0 kB
  • 12 - Local PostgreSQL Installation/001 PostgreSQL Installation on macOS__en.srt 9.9 kB
  • 15 - Database Structure Design Patterns/002 Using a SQL Design Tool__en.srt 9.9 kB
  • 14 - Database-Side Validation and Constraints/010 So Where Are We Applying Validation___en.srt 9.9 kB
  • 01 - Simple - But Powerful - SQL Statements/012 String Operators and Functions__en.srt 9.9 kB
  • 28 - Simplifying Queries with Views/001 Most Popular Users__en.srt 9.8 kB
  • 18 - How to Build a 'Hashtag' System/004 A Few More User Columns__en.srt 9.8 kB
  • 04 - Relating Records with Joins/008 Missing Data in Joins__en.srt 9.8 kB
  • 09 - Assembling Queries with SubQueries/017 A New Where Operator__en.srt 9.6 kB
  • 16 - How to Build a 'Like' System/005 Polymorphic Associations__en.srt 9.6 kB
  • 34 - Data Access Pattern - Repositories/005 Fixing Casing__en.srt 9.5 kB
  • 08 - Unions and Intersections with Sets/004 Removing Commonalities with Except__en.srt 9.4 kB
  • 04 - Relating Records with Joins/007 Alternate Forms of Syntax__en.srt 9.3 kB
  • 19 - How to Design a 'Follower' System/001 Designing a Follower System__en.srt 9.2 kB
  • 25 - Advanced Query Tuning/004 Startup vs Total Costs__en.srt 9.1 kB
  • 20 - Implementing Database Design Patterns/007 Creating Hashtags, Hashtag Posts, and Followers__en.srt 9.0 kB
  • 13 - PostgreSQL Complex Datatypes/008 Really Awesome Intervals__en.srt 9.0 kB
  • 09 - Assembling Queries with SubQueries/013 Data Structure with Where Subqueries__en.srt 8.9 kB
  • 03 - Working with Tables/007 Auto-Generated ID's__en.srt 8.9 kB
  • 09 - Assembling Queries with SubQueries/001 What's a Subquery___en.srt 8.9 kB
  • 32 - Schema vs Data Migrations/003 Properly Running Data and Schema Migrations__en.srt 8.8 kB
  • 14 - Database-Side Validation and Constraints/006 Applying a Unique Constraint to One column__en.srt 8.8 kB
  • 22 - Understanding the Internals of PostgreSQL/002 Where Does Postgres Store Data___en.srt 8.8 kB
  • 36 - Fast Parallel Testing/010 Controlling Schema Access with Search Paths__en.srt 8.8 kB
  • 08 - Unions and Intersections with Sets/001 Handling Sets with Union__en.srt 8.7 kB
  • 03 - Working with Tables/004 One-to-One and Many-to-Many Relationships__en.srt 8.7 kB
  • 03 - Working with Tables/012 Foreign Key Constraints Around Insertion__en.srt 8.7 kB
  • 09 - Assembling Queries with SubQueries/003 Subqueries in a Select__en.srt 8.5 kB
  • 23 - A Look at Indexes for Performance/005 Benchmarking Queries__en.srt 8.5 kB
  • 28 - Simplifying Queries with Views/003 Creating a View__en.srt 8.5 kB
  • 13 - PostgreSQL Complex Datatypes/007 Times, Dates, and Timestamps__en.srt 8.3 kB
  • 24 - Basic Query Tuning/002 Explain and Explain Analyze__en.srt 8.3 kB
  • 16 - How to Build a 'Like' System/003 Designing a Like System__en.srt 8.3 kB
  • 05 - Aggregation of Records/002 Picturing Group By__en.srt 8.2 kB
  • 20 - Implementing Database Design Patterns/006 Photo Tags and Caption Tags__en.srt 8.2 kB
  • 09 - Assembling Queries with SubQueries/018 Finally Some___en.srt 8.2 kB
  • 23 - A Look at Indexes for Performance/006 Downsides of Indexes__en.srt 8.2 kB
  • 36 - Fast Parallel Testing/006 Assumptions Around Content__en.srt 8.2 kB
  • 36 - Fast Parallel Testing/003 Connecting to a DB For Tests__en.srt 8.2 kB
  • 01 - Simple - But Powerful - SQL Statements/004 Database Design__en.srt 8.2 kB
  • 34 - Data Access Pattern - Repositories/006 Finding Particular Users__en.srt 8.2 kB
  • 36 - Fast Parallel Testing/016 Cleaning up Schemas and Roles__en.srt 8.2 kB
  • 24 - Basic Query Tuning/001 The Query Processing Pipeline__en.srt 8.1 kB
  • 36 - Fast Parallel Testing/009 Creating and Accessing Schemas__en.srt 8.0 kB
  • 36 - Fast Parallel Testing/015 Test Helpers__en.srt 7.9 kB
  • 36 - Fast Parallel Testing/007 Issues with Parallel Tests__en.srt 7.9 kB
  • 03 - Working with Tables/005 Primary Keys and Foreign Keys__en.srt 7.9 kB
  • 04 - Relating Records with Joins/001 Adding Some Data.html 7.8 kB
  • 31 - Managing Database Design with Schema Migrations/004 A Few Notes on Migrations Libraries__en.srt 7.8 kB
  • 04 - Relating Records with Joins/28595535-010-sql-cumulative.sql 7.8 kB
  • 05 - Aggregation of Records/011 Filtering Groups with Having__en.srt 7.7 kB
  • 04 - Relating Records with Joins/28595533-007-joins-cumulative.sql 7.7 kB
  • 12 - Local PostgreSQL Installation/002 PGAdmin Setup on macOS__en.srt 7.7 kB
  • 16 - How to Build a 'Like' System/001 Requirements of a Like System__en.srt 7.7 kB
  • 01 - Simple - But Powerful - SQL Statements/005 Creating Tables__en.srt 7.7 kB
  • 04 - Relating Records with Joins/017 A Bit of Practice__en.srt 7.6 kB
  • 03 - Working with Tables/013 Constraints Around Deletion__en.srt 7.6 kB
  • 14 - Database-Side Validation and Constraints/009 Checks Over Multiple Columns__en.srt 7.6 kB
  • 02 - Filtering Records/003 Compound _Where_ Clauses__en.srt 7.6 kB
  • 01 - Simple - But Powerful - SQL Statements/007 Inserting Data Into a Table__en.srt 7.6 kB
  • 09 - Assembling Queries with SubQueries/002 Thinking About the Structure of Data__en.srt 7.5 kB
  • 31 - Managing Database Design with Schema Migrations/002 Migration Files__en.srt 7.5 kB
  • 13 - PostgreSQL Complex Datatypes/005 Reminder on Character Types__en.srt 7.5 kB
  • 36 - Fast Parallel Testing/005 Multi-DB Setup__en.srt 7.5 kB
  • 03 - Working with Tables/008 Creating Foreign Key Columns__en.srt 7.4 kB
  • 01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About___en.srt 7.4 kB
  • 17 - How to Build a 'Mention' System/005 Update For Tags__en.srt 7.4 kB
  • 01 - Simple - But Powerful - SQL Statements/009 Calculated Columns__en.srt 7.3 kB
  • 33 - Accessing PostgreSQL From API's/003 One Fast Migration__en.srt 7.3 kB
  • 05 - Aggregation of Records/004 Combining Group By and Aggregates__en.srt 7.2 kB
  • 36 - Fast Parallel Testing/012 Strategy for Isolation__en.srt 7.2 kB
  • 13 - PostgreSQL Complex Datatypes/002 Data Types__en.srt 7.1 kB
  • 34 - Data Access Pattern - Repositories/004 Casing Issues__en.srt 7.0 kB
  • 16 - How to Build a 'Like' System/008 So Which Approach___en.srt 7.0 kB
  • 21 - Approaching and Writing Complex Queries/003 Restoring from Scratch__en.srt 7.0 kB
  • 22 - Understanding the Internals of PostgreSQL/004 Block Data Layout__en.srt 6.9 kB
  • 29 - Optimizing Queries with Materialized Views/003 Reminder on Left Joins__en.srt 6.9 kB
  • 32 - Schema vs Data Migrations/004 Creating a Posts Table__en.srt 6.8 kB
  • 14 - Database-Side Validation and Constraints/001 Thinking About Validation__en.srt 6.8 kB
  • 09 - Assembling Queries with SubQueries/011 Subqueries in a Join Clause__en.srt 6.8 kB
  • 35 - Security Around PostgreSQL/006 Handling Updates__en.srt 6.8 kB
  • 33 - Accessing PostgreSQL From API's/004 Building the Users Router__en.srt 6.7 kB
  • 03 - Working with Tables/015 Testing Deletion Constraints__en.srt 6.7 kB
  • 11 - Utility Operators, Keywords, and Functions/003 The Case Keyword__en.srt 6.7 kB
  • 21 - Approaching and Writing Complex Queries/002 Adding Some Data__en.srt 6.6 kB
  • 36 - Fast Parallel Testing/011 Routing Schema Access__en.srt 6.6 kB
  • 32 - Schema vs Data Migrations/012 Updating the App Server__en.srt 6.6 kB
  • 12 - Local PostgreSQL Installation/003 Postgres installation on Windows__en.srt 6.6 kB
  • 36 - Fast Parallel Testing/008 Isolation with Schemas__en.srt 6.5 kB
  • 13 - PostgreSQL Complex Datatypes/001 What'd We Just Do___en.srt 6.5 kB
  • 23 - A Look at Indexes for Performance/001 Full Table Scans__en.srt 6.5 kB
  • 10 - Selecting Distinct Records/001 Selecting Distinct Values__en.srt 6.5 kB
  • 32 - Schema vs Data Migrations/008 Writing Values to Both Columns__en.srt 6.5 kB
  • 14 - Database-Side Validation and Constraints/004 Solving a Gotcha with Null Constraints__en.srt 6.5 kB
  • 02 - Filtering Records/010 Updating Rows__en.srt 6.4 kB
  • 09 - Assembling Queries with SubQueries/016 The Not In Operator with a List__en.srt 6.4 kB
  • 32 - Schema vs Data Migrations/010 Updating Values__en.srt 6.4 kB
  • 04 - Relating Records with Joins/012 Does Order Matter___en.srt 6.4 kB
  • 30 - Handling Concurrency and Reversibility with Transactions/001 What are Transactions Used For___en.srt 6.4 kB
  • 32 - Schema vs Data Migrations/001 Schema vs Data Migrations__en.srt 6.4 kB
  • 36 - Fast Parallel Testing/014 Escaping Identifiers__en.srt 6.4 kB
  • 29 - Optimizing Queries with Materialized Views/002 Grouping by Week__en.srt 6.4 kB
  • 35 - Security Around PostgreSQL/007 And, Finally, Delete__en.srt 6.3 kB
  • 04 - Relating Records with Joins/011 Each Join in Practice__en.srt 6.3 kB
  • 35 - Security Around PostgreSQL/005 Inserting Users__en.srt 6.3 kB
  • 23 - A Look at Indexes for Performance/004 Creating an Index__en.srt 6.2 kB
  • 28 - Simplifying Queries with Views/002 A Possible Solution for Merging Tables__en.srt 6.2 kB
  • 30 - Handling Concurrency and Reversibility with Transactions/004 Transaction Cleanup on Crash__en.srt 6.1 kB
  • 14 - Database-Side Validation and Constraints/008 Adding a Validation Check__en.srt 6.1 kB
  • 16 - How to Build a 'Like' System/007 The Simplest Alternative__en.srt 6.1 kB
  • 18 - How to Build a 'Hashtag' System/005 Why No Number of Followers or Posts___en.srt 6.0 kB
  • 32 - Schema vs Data Migrations/007 Adding the Loc Column__en.srt 6.0 kB
  • 18 - How to Build a 'Hashtag' System/003 Including the Hashtag Table__en.srt 5.9 kB
  • 18 - How to Build a 'Hashtag' System/002 Tables for Hashtags__en.srt 5.8 kB
  • 02 - Filtering Records/001 Filtering Rows with _Where___en.srt 5.8 kB
  • 26 - Simple Common Table Expressions/003 So What's a CTE___en.srt 5.8 kB
  • 22 - Understanding the Internals of PostgreSQL/003 Heaps, Blocks, and Tuples__en.srt 5.8 kB
  • 23 - A Look at Indexes for Performance/008 Automatically Generated Indexes__en.srt 5.7 kB
  • 34 - Data Access Pattern - Repositories/001 The Repository Pattern__en.srt 5.7 kB
  • 08 - Unions and Intersections with Sets/002 A Few Notes on Union__en.srt 5.7 kB
  • 26 - Simple Common Table Expressions/002 A Quick Solution__en.srt 5.6 kB
  • 01 - Simple - But Powerful - SQL Statements/006 Analyzing CREATE TABLE__en.srt 5.5 kB
  • 05 - Aggregation of Records/014 A Having Exercise Overview__en.srt 5.5 kB
  • 09 - Assembling Queries with SubQueries/023 A Select Without a From___en.srt 5.3 kB
  • 36 - Fast Parallel Testing/017 Finally... Parallel Tests___en.srt 5.3 kB
  • 14 - Database-Side Validation and Constraints/007 Multi-Column Uniqueness__en.srt 5.2 kB
  • 04 - Relating Records with Joins/002 Queries with Joins and Aggregations__en.srt 5.2 kB
  • 31 - Managing Database Design with Schema Migrations/009 Generating and Applying a Second Migration__en.srt 5.2 kB
  • 11 - Utility Operators, Keywords, and Functions/001 The Greatest Value in a List__en.srt 5.0 kB
  • 27 - Recursive Common Table Expressions/001 Recursive CTE's__en.srt 5.0 kB
  • 08 - Unions and Intersections with Sets/003 Commonalities with Intersect__en.srt 5.0 kB
  • 02 - Filtering Records/011 Deleting Rows__en.srt 5.0 kB
  • 28 - Simplifying Queries with Views/004 When to Use a View___en.srt 5.0 kB
  • 36 - Fast Parallel Testing/001 A Note on Testing__en.srt 5.0 kB
  • 16 - How to Build a 'Like' System/002 How Not to Design a Like System__en.srt 4.8 kB
  • 03 - Working with Tables/017 Adding Some Complexity__en.srt 4.8 kB
  • 04 - Relating Records with Joins/014 Two Possible Solutions__en.srt 4.7 kB
  • 36 - Fast Parallel Testing/004 Disconnecting After Tests__en.srt 4.6 kB
  • 05 - Aggregation of Records/006 Visualizing More Grouping__en.srt 4.6 kB
  • 05 - Aggregation of Records/003 Aggregate Functions__en.srt 4.5 kB
  • 31 - Managing Database Design with Schema Migrations/006 Project Creation__en.srt 4.5 kB
  • 31 - Managing Database Design with Schema Migrations/003 Issues Solved by Migrations__en.srt 4.5 kB
  • 03 - Working with Tables/016 Setting Foreign Keys to Null on Delete__en.srt 4.4 kB
  • 09 - Assembling Queries with SubQueries/007 From Subqueries that Return a Value__en.srt 4.3 kB
  • 15 - Database Structure Design Patterns/004 Here's the Plan__en.srt 4.2 kB
  • 37 - Bonus_/001 Bonus_.html 4.2 kB
  • 35 - Security Around PostgreSQL/004 Reminder on Post Requests__en.srt 4.2 kB
  • 05 - Aggregation of Records/005 A Gotcha with Count__en.srt 4.1 kB
  • 07 - Sorting Records/002 Two Variations on Sorting__en.srt 4.1 kB
  • 23 - A Look at Indexes for Performance/002 What's an Index__en.srt 4.0 kB
  • 04 - Relating Records with Joins/018 Exercise Solution__en.srt 4.0 kB
  • 05 - Aggregation of Records/012 Having In Action__en.srt 4.0 kB
  • 13 - PostgreSQL Complex Datatypes/006 Boolean Data Types__en.srt 3.9 kB
  • 29 - Optimizing Queries with Materialized Views/001 Materialized Views__en.srt 3.9 kB
  • 02 - Filtering Records/002 More on the _Where_ Keyword__en.srt 3.8 kB
  • 05 - Aggregation of Records/015 A Quick Solution__en.srt 3.8 kB
  • 04 - Relating Records with Joins/009 Why Wasn't It Included__en.srt 3.8 kB
  • 28 - Simplifying Queries with Views/005 Deleting and Changing Views__en.srt 3.7 kB
  • 22 - Understanding the Internals of PostgreSQL/001 Thinking About Performance__en.srt 3.7 kB
  • 07 - Sorting Records/001 The Basics of Sorting__en.srt 3.6 kB
  • 13 - PostgreSQL Complex Datatypes/003 Fast Rules on Numeric Data Types__en.srt 3.6 kB
  • 05 - Aggregation of Records/001 Aggregating and Grouping__en.srt 3.5 kB
  • 06 - Working with Large Datasets/005 Remember Joins___en.srt 3.5 kB
  • 06 - Working with Large Datasets/004 Group By Review Solution__en.srt 3.5 kB
  • 20 - Implementing Database Design Patterns/004 Comments Creation__en.srt 3.4 kB
  • 03 - Working with Tables/010 Exercise Overview__en.srt 3.4 kB
  • 01 - Simple - But Powerful - SQL Statements/008 Retrieving Data with Select__en.srt 3.3 kB
  • 20 - Implementing Database Design Patterns/001 Back to Postgres__en.srt 3.3 kB
  • 04 - Relating Records with Joins/004 Another Quick Join__en.srt 3.2 kB
  • 30 - Handling Concurrency and Reversibility with Transactions/002 Some Sample Data__en.srt 3.1 kB
  • 33 - Accessing PostgreSQL From API's/007 Query and Close__en.srt 3.1 kB
  • 25 - Advanced Query Tuning/005 Costs Flow Up__en.srt 3.1 kB
  • 21 - Approaching and Writing Complex Queries/004 Highest User ID's Exercise__en.srt 3.1 kB
  • 09 - Assembling Queries with SubQueries/015 Exercise Solution__en.srt 3.1 kB
  • 02 - Filtering Records/008 Calculations in _Where_ Clauses__en.srt 3.1 kB
  • 03 - Working with Tables/011 Foreign Key Creation Solution__en.srt 3.0 kB
  • 11 - Utility Operators, Keywords, and Functions/002 And the Least Value in a List___en.srt 3.0 kB
  • 26 - Simple Common Table Expressions/001 Common Table Expressions__en.srt 3.0 kB
  • 20 - Implementing Database Design Patterns/28595569-007-db.sql 2.9 kB
  • 21 - Approaching and Writing Complex Queries/007 Solving for Posts by User__en.srt 2.8 kB
  • 03 - Working with Tables/001 The Plan Moving Forward__en.srt 2.8 kB
  • 30 - Handling Concurrency and Reversibility with Transactions/005 Closing Aborted Transactions__en.srt 2.7 kB
  • 17 - How to Build a 'Mention' System/002 Adding Captions and Locations__en.srt 2.6 kB
  • 23 - A Look at Indexes for Performance/007 Index Types__en.srt 2.6 kB
  • 04 - Relating Records with Joins/006 A Joinful Solution__en.srt 2.6 kB
  • 16 - How to Build a 'Like' System/004 Making a Reaction System Instead__en.srt 2.5 kB
  • 21 - Approaching and Writing Complex Queries/009 Solution for Likes Per User__en.srt 2.5 kB
  • 09 - Assembling Queries with SubQueries/020 A Quick Solution__en.srt 2.4 kB
  • 02 - Filtering Records/007 A _Where_ With Lists Solution__en.srt 2.3 kB
  • 08 - Unions and Intersections with Sets/005 Union Exercise Overview__en.srt 2.2 kB
  • 20 - Implementing Database Design Patterns/28595567-006-db.sql 2.2 kB
  • 05 - Aggregation of Records/010 Solution__en.srt 2.2 kB
  • 02 - Filtering Records/012 A Solution for Updating Rows__en.srt 2.2 kB
  • 05 - Aggregation of Records/008 Grouping Solution__en.srt 2.2 kB
  • 06 - Working with Large Datasets/006 Of Course You Remember___en.srt 2.1 kB
  • 08 - Unions and Intersections with Sets/006 Exercise Solution__en.srt 2.1 kB
  • 07 - Sorting Records/005 Exercise Solution__en.srt 2.0 kB
  • 06 - Working with Large Datasets/003 Some Group By Practice__en.srt 2.0 kB
  • 02 - Filtering Records/013 Solution for Deleting Rows__en.srt 2.0 kB
  • 09 - Assembling Queries with SubQueries/009 Exercise Overview__en.srt 1.9 kB
  • 21 - Approaching and Writing Complex Queries/005 Solution for User ID's__en.srt 1.8 kB
  • 09 - Assembling Queries with SubQueries/005 Select Solution__en.srt 1.8 kB
  • 04 - Relating Records with Joins/005 Exercise Overview__en.srt 1.8 kB
  • 21 - Approaching and Writing Complex Queries/006 Posts by a Particular User__en.srt 1.8 kB
  • 09 - Assembling Queries with SubQueries/025 Exercise Solution__en.srt 1.7 kB
  • 09 - Assembling Queries with SubQueries/004 Exercise Overview__en.srt 1.7 kB
  • 01 - Simple - But Powerful - SQL Statements/011 Exercise Solution__en.srt 1.6 kB
  • 20 - Implementing Database Design Patterns/28595565-005-db.sql 1.6 kB
  • 01 - Simple - But Powerful - SQL Statements/010 Calculating Phone Revenue__en.srt 1.6 kB
  • 33 - Accessing PostgreSQL From API's/001 Section Goal__en.srt 1.5 kB
  • 04 - Relating Records with Joins/013 Exercise Overview__en.srt 1.5 kB
  • 02 - Filtering Records/005 A _Where_ Solution__en.srt 1.3 kB
  • 32 - Schema vs Data Migrations/28595583-005-index.js 1.3 kB
  • 03 - Working with Tables/28579191-015-tables-cumulative.sql 1.3 kB
  • 01 - Simple - But Powerful - SQL Statements/002 Course Resources.html 1.3 kB
  • 09 - Assembling Queries with SubQueries/024 Exercise Overview__en.srt 1.2 kB
  • 05 - Aggregation of Records/007 Exercise Overview__en.srt 1.1 kB
  • 20 - Implementing Database Design Patterns/28595563-004-db.sql 1.1 kB
  • 05 - Aggregation of Records/009 Adding a Layer of Difficulty__en.srt 1.1 kB
  • 02 - Filtering Records/006 _Where_ With Lists__en.srt 1.0 kB
  • 32 - Schema vs Data Migrations/006 Web Server Setup Instructions.html 1.0 kB
  • 03 - Working with Tables/28579187-014-tables-cumulative.sql 994 Bytes
  • 02 - Filtering Records/004 A _Where_ Exercise Overview__en.srt 962 Bytes
  • 10 - Selecting Distinct Records/003 A Distinct Solution__en.srt 931 Bytes
  • 32 - Schema vs Data Migrations/011 Migrations Setup Instructions.html 925 Bytes
  • 10 - Selecting Distinct Records/002 Exercise Overview__en.srt 876 Bytes
  • 20 - Implementing Database Design Patterns/28595561-003-db.sql 791 Bytes
  • 09 - Assembling Queries with SubQueries/019 Exercise Overview__en.srt 743 Bytes
  • 07 - Sorting Records/004 Exercise Overview__en.srt 692 Bytes
  • 03 - Working with Tables/014 Commands You8217ll Need for the Next Video.html 691 Bytes
  • 03 - Working with Tables/28579179-012-tables-cumulative.sql 600 Bytes
  • 03 - Working with Tables/28579161-009-tables-cumulative.sql 536 Bytes
  • 03 - Working with Tables/28579189-014-tables.sql 469 Bytes
  • 15 - Database Structure Design Patterns/28595545-005-design.dbml 455 Bytes
  • 01 - Simple - But Powerful - SQL Statements/28579131-012-sql.sql 404 Bytes
  • 01 - Simple - But Powerful - SQL Statements/28579125-005-sql-cumulative.sql 384 Bytes
  • 20 - Implementing Database Design Patterns/28595559-002-db.sql 375 Bytes
  • 32 - Schema vs Data Migrations/28595585-01-lng-lat-to-loc.js 364 Bytes
  • 03 - Working with Tables/28579157-008-tables-cumulative.sql 348 Bytes
  • 03 - Working with Tables/28579193-015-tables.sql 340 Bytes
  • 03 - Working with Tables/28579163-009-tables.sql 326 Bytes
  • 01 - Simple - But Powerful - SQL Statements/001 Join Our Community_.html 318 Bytes
  • 01 - Simple - But Powerful - SQL Statements/28579127-005-sql.sql 278 Bytes
  • 31 - Managing Database Design with Schema Migrations/005 A Note About Node Installation.html 264 Bytes
  • 21 - Approaching and Writing Complex Queries/001 Quick Note About Adding Some Data.html 251 Bytes
  • 03 - Working with Tables/28579183-012-tables.sql 199 Bytes
  • 03 - Working with Tables/28579159-008-tables.sql 197 Bytes
  • 03 - Working with Tables/28579155-007-tables.sql 194 Bytes
  • 03 - Working with Tables/28579153-007-tables-cumulative.sql 172 Bytes
  • 0. Websites you may like/[FCS Forum].url 133 Bytes
  • 0. Websites you may like/[FreeCourseSite.com].url 127 Bytes
  • 0. Websites you may like/[CourseClub.ME].url 122 Bytes
  • 01 - Simple - But Powerful - SQL Statements/28579121-003-sql.sql 104 Bytes
  • 0. Websites you may like/[GigaCourse.Com].url 49 Bytes
  • 02 - Filtering Records/28579133-013-sql.sql 48 Bytes

随机展示

相关说明

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