[GigaCourse.Com] Udemy - SQL and PostgreSQL The Complete Developer's Guide - 磁力狗

BT种子名称

请保存以下最新地址

BT种子基本信息

种子哈希：4d46c87cf3a71fa68b051d97072b597c955c7af2
文档大小：5.4 GB
文档个数：615个文档
下载次数：5267次
下载速度：极快
收录时间：2021-12-02
最近下载：2024-12-12
DMCA/屏蔽：DMCA/屏蔽

下载磁力链接

magnet:?xt=urn:btih:4D46C87CF3A71FA68B051D97072B597C955C7AF2
复制磁力链接到PikPak、utorrent、Bitcomet、迅雷、115、百度网盘等下载工具进行下载。

下载BT种子

磁力链接种子下载迅雷下载二维码 YouTube成人版 91视频 91短视频 51品茶逼哩逼哩萝莉岛欲漫涩草榴社区含羞草抖阴破解版 TikTok成人版成人快手乱伦社区 91AV 暗网禁地

[GigaCourse.Com] Udemy - SQL and PostgreSQL The Complete Developer's Guide的二维码

文档列表

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/[CourseClub.ME].url 122 Bytes
05 - Aggregation of Records/[CourseClub.Me].url 122 Bytes
15 - Database Structure Design Patterns/[CourseClub.Me].url 122 Bytes
24 - Basic Query Tuning/[CourseClub.Me].url 122 Bytes
34 - Data Access Pattern - Repositories/[CourseClub.Me].url 122 Bytes
[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
05 - Aggregation of Records/[GigaCourse.Com].url 49 Bytes
15 - Database Structure Design Patterns/[GigaCourse.Com].url 49 Bytes
24 - Basic Query Tuning/[GigaCourse.Com].url 49 Bytes
34 - Data Access Pattern - Repositories/[GigaCourse.Com].url 49 Bytes
[GigaCourse.Com].url 49 Bytes
02 - Filtering Records/28579133-013-sql.sql 48 Bytes

==查看完整文档列表==

下一个：[Anistar.org] Shi Ye Miao Yin - 11 [720p]_new.mp4 655.3 MB