Udemy - SQL and PostgreSQL The Complete Developer's Guide (7.2024)

Creation Time	Aug. 16, 2025, 5:55 p.m.
Last Access Time	Aug. 17, 2025, 3:32 p.m.
File Size	5.0 GB
Keywords	and PostgreSQL Complete - Udemy 2024 s 7 SQL The Guide Developer
Total Requests	7
Total Files	653
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

22 - Understanding the Internals of PostgreSQL/006 Heap File Layout.mp4 338.4 MB
23 - A Look at Indexes for Performance/010 Behind the Scenes of Indexes.mp4 238.3 MB
31 - Managing Database Design with Schema Migrations/001 A Story on Migrations.mp4 88.6 MB
04 - Relating Records with Joins/011 Four Kinds of Joins.mp4 75.2 MB
09 - Assembling Queries with SubQueries/027 Probably Too Much About Correlated Subqueries.mp4 66.9 MB
27 - Recursive Common Table Expressions/005 Walking Through Recursion.mp4 66.0 MB
25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost.mp4 64.6 MB
32 - Schema vs Data Migrations/009 Transaction Locks.mp4 62.6 MB
18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System.mp4 60.6 MB
25 - Advanced Query Tuning/003 A Touch More on Costs.mp4 55.3 MB
17 - How to Build a 'Mention' System/001 Additional Features Around Posts.mp4 54.0 MB
24 - Basic Query Tuning/004 Solving an Explain Mystery.mp4 49.1 MB
32 - Schema vs Data Migrations/002 Dangers Around Data Migrations.mp4 44.3 MB
17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions.mp4 44.2 MB
23 - A Look at Indexes for Performance/003 How an Index Works.mp4 43.2 MB
17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags.mp4 42.9 MB
30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions.mp4 42.1 MB
03 - Working with Tables/009 Understanding Foreign Keys.mp4 41.6 MB
36 - Fast Parallel Testing/013 Programmatic Schema Creation.mp4 41.2 MB
32 - Schema vs Data Migrations/005 A Small Web Server.mp4 40.7 MB
31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations.mp4 40.1 MB
20 - Implementing Database Design Patterns/002 Creating Tables with Checks.mp4 40.1 MB
27 - Recursive Common Table Expressions/002 Recursive CTE's Step by Step.mp4 40.1 MB
16 - How to Build a 'Like' System/007 Polymorphic Association Alternative Implementation.mp4 39.5 MB
04 - Relating Records with Joins/013 Does Order Matter.mp4 35.9 MB
01 - Simple - But Powerful - SQL Statements/004 Database Design.mp4 35.4 MB
29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query.mp4 35.1 MB
09 - Assembling Queries with SubQueries/010 Example of a Subquery in a From.mp4 34.4 MB
16 - How to Build a 'Like' System/006 Polymorphic Associations.mp4 33.4 MB
15 - Database Structure Design Patterns/002 Using a SQL Design Tool.mp4 32.4 MB
25 - Advanced Query Tuning/002 Calculating Cost by Hand.mp4 32.2 MB
04 - Relating Records with Joins/019 Three Way Joins.mp4 32.1 MB
36 - Fast Parallel Testing/003 Connecting to a DB For Tests.mp4 32.0 MB
13 - PostgreSQL Complex Datatypes/004 More on Number Data Types.mp4 30.5 MB
03 - Working with Tables/002 Approaching Database Design.mp4 30.5 MB
34 - Data Access Pattern - Repositories/005 Fixing Casing.mp4 30.3 MB
31 - Managing Database Design with Schema Migrations/002 Migration Files.mp4 28.8 MB
25 - Advanced Query Tuning/005 Startup vs Total Costs.mp4 28.7 MB
31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations.mp4 28.5 MB
09 - Assembling Queries with SubQueries/008 Subqueries in a From.mp4 28.3 MB
33 - Accessing PostgreSQL From API's/006 Validating Connection Credentials.mp4 27.9 MB
09 - Assembling Queries with SubQueries/028 More on Correlated Subqueries.mp4 27.9 MB
09 - Assembling Queries with SubQueries/016 Data Structure with Where Subqueries.mp4 27.7 MB
27 - Recursive Common Table Expressions/003 Why Use Recursive CTE's.mp4 27.3 MB
24 - Basic Query Tuning/002 Explain and Explain Analyze.mp4 27.2 MB
36 - Fast Parallel Testing/002 Assertions Around User Count.mp4 26.9 MB
14 - Database-Side Validation and Constraints/007 Applying a Unique Constraint to One column.mp4 26.8 MB
36 - Fast Parallel Testing/015 Test Helpers.mp4 26.4 MB
03 - Working with Tables/004 One-to-Many and Many-to-One Relationships.mp4 26.3 MB
03 - Working with Tables/018 Constraints Around Deletion.mp4 26.0 MB
25 - Advanced Query Tuning/007 Use My Index!.mp4 25.9 MB
20 - Implementing Database Design Patterns/006 Photo Tags and Caption Tags.mp4 25.7 MB
35 - Security Around PostgreSQL/002 Handling SQL Injection with Prepared Statements.mp4 25.5 MB
36 - Fast Parallel Testing/011 Routing Schema Access.mp4 24.7 MB
03 - Working with Tables/013 Running Queries on Associated Data.mp4 24.5 MB
20 - Implementing Database Design Patterns/003 Posts Creation.mp4 24.3 MB
09 - Assembling Queries with SubQueries/021 A New Where Operator.mp4 24.2 MB
05 - Aggregation of Records/014 Filtering Groups with Having.mp4 23.9 MB
23 - A Look at Indexes for Performance/001 Full Table Scans.mp4 23.9 MB
09 - Assembling Queries with SubQueries/015 More Useful - Subqueries with Where.mp4 23.9 MB
04 - Relating Records with Joins/003 Joining Data from Different Tables.mp4 23.7 MB
27 - Recursive Common Table Expressions/004 Writing the Query.mp4 23.6 MB
21 - Approaching and Writing Complex Queries/001 ig.sql 23.5 MB
09 - Assembling Queries with SubQueries/020 The Not In Operator with a List.mp4 23.4 MB
04 - Relating Records with Joins/012 Each Join in Practice.mp4 23.4 MB
36 - Fast Parallel Testing/007 Issues with Parallel Tests.mp4 22.8 MB
22 - Understanding the Internals of PostgreSQL/002 Where Does Postgres Store Data.mp4 22.6 MB
29 - Optimizing Queries with Materialized Views/005 Creating and Refreshing Materialized Views.mp4 22.5 MB
35 - Security Around PostgreSQL/003 Preventing SQL Injection.mp4 22.5 MB
28 - Simplifying Queries with Views/002 A Possible Solution for Merging Tables.mp4 22.3 MB
14 - Database-Side Validation and Constraints/001 Thinking About Validation.mp4 22.2 MB
29 - Optimizing Queries with Materialized Views/002 Grouping by Week.mp4 22.1 MB
01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About.mp4 21.7 MB
31 - Managing Database Design with Schema Migrations/004 A Few Notes on Migrations Libraries.mp4 21.7 MB
28 - Simplifying Queries with Views/003 Creating a View.mp4 21.2 MB
36 - Fast Parallel Testing/006 Assumptions Around Content.mp4 20.6 MB
26 - Simple Common Table Expressions/003 So What's a CTE.mp4 20.5 MB
09 - Assembling Queries with SubQueries/022 Finally Some!.mp4 20.5 MB
35 - Security Around PostgreSQL/001 SQL Injection Exploits.mp4 20.5 MB
04 - Relating Records with Joins/018 Where with Join.mp4 20.2 MB
30 - Handling Concurrency and Reversibility with Transactions/004 Transaction Cleanup on Crash.mp4 20.2 MB
36 - Fast Parallel Testing/010 Controlling Schema Access with Search Paths.mp4 20.1 MB
23 - A Look at Indexes for Performance/006 Downsides of Indexes.mp4 19.9 MB
13 - PostgreSQL Complex Datatypes/002 Data Types.mp4 19.7 MB
36 - Fast Parallel Testing/016 Cleaning up Schemas and Roles.mp4 19.4 MB
09 - Assembling Queries with SubQueries/001 What's a Subquery.mp4 19.4 MB
15 - Database Structure Design Patterns/003 A Config-based Schema Designer.mp4 19.3 MB
13 - PostgreSQL Complex Datatypes/005 Reminder on Character Types.mp4 19.1 MB
05 - Aggregation of Records/002 Picturing Group By.mp4 19.1 MB
04 - Relating Records with Joins/009 Missing Data in Joins.mp4 19.1 MB
11 - Utility Operators, Keywords, and Functions/003 The Case Keyword.mp4 19.0 MB
03 - Working with Tables/008 Primary Keys and Foreign Keys.mp4 18.8 MB
33 - Accessing PostgreSQL From API's/004 Building the Users Router.mp4 18.6 MB
01 - Simple - But Powerful - SQL Statements/006 Creating Tables.mp4 18.6 MB
05 - Aggregation of Records/016 More on Having!.mp4 18.6 MB
14 - Database-Side Validation and Constraints/002 Creating and Viewing Tables in PGAdmin.mp4 18.6 MB
14 - Database-Side Validation and Constraints/008 Multi-Column Uniqueness.mp4 18.4 MB
36 - Fast Parallel Testing/008 Isolation with Schemas.mp4 18.1 MB
04 - Relating Records with Joins/002 Queries with Joins and Aggregations.mp4 17.8 MB
16 - How to Build a 'Like' System/008 The Simplest Alternative.mp4 17.4 MB
19 - How to Design a 'Follower' System/001 Designing a Follower System.mp4 17.2 MB
18 - How to Build a 'Hashtag' System/004 A Few More User Columns.mp4 16.9 MB
16 - How to Build a 'Like' System/003 Designing a Like System.mp4 16.8 MB
34 - Data Access Pattern - Repositories/002 Creating a Repository.mp4 16.7 MB
28 - Simplifying Queries with Views/001 Most Popular Users.mp4 16.6 MB
04 - Relating Records with Joins/008 Alternate Forms of Syntax.mp4 16.3 MB
16 - How to Build a 'Like' System/001 Requirements of a Like System.mp4 16.2 MB
24 - Basic Query Tuning/001 The Query Processing Pipeline.mp4 16.1 MB
33 - Accessing PostgreSQL From API's/005 Understanding Connection Pools.mp4 16.0 MB
36 - Fast Parallel Testing/014 Escaping Identifiers.mp4 15.9 MB
20 - Implementing Database Design Patterns/005 Likes Creation.mp4 15.8 MB
33 - Accessing PostgreSQL From API's/003 One Fast Migration.mp4 15.7 MB
30 - Handling Concurrency and Reversibility with Transactions/001 What are Transactions Used For.mp4 15.5 MB
03 - Working with Tables/006 One-to-One and Many-to-Many Relationships.mp4 15.3 MB
09 - Assembling Queries with SubQueries/002 Thinking About the Structure of Data.mp4 15.2 MB
22 - Understanding the Internals of PostgreSQL/003 Heaps, Blocks, and Tuples.mp4 15.2 MB
09 - Assembling Queries with SubQueries/004 Subqueries in a Select.mp4 15.2 MB
03 - Working with Tables/017 Foreign Key Constraints Around Insertion.mp4 15.0 MB
04 - Relating Records with Joins/010 Why Wasn't It Included.mp4 15.0 MB
17 - How to Build a 'Mention' System/005 Update For Tags.mp4 15.0 MB
23 - A Look at Indexes for Performance/005 Benchmarking Queries.mp4 14.9 MB
34 - Data Access Pattern - Repositories/003 Accessing the API.mp4 14.7 MB
03 - Working with Tables/011 Auto-Generated ID's.mp4 14.6 MB
14 - Database-Side Validation and Constraints/013 So Where Are We Applying Validation.mp4 14.5 MB
32 - Schema vs Data Migrations/004 Creating a Posts Table.mp4 14.4 MB
14 - Database-Side Validation and Constraints/006 Default Column Values.mp4 14.3 MB
13 - PostgreSQL Complex Datatypes/007 Times, Dates, and Timestamps.mp4 14.3 MB
32 - Schema vs Data Migrations/007 Adding the Loc Column.mp4 14.2 MB
36 - Fast Parallel Testing/005 Multi-DB Setup.mp4 14.1 MB
12 - Local PostgreSQL Installation/001 PostgreSQL Installation on macOS.mp4 14.1 MB
15 - Database Structure Design Patterns/005 Rebuilding Some Schema.mp4 14.1 MB
14 - Database-Side Validation and Constraints/003 Applying a Null Constraint.mp4 14.1 MB
21 - Approaching and Writing Complex Queries/003 Restoring from Scratch.mp4 13.9 MB
12 - Local PostgreSQL Installation/003 Postgres installation on Windows.mp4 13.8 MB
08 - Unions and Intersections with Sets/004 Removing Commonalities with Except.mp4 13.7 MB
20 - Implementing Database Design Patterns/007 Creating Hashtags, Hashtag Posts, and Followers.mp4 13.7 MB
32 - Schema vs Data Migrations/003 Properly Running Data and Schema Migrations.mp4 13.6 MB
13 - PostgreSQL Complex Datatypes/008 Really Awesome Intervals.mp4 13.5 MB
32 - Schema vs Data Migrations/001 Schema vs Data Migrations.mp4 13.4 MB
07 - Sorting Records/003 Offset and Limit.mp4 13.2 MB
28 - Simplifying Queries with Views/004 When to Use a View.mp4 13.0 MB
08 - Unions and Intersections with Sets/001 Handling Sets with Union.mp4 13.0 MB
36 - Fast Parallel Testing/009 Creating and Accessing Schemas.mp4 12.8 MB
23 - A Look at Indexes for Performance/008 Automatically Generated Indexes.mp4 12.8 MB
02 - Filtering Records/003 Compound Where Clauses.mp4 12.8 MB
03 - Working with Tables/020 Testing Deletion Constraints.mp4 12.5 MB
13 - PostgreSQL Complex Datatypes/001 What'd We Just Do.mp4 12.4 MB
01 - Simple - But Powerful - SQL Statements/008 Inserting Data Into a Table.mp4 12.1 MB
34 - Data Access Pattern - Repositories/006 Finding Particular Users.mp4 12.0 MB
03 - Working with Tables/012 Creating Foreign Key Columns.mp4 12.0 MB
34 - Data Access Pattern - Repositories/004 Casing Issues.mp4 12.0 MB
13 - PostgreSQL Complex Datatypes/003 Fast Rules on Numeric Data Types.mp4 12.0 MB
22 - Understanding the Internals of PostgreSQL/005 Block Data Layout.mp4 11.8 MB
02 - Filtering Records/013 Updating Rows.mp4 11.7 MB
14 - Database-Side Validation and Constraints/010 Adding a Validation Check.mp4 11.7 MB
34 - Data Access Pattern - Repositories/001 The Repository Pattern.mp4 11.7 MB
36 - Fast Parallel Testing/012 Strategy for Isolation.mp4 11.7 MB
18 - How to Build a 'Hashtag' System/003 Including the Hashtag Table.mp4 11.6 MB
14 - Database-Side Validation and Constraints/011 Checks Over Multiple Columns.mp4 11.6 MB
04 - Relating Records with Joins/020 A Bit of Practice.mp4 11.5 MB
35 - Security Around PostgreSQL/007 And, Finally, Delete.mp4 11.5 MB
36 - Fast Parallel Testing/017 Finally... Parallel Tests! (Final Lecture).mp4 11.5 MB
01 - Simple - But Powerful - SQL Statements/007 Analyzing CREATE TABLE.mp4 11.4 MB
01 - Simple - But Powerful - SQL Statements/015 String Operators and Functions.mp4 11.3 MB
12 - Local PostgreSQL Installation/002 pgAdmin Setup on macOS.mp4 11.2 MB
09 - Assembling Queries with SubQueries/014 Subqueries in a Join Clause.mp4 10.8 MB
21 - Approaching and Writing Complex Queries/002 Adding Some Data.mp4 10.8 MB
08 - Unions and Intersections with Sets/002 A Few Notes on Union.mp4 10.8 MB
31 - Managing Database Design with Schema Migrations/009 Generating and Applying a Second Migration.mp4 10.8 MB
35 - Security Around PostgreSQL/006 Handling Updates.mp4 10.8 MB
32 - Schema vs Data Migrations/008 Writing Values to Both Columns.mp4 10.7 MB
29 - Optimizing Queries with Materialized Views/003 Reminder on Left Joins.mp4 10.5 MB
16 - How to Build a 'Like' System/010 So Which Approach.mp4 10.5 MB
18 - How to Build a 'Hashtag' System/005 Why No Number of Followers or Posts.mp4 10.4 MB
01 - Simple - But Powerful - SQL Statements/011 Calculated Columns.mp4 10.4 MB
16 - How to Build a 'Like' System/002 How Not to Design a Like System.mp4 10.3 MB
05 - Aggregation of Records/005 Combining Group By and Aggregates.mp4 10.2 MB
04 - Relating Records with Joins/017 Two Possible Solutions.mp4 10.2 MB
08 - Unions and Intersections with Sets/003 Commonalities with Intersect.mp4 10.1 MB
32 - Schema vs Data Migrations/010 Updating Values.mp4 10.1 MB
18 - How to Build a 'Hashtag' System/002 Tables for Hashtags.mp4 10.0 MB
35 - Security Around PostgreSQL/005 Inserting Users.mp4 10.0 MB
35 - Security Around PostgreSQL/004 Reminder on Post Requests.mp4 9.2 MB
14 - Database-Side Validation and Constraints/004 Solving a Gotcha with Null Constraints.mp4 9.1 MB
23 - A Look at Indexes for Performance/004 Creating an Index.mp4 8.9 MB
32 - Schema vs Data Migrations/012 Updating the App Server.mp4 8.8 MB
26 - Simple Common Table Expressions/002 A Quick Solution.mp4 8.7 MB
10 - Selecting Distinct Records/001 Selecting Distinct Values.mp4 8.4 MB
02 - Filtering Records/001 Filtering Rows with Where.mp4 8.4 MB
05 - Aggregation of Records/017 A Having Exercise Overview.mp4 8.4 MB
03 - Working with Tables/021 Setting Foreign Keys to Null on Delete.mp4 8.3 MB
36 - Fast Parallel Testing/004 Disconnecting After Tests.mp4 8.2 MB
28 - Simplifying Queries with Views/005 Deleting and Changing Views.mp4 7.9 MB
11 - Utility Operators, Keywords, and Functions/001 The Greatest Value in a List.mp4 7.9 MB
27 - Recursive Common Table Expressions/001 Recursive CTE's.mp4 7.8 MB
01 - Simple - But Powerful - SQL Statements/002 diagrams.zip 7.7 MB
15 - Database Structure Design Patterns/001 Approaching More Complicated Designs.mp4 7.7 MB
05 - Aggregation of Records/004 Aggregate Functions.mp4 7.6 MB
32 - Schema vs Data Migrations/013 Dropping the Last Columns.mp4 7.6 MB
02 - Filtering Records/014 Deleting Rows.mp4 7.5 MB
03 - Working with Tables/001 The Plan Moving Forward.mp4 7.1 MB
26 - Simple Common Table Expressions/001 Common Table Expressions.mp4 7.0 MB
03 - Working with Tables/023 Adding Some Complexity.mp4 6.8 MB
05 - Aggregation of Records/007 Visualizing More Grouping.mp4 6.7 MB
31 - Managing Database Design with Schema Migrations/003 Issues Solved by Migrations.mp4 6.7 MB
09 - Assembling Queries with SubQueries/013 Exercise Solution.mp4 6.6 MB
22 - Understanding the Internals of PostgreSQL/001 Thinking About Performance.mp4 6.5 MB
09 - Assembling Queries with SubQueries/029 A Select Without a From.mp4 6.4 MB
25 - Advanced Query Tuning/006 Costs Flow Up.mp4 6.3 MB
23 - A Look at Indexes for Performance/002 What's an Index.mp4 6.3 MB
07 - Sorting Records/002 Two Variations on Sorting.mp4 6.3 MB
31 - Managing Database Design with Schema Migrations/006 Project Creation.mp4 6.2 MB
09 - Assembling Queries with SubQueries/009 From Subqueries that Return a Value.mp4 6.1 MB
02 - Filtering Records/002 More on the Where Keyword.mp4 6.0 MB
06 - Working with Large Datasets/006 Remember Joins.mp4 6.0 MB
15 - Database Structure Design Patterns/004 Here's the Plan.mp4 5.9 MB
21 - Approaching and Writing Complex Queries/007 Solving for Posts by User.mp4 5.9 MB
04 - Relating Records with Joins/004 Another Quick Join.mp4 5.6 MB
29 - Optimizing Queries with Materialized Views/001 Materialized Views.mp4 5.6 MB
04 - Relating Records with Joins/022 Exercise Solution.mp4 5.4 MB
13 - PostgreSQL Complex Datatypes/006 Boolean Data Types.mp4 5.4 MB
06 - Working with Large Datasets/002 Investigating This Dataset.mp4 5.4 MB
03 - Working with Tables/016 Foreign Key Creation Solution.mp4 5.4 MB
36 - Fast Parallel Testing/001 A Note on Testing.mp4 5.4 MB
17 - How to Build a 'Mention' System/002 Adding Captions and Locations.mp4 5.4 MB
05 - Aggregation of Records/001 Aggregating and Grouping.mp4 5.3 MB
03 - Working with Tables/014 Exercise Overview.mp4 5.3 MB
06 - Working with Large Datasets/005 Group By Review Solution.mp4 5.3 MB
05 - Aggregation of Records/019 A Quick Solution.mp4 5.2 MB
20 - Implementing Database Design Patterns/004 Comments Creation.mp4 4.9 MB
30 - Handling Concurrency and Reversibility with Transactions/005 Closing Aborted Transactions.mp4 4.8 MB
21 - Approaching and Writing Complex Queries/004 Highest User ID's Exercise.mp4 4.7 MB
05 - Aggregation of Records/015 Having In Action.mp4 4.7 MB
07 - Sorting Records/001 The Basics of Sorting.mp4 4.6 MB
09 - Assembling Queries with SubQueries/019 Exercise Solution.mp4 4.4 MB
20 - Implementing Database Design Patterns/001 Back to Postgres.mp4 4.4 MB
21 - Approaching and Writing Complex Queries/009 Solution for Likes Per User.mp4 4.4 MB
02 - Filtering Records/012 Solving Calculations.mp4 4.2 MB
16 - How to Build a 'Like' System/005 Making a Reaction System Instead.mp4 4.1 MB
23 - A Look at Indexes for Performance/007 Index Types.mp4 4.1 MB
01 - Simple - But Powerful - SQL Statements/009 Retrieving Data with Select.mp4 4.0 MB
33 - Accessing PostgreSQL From API's/007 Query and Close.mp4 4.0 MB
05 - Aggregation of Records/006 A Gotcha with Count.mp4 4.0 MB
30 - Handling Concurrency and Reversibility with Transactions/002 Some Sample Data.mp4 3.8 MB
11 - Utility Operators, Keywords, and Functions/002 And the Least Value in a List!.mp4 3.8 MB
02 - Filtering Records/009 A Where With Lists Solution.mp4 3.6 MB
04 - Relating Records with Joins/007 A Joinful Solution.mp4 3.5 MB
02 - Filtering Records/016 A Solution for Updating Rows.mp4 3.4 MB
02 - Filtering Records/010 Calculations in Where Clauses.mp4 3.4 MB
08 - Unions and Intersections with Sets/007 Exercise Solution.mp4 3.3 MB
04 - Relating Records with Joins/005 Exercise Overview.mp4 3.1 MB
09 - Assembling Queries with SubQueries/026 A Quick Solution.mp4 3.1 MB
06 - Working with Large Datasets/008 Of Course You Remember!.mp4 3.0 MB
21 - Approaching and Writing Complex Queries/005 Solution for User ID's.mp4 3.0 MB
21 - Approaching and Writing Complex Queries/006 Posts by a Particular User.mp4 3.0 MB
08 - Unions and Intersections with Sets/005 Union Exercise Overview.mp4 3.0 MB
02 - Filtering Records/018 Solution for Deleting Rows.mp4 2.8 MB
09 - Assembling Queries with SubQueries/007 Select Solution.mp4 2.6 MB
05 - Aggregation of Records/013 Solution.mp4 2.6 MB
09 - Assembling Queries with SubQueries/032 Exercise Solution.mp4 2.5 MB
07 - Sorting Records/006 Exercise Solution.mp4 2.4 MB
09 - Assembling Queries with SubQueries/011 Exercise Overview.mp4 2.4 MB
21 - Approaching and Writing Complex Queries/008 Likes Per User.mp4 2.2 MB
05 - Aggregation of Records/010 Grouping Solution.mp4 2.2 MB
01 - Simple - But Powerful - SQL Statements/012 Calculating Phone Revenue.mp4 2.2 MB
01 - Simple - But Powerful - SQL Statements/014 Exercise Solution.mp4 2.2 MB
09 - Assembling Queries with SubQueries/005 Exercise Overview.mp4 2.1 MB
06 - Working with Large Datasets/003 Some Group By Practice.mp4 2.1 MB
33 - Accessing PostgreSQL From API's/001 Section Goal.mp4 2.0 MB
09 - Assembling Queries with SubQueries/017 Exercise Overview.mp4 1.9 MB
02 - Filtering Records/006 A Where Solution.mp4 1.9 MB
33 - Accessing PostgreSQL From API's/002 Initial Setup.mp4 1.7 MB
04 - Relating Records with Joins/015 Exercise Overview.mp4 1.5 MB
09 - Assembling Queries with SubQueries/030 Exercise Overview.mp4 1.4 MB
10 - Selecting Distinct Records/004 A Distinct Solution.mp4 1.4 MB
02 - Filtering Records/004 A Where Exercise Overview.mp4 1.2 MB
05 - Aggregation of Records/011 Adding a Layer of Difficulty.mp4 1.2 MB
05 - Aggregation of Records/008 Exercise Overview.mp4 1.1 MB
02 - Filtering Records/007 Where With Lists.mp4 1.1 MB
10 - Selecting Distinct Records/002 Exercise Overview.mp4 961.1 KB
09 - Assembling Queries with SubQueries/024 Exercise Overview.mp4 853.7 KB
07 - Sorting Records/004 Exercise Overview.mp4 811.1 KB
04 - Relating Records with Joins/011 009-joins-cheatsheet.pdf 190.5 KB
36 - Fast Parallel Testing/016 037-access.zip 66.6 KB
36 - Fast Parallel Testing/015 036-access.zip 66.5 KB
36 - Fast Parallel Testing/014 035-access.zip 66.1 KB
36 - Fast Parallel Testing/013 034-access.zip 66.1 KB
36 - Fast Parallel Testing/007 028-access.zip 65.8 KB
36 - Fast Parallel Testing/006 027-access.zip 64.5 KB
36 - Fast Parallel Testing/005 026-access.zip 64.5 KB
36 - Fast Parallel Testing/004 025-access.zip 64.5 KB
36 - Fast Parallel Testing/003 024-access.zip 64.5 KB
35 - Security Around PostgreSQL/007 021-access.zip 63.7 KB
35 - Security Around PostgreSQL/005 019-access.zip 63.6 KB
34 - Data Access Pattern - Repositories/002 010-access.zip 62.6 KB
33 - Accessing PostgreSQL From API's/007 008-access.zip 62.0 KB
33 - Accessing PostgreSQL From API's/004 005-access-social-repo.zip 61.3 KB
22 - Understanding the Internals of PostgreSQL/006 Heap File Layout.srt 50.6 KB
31 - Managing Database Design with Schema Migrations/001 A Story on Migrations.srt 28.0 KB
09 - Assembling Queries with SubQueries/027 Probably Too Much About Correlated Subqueries.srt 26.3 KB
32 - Schema vs Data Migrations/009 Transaction Locks.srt 22.4 KB
20 - Implementing Database Design Patterns/002 Creating Tables with Checks.srt 21.4 KB
04 - Relating Records with Joins/014 Test Your Joining Knowledge.html 21.1 KB
25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost.srt 20.1 KB
36 - Fast Parallel Testing/013 Programmatic Schema Creation.srt 18.6 KB
06 - Working with Large Datasets/001 A New Dataset.html 17.8 KB
09 - Assembling Queries with SubQueries/023 Is It A Valid Subquery.html 16.2 KB
27 - Recursive Common Table Expressions/002 Recursive CTE's Step by Step.srt 16.1 KB
06 - Working with Large Datasets/002 001-sq-data.sql 15.8 KB
13 - PostgreSQL Complex Datatypes/004 More on Number Data Types.srt 15.2 KB
04 - Relating Records with Joins/011 Four Kinds of Joins.srt 15.2 KB
30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions.srt 15.1 KB
27 - Recursive Common Table Expressions/005 Walking Through Recursion.srt 15.0 KB
32 - Schema vs Data Migrations/002 Dangers Around Data Migrations.srt 14.8 KB
24 - Basic Query Tuning/004 Solving an Explain Mystery.srt 14.1 KB
29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query.srt 14.0 KB
09 - Assembling Queries with SubQueries/010 Example of a Subquery in a From.srt 13.9 KB
09 - Assembling Queries with SubQueries/015 More Useful - Subqueries with Where.srt 13.9 KB
09 - Assembling Queries with SubQueries/028 More on Correlated Subqueries.srt 13.7 KB
03 - Working with Tables/010 Foreign Keys; How Do They Work.html 13.6 KB
03 - Working with Tables/005 A 'Has One' or 'Has Many'.html 13.1 KB
03 - Working with Tables/009 Understanding Foreign Keys.srt 13.0 KB
23 - A Look at Indexes for Performance/003 How an Index Works.srt 12.8 KB
20 - Implementing Database Design Patterns/003 Posts Creation.srt 12.8 KB
35 - Security Around PostgreSQL/002 Handling SQL Injection with Prepared Statements.srt 12.8 KB
34 - Data Access Pattern - Repositories/002 Creating a Repository.srt 12.7 KB
16 - How to Build a 'Like' System/009 Polymorphic Associations.html 12.6 KB
17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions.srt 12.5 KB
25 - Advanced Query Tuning/007 Use My Index!.srt 12.5 KB
27 - Recursive Common Table Expressions/004 Writing the Query.srt 12.5 KB
09 - Assembling Queries with SubQueries/008 Subqueries in a From.srt 12.3 KB
04 - Relating Records with Joins/019 Three Way Joins.srt 12.2 KB
35 - Security Around PostgreSQL/003 Preventing SQL Injection.srt 12.0 KB
18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System.srt 11.9 KB
09 - Assembling Queries with SubQueries/003 What's the Data Look Like.html 11.9 KB
03 - Working with Tables/002 Approaching Database Design.srt 11.8 KB
05 - Aggregation of Records/003 Selecting Columns After Grouping.html 11.8 KB
15 - Database Structure Design Patterns/003 A Config-based Schema Designer.srt 11.7 KB
04 - Relating Records with Joins/003 Joining Data from Different Tables.srt 11.6 KB
17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags.srt 11.6 KB
14 - Database-Side Validation and Constraints/002 Creating and Viewing Tables in PGAdmin.srt 11.6 KB
25 - Advanced Query Tuning/004 Calculating Costs.html 11.6 KB
31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations.srt 11.5 KB
03 - Working with Tables/007 Identifying One-to-One and Many-to-Many Relationships.html 11.5 KB
36 - Fast Parallel Testing/002 Assertions Around User Count.srt 11.1 KB
16 - How to Build a 'Like' System/007 Polymorphic Association Alternative Implementation.srt 11.1 KB
25 - Advanced Query Tuning/003 A Touch More on Costs.srt 11.1 KB
03 - Working with Tables/022 What Happens On Delete.html 11.0 KB
05 - Aggregation of Records/016 More on Having!.srt 11.0 KB
15 - Database Structure Design Patterns/005 Rebuilding Some Schema.srt 10.9 KB
35 - Security Around PostgreSQL/001 SQL Injection Exploits.srt 10.7 KB
33 - Accessing PostgreSQL From API's/005 Understanding Connection Pools.srt 10.6 KB
03 - Working with Tables/013 Running Queries on Associated Data.srt 10.6 KB
04 - Relating Records with Joins/018 Where with Join.srt 10.6 KB
33 - Accessing PostgreSQL From API's/006 Validating Connection Credentials.srt 10.6 KB
03 - Working with Tables/003 Let's Design Some Schema.html 10.5 KB
20 - Implementing Database Design Patterns/005 Likes Creation.srt 10.5 KB
31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations.srt 10.4 KB
14 - Database-Side Validation and Constraints/003 Applying a Null Constraint.srt 10.4 KB
17 - How to Build a 'Mention' System/001 Additional Features Around Posts.srt 10.3 KB
14 - Database-Side Validation and Constraints/009 Is It Unique.html 10.3 KB
28 - Simplifying Queries with Views/001 Most Popular Users.srt 10.2 KB
14 - Database-Side Validation and Constraints/005 Creating NULL Constraints.html 10.2 KB
01 - Simple - But Powerful - SQL Statements/015 String Operators and Functions.srt 10.2 KB
07 - Sorting Records/003 Offset and Limit.srt 10.1 KB
03 - Working with Tables/004 One-to-Many and Many-to-One Relationships.srt 10.1 KB
01 - Simple - But Powerful - SQL Statements/005 Database Terminology.html 10.1 KB
09 - Assembling Queries with SubQueries/021 A New Where Operator.srt 10.1 KB
04 - Relating Records with Joins/009 Missing Data in Joins.srt 10.0 KB
16 - How to Build a 'Like' System/004 Building a Similar System.html 10.0 KB
25 - Advanced Query Tuning/002 Calculating Cost by Hand.srt 10.0 KB
15 - Database Structure Design Patterns/002 Using a SQL Design Tool.srt 10.0 KB
22 - Understanding the Internals of PostgreSQL/004 Terminology Check.html 10.0 KB
34 - Data Access Pattern - Repositories/005 Fixing Casing.srt 10.0 KB
18 - How to Build a 'Hashtag' System/004 A Few More User Columns.srt 10.0 KB
12 - Local PostgreSQL Installation/001 PostgreSQL Installation on macOS.srt 9.8 KB
29 - Optimizing Queries with Materialized Views/005 Creating and Refreshing Materialized Views.srt 9.7 KB
14 - Database-Side Validation and Constraints/013 So Where Are We Applying Validation.srt 9.7 KB
29 - Optimizing Queries with Materialized Views/006 Views vs Materialized Views.html 9.7 KB
08 - Unions and Intersections with Sets/004 Removing Commonalities with Except.srt 9.5 KB
23 - A Look at Indexes for Performance/009 Using Automatically Created Indexes.html 9.5 KB
16 - How to Build a 'Like' System/006 Polymorphic Associations.srt 9.4 KB
20 - Implementing Database Design Patterns/007 Creating Hashtags, Hashtag Posts, and Followers.srt 9.4 KB
19 - How to Design a 'Follower' System/001 Designing a Follower System.srt 9.3 KB
14 - Database-Side Validation and Constraints/007 Applying a Unique Constraint to One column.srt 9.3 KB
04 - Relating Records with Joins/008 Alternate Forms of Syntax.srt 9.3 KB
14 - Database-Side Validation and Constraints/012 Does It Pass a Check.html 9.2 KB
03 - Working with Tables/011 Auto-Generated ID's.srt 9.2 KB
13 - PostgreSQL Complex Datatypes/008 Really Awesome Intervals.srt 9.1 KB
09 - Assembling Queries with SubQueries/016 Data Structure with Where Subqueries.srt 9.0 KB
08 - Unions and Intersections with Sets/001 Handling Sets with Union.srt 9.0 KB
25 - Advanced Query Tuning/005 Startup vs Total Costs.srt 9.0 KB
24 - Basic Query Tuning/003 Explain Vs Explain Analyze.html 8.9 KB
03 - Working with Tables/006 One-to-One and Many-to-Many Relationships.srt 8.8 KB
36 - Fast Parallel Testing/010 Controlling Schema Access with Search Paths.srt 8.8 KB
28 - Simplifying Queries with Views/003 Creating a View.srt 8.8 KB
22 - Understanding the Internals of PostgreSQL/002 Where Does Postgres Store Data.srt 8.8 KB
03 - Working with Tables/017 Foreign Key Constraints Around Insertion.srt 8.7 KB
32 - Schema vs Data Migrations/003 Properly Running Data and Schema Migrations.srt 8.6 KB
09 - Assembling Queries with SubQueries/001 What's a Subquery.srt 8.6 KB
09 - Assembling Queries with SubQueries/004 Subqueries in a Select.srt 8.5 KB
20 - Implementing Database Design Patterns/006 Photo Tags and Caption Tags.srt 8.5 KB
36 - Fast Parallel Testing/016 Cleaning up Schemas and Roles.srt 8.5 KB
13 - PostgreSQL Complex Datatypes/007 Times, Dates, and Timestamps.srt 8.5 KB
23 - A Look at Indexes for Performance/005 Benchmarking Queries.srt 8.5 KB
24 - Basic Query Tuning/002 Explain and Explain Analyze.srt 8.4 KB
16 - How to Build a 'Like' System/003 Designing a Like System.srt 8.4 KB
34 - Data Access Pattern - Repositories/006 Finding Particular Users.srt 8.4 KB
36 - Fast Parallel Testing/007 Issues with Parallel Tests.srt 8.3 KB
24 - Basic Query Tuning/001 The Query Processing Pipeline.srt 8.3 KB
05 - Aggregation of Records/002 Picturing Group By.srt 8.3 KB
01 - Simple - But Powerful - SQL Statements/004 Database Design.srt 8.2 KB
36 - Fast Parallel Testing/009 Creating and Accessing Schemas.srt 8.2 KB
36 - Fast Parallel Testing/003 Connecting to a DB For Tests.srt 8.2 KB
36 - Fast Parallel Testing/015 Test Helpers.srt 8.1 KB
36 - Fast Parallel Testing/006 Assumptions Around Content.srt 8.1 KB
14 - Database-Side Validation and Constraints/011 Checks Over Multiple Columns.srt 8.0 KB
12 - Local PostgreSQL Installation/002 pgAdmin Setup on macOS.srt 8.0 KB
03 - Working with Tables/008 Primary Keys and Foreign Keys.srt 8.0 KB
09 - Assembling Queries with SubQueries/022 Finally Some!.srt 7.9 KB
13 - PostgreSQL Complex Datatypes/005 Reminder on Character Types.srt 7.8 KB
23 - A Look at Indexes for Performance/006 Downsides of Indexes.srt 7.8 KB
04 - Relating Records with Joins/020 A Bit of Practice.srt 7.8 KB
03 - Working with Tables/018 Constraints Around Deletion.srt 7.8 KB
05 - Aggregation of Records/014 Filtering Groups with Having.srt 7.8 KB
01 - Simple - But Powerful - SQL Statements/006 Creating Tables.srt 7.7 KB
04 - Relating Records with Joins/001 Adding Some Data.html 7.7 KB
16 - How to Build a 'Like' System/001 Requirements of a Like System.srt 7.6 KB
17 - How to Build a 'Mention' System/005 Update For Tags.srt 7.6 KB
03 - Working with Tables/012 Creating Foreign Key Columns.srt 7.6 KB
01 - Simple - But Powerful - SQL Statements/008 Inserting Data Into a Table.srt 7.6 KB
04 - Relating Records with Joins/012 010-sql-cumulative.sql 7.6 KB
27 - Recursive Common Table Expressions/003 Why Use Recursive CTE's.srt 7.6 KB
02 - Filtering Records/003 Compound Where Clauses.srt 7.6 KB
31 - Managing Database Design with Schema Migrations/004 A Few Notes on Migrations Libraries.srt 7.6 KB
04 - Relating Records with Joins/009 007-joins-cumulative.sql 7.5 KB
09 - Assembling Queries with SubQueries/002 Thinking About the Structure of Data.srt 7.5 KB
31 - Managing Database Design with Schema Migrations/002 Migration Files.srt 7.5 KB
36 - Fast Parallel Testing/005 Multi-DB Setup.srt 7.3 KB
01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About.srt 7.3 KB
01 - Simple - But Powerful - SQL Statements/011 Calculated Columns.srt 7.2 KB
22 - Understanding the Internals of PostgreSQL/005 Block Data Layout.srt 7.2 KB
36 - Fast Parallel Testing/012 Strategy for Isolation.srt 7.2 KB
21 - Approaching and Writing Complex Queries/003 Restoring from Scratch.srt 7.1 KB
29 - Optimizing Queries with Materialized Views/003 Reminder on Left Joins.srt 7.1 KB
32 - Schema vs Data Migrations/004 Creating a Posts Table.srt 7.1 KB
16 - How to Build a 'Like' System/010 So Which Approach.srt 7.1 KB
03 - Working with Tables/020 Testing Deletion Constraints.srt 7.1 KB
33 - Accessing PostgreSQL From API's/004 Building the Users Router.srt 7.1 KB
05 - Aggregation of Records/005 Combining Group By and Aggregates.srt 7.1 KB
09 - Assembling Queries with SubQueries/014 Subqueries in a Join Clause.srt 7.0 KB
13 - PostgreSQL Complex Datatypes/002 Data Types.srt 7.0 KB
35 - Security Around PostgreSQL/006 Handling Updates.srt 7.0 KB
11 - Utility Operators, Keywords, and Functions/003 The Case Keyword.srt 6.9 KB
34 - Data Access Pattern - Repositories/004 Casing Issues.srt 6.9 KB
21 - Approaching and Writing Complex Queries/002 Adding Some Data.srt 6.8 KB
04 - Relating Records with Joins/012 Each Join in Practice.srt 6.8 KB
12 - Local PostgreSQL Installation/003 Postgres installation on Windows.srt 6.7 KB
36 - Fast Parallel Testing/014 Escaping Identifiers.srt 6.7 KB
32 - Schema vs Data Migrations/008 Writing Values to Both Columns.srt 6.7 KB
35 - Security Around PostgreSQL/007 And, Finally, Delete.srt 6.7 KB
14 - Database-Side Validation and Constraints/001 Thinking About Validation.srt 6.7 KB
14 - Database-Side Validation and Constraints/004 Solving a Gotcha with Null Constraints.srt 6.7 KB
36 - Fast Parallel Testing/008 Isolation with Schemas.srt 6.6 KB
10 - Selecting Distinct Records/001 Selecting Distinct Values.srt 6.6 KB
32 - Schema vs Data Migrations/012 Updating the App Server.srt 6.6 KB
23 - A Look at Indexes for Performance/004 Creating an Index.srt 6.5 KB
29 - Optimizing Queries with Materialized Views/002 Grouping by Week.srt 6.5 KB
35 - Security Around PostgreSQL/005 Inserting Users.srt 6.5 KB
36 - Fast Parallel Testing/011 Routing Schema Access.srt 6.5 KB
13 - PostgreSQL Complex Datatypes/001 What'd We Just Do.srt 6.4 KB
32 - Schema vs Data Migrations/010 Updating Values.srt 6.4 KB
23 - A Look at Indexes for Performance/001 Full Table Scans.srt 6.4 KB
04 - Relating Records with Joins/013 Does Order Matter.srt 6.4 KB
30 - Handling Concurrency and Reversibility with Transactions/001 What are Transactions Used For.srt 6.4 KB
14 - Database-Side Validation and Constraints/010 Adding a Validation Check.srt 6.4 KB
09 - Assembling Queries with SubQueries/020 The Not In Operator with a List.srt 6.3 KB
02 - Filtering Records/013 Updating Rows.srt 6.3 KB
32 - Schema vs Data Migrations/007 Adding the Loc Column.srt 6.3 KB
34 - Data Access Pattern - Repositories/003 Accessing the API.srt 6.2 KB
26 - Simple Common Table Expressions/003 So What's a CTE.srt 6.2 KB
28 - Simplifying Queries with Views/002 A Possible Solution for Merging Tables.srt 6.1 KB
16 - How to Build a 'Like' System/008 The Simplest Alternative.srt 6.1 KB
18 - How to Build a 'Hashtag' System/005 Why No Number of Followers or Posts.srt 6.0 KB
02 - Filtering Records/001 Filtering Rows with Where.srt 6.0 KB
22 - Understanding the Internals of PostgreSQL/003 Heaps, Blocks, and Tuples.srt 5.9 KB
18 - How to Build a 'Hashtag' System/002 Tables for Hashtags.srt 5.9 KB
26 - Simple Common Table Expressions/002 A Quick Solution.srt 5.9 KB
08 - Unions and Intersections with Sets/002 A Few Notes on Union.srt 5.9 KB
06 - Working with Large Datasets/007 Inner Join Review.html 5.9 KB
18 - How to Build a 'Hashtag' System/003 Including the Hashtag Table.srt 5.8 KB
04 - Relating Records with Joins/021 Three Way Exercise.html 5.7 KB
34 - Data Access Pattern - Repositories/001 The Repository Pattern.srt 5.7 KB
02 - Filtering Records/011 Trying Calculations in Where Clauses.html 5.7 KB
23 - A Look at Indexes for Performance/008 Automatically Generated Indexes.srt 5.6 KB
09 - Assembling Queries with SubQueries/006 Embedding in Select.html 5.6 KB
08 - Unions and Intersections with Sets/006 Merging Results with Union.html 5.6 KB
14 - Database-Side Validation and Constraints/008 Multi-Column Uniqueness.srt 5.5 KB
01 - Simple - But Powerful - SQL Statements/007 Analyzing CREATE TABLE.srt 5.5 KB
05 - Aggregation of Records/018 Practice Yourself Some Having.html 5.5 KB
05 - Aggregation of Records/017 A Having Exercise Overview.srt 5.5 KB
09 - Assembling Queries with SubQueries/031 From-less Selects.html 5.5 KB
31 - Managing Database Design with Schema Migrations/009 Generating and Applying a Second Migration.srt 5.4 KB
05 - Aggregation of Records/012 Grouping With a Join!.html 5.4 KB
15 - Database Structure Design Patterns/001 Approaching More Complicated Designs.srt 5.4 KB
01 - Simple - But Powerful - SQL Statements/013 Using Calculated Columns.html 5.3 KB
05 - Aggregation of Records/009 Practice For Grouping and Aggregating.html 5.3 KB
04 - Relating Records with Joins/006 Practice Joining Data.html 5.3 KB
04 - Relating Records with Joins/002 Queries with Joins and Aggregations.srt 5.3 KB
02 - Filtering Records/014 Deleting Rows.srt 5.3 KB
02 - Filtering Records/015 Try Updating Records In a Table!.html 5.2 KB
02 - Filtering Records/017 Practice Deleting Records.html 5.2 KB
09 - Assembling Queries with SubQueries/029 A Select Without a From.srt 5.2 KB
14 - Database-Side Validation and Constraints/006 Default Column Values.srt 5.2 KB
36 - Fast Parallel Testing/017 Finally... Parallel Tests! (Final Lecture).srt 5.1 KB
11 - Utility Operators, Keywords, and Functions/001 The Greatest Value in a List.srt 5.1 KB
02 - Filtering Records/008 A More Challenging 'Where'.html 5.1 KB
04 - Relating Records with Joins/016 Joins, Joins, Join!.html 5.1 KB
09 - Assembling Queries with SubQueries/018 Subquery Where's.html 5.1 KB
09 - Assembling Queries with SubQueries/012 Subquery From's.html 5.1 KB
06 - Working with Large Datasets/004 Group By Review.html 5.1 KB
09 - Assembling Queries with SubQueries/025 Practice Your Subqueries!.html 5.1 KB
02 - Filtering Records/005 Practicing Where Statements.html 5.1 KB
36 - Fast Parallel Testing/001 A Note on Testing.srt 5.1 KB
28 - Simplifying Queries with Views/004 When to Use a View.srt 5.1 KB
08 - Unions and Intersections with Sets/003 Commonalities with Intersect.srt 5.1 KB
07 - Sorting Records/005 Sorting, Offsetting, and Limiting.html 5.0 KB
03 - Working with Tables/015 Creating and Using Foreign Keys.html 5.0 KB
10 - Selecting Distinct Records/003 Some Practice with Distinct.html 4.9 KB
16 - How to Build a 'Like' System/002 How Not to Design a Like System.srt 4.9 KB
36 - Fast Parallel Testing/004 Disconnecting After Tests.srt 4.9 KB
04 - Relating Records with Joins/017 Two Possible Solutions.srt 4.8 KB
03 - Working with Tables/023 Adding Some Complexity.srt 4.8 KB
05 - Aggregation of Records/007 Visualizing More Grouping.srt 4.7 KB
32 - Schema vs Data Migrations/013 Dropping the Last Columns.srt 4.6 KB
05 - Aggregation of Records/004 Aggregate Functions.srt 4.6 KB
03 - Working with Tables/021 Setting Foreign Keys to Null on Delete.srt 4.6 KB
31 - Managing Database Design with Schema Migrations/003 Issues Solved by Migrations.srt 4.5 KB
31 - Managing Database Design with Schema Migrations/006 Project Creation.srt 4.5 KB
01 - Simple - But Powerful - SQL Statements/010 Create, Insert, and Select!.html 4.5 KB
13 - PostgreSQL Complex Datatypes/006 Boolean Data Types.srt 4.4 KB
04 - Relating Records with Joins/022 Exercise Solution.srt 4.3 KB
35 - Security Around PostgreSQL/004 Reminder on Post Requests.srt 4.3 KB
09 - Assembling Queries with SubQueries/009 From Subqueries that Return a Value.srt 4.3 KB
05 - Aggregation of Records/006 A Gotcha with Count.srt 4.2 KB
15 - Database Structure Design Patterns/004 Here's the Plan.srt 4.2 KB
07 - Sorting Records/002 Two Variations on Sorting.srt 4.2 KB
05 - Aggregation of Records/015 Having In Action.srt 4.1 KB
06 - Working with Large Datasets/002 Investigating This Dataset.srt 4.0 KB
29 - Optimizing Queries with Materialized Views/001 Materialized Views.srt 3.9 KB
23 - A Look at Indexes for Performance/002 What's an Index.srt 3.9 KB
04 - Relating Records with Joins/010 Why Wasn't It Included.srt 3.8 KB
02 - Filtering Records/002 More on the Where Keyword.srt 3.8 KB
05 - Aggregation of Records/019 A Quick Solution.srt 3.8 KB
06 - Working with Large Datasets/005 Group By Review Solution.srt 3.7 KB
37 - Bonus!/001 Bonus!.html 3.7 KB
07 - Sorting Records/001 The Basics of Sorting.srt 3.7 KB
06 - Working with Large Datasets/006 Remember Joins.srt 3.7 KB
13 - PostgreSQL Complex Datatypes/003 Fast Rules on Numeric Data Types.srt 3.6 KB
05 - Aggregation of Records/001 Aggregating and Grouping.srt 3.6 KB
20 - Implementing Database Design Patterns/004 Comments Creation.srt 3.5 KB
22 - Understanding the Internals of PostgreSQL/001 Thinking About Performance.srt 3.5 KB
01 - Simple - But Powerful - SQL Statements/009 Retrieving Data with Select.srt 3.4 KB
04 - Relating Records with Joins/004 Another Quick Join.srt 3.4 KB
30 - Handling Concurrency and Reversibility with Transactions/002 Some Sample Data.srt 3.3 KB
03 - Working with Tables/014 Exercise Overview.srt 3.3 KB
20 - Implementing Database Design Patterns/001 Back to Postgres.srt 3.2 KB
33 - Accessing PostgreSQL From API's/007 Query and Close.srt 3.2 KB
21 - Approaching and Writing Complex Queries/004 Highest User ID's Exercise.srt 3.2 KB
11 - Utility Operators, Keywords, and Functions/002 And the Least Value in a List!.srt 3.1 KB
03 - Working with Tables/016 Foreign Key Creation Solution.srt 3.1 KB
09 - Assembling Queries with SubQueries/019 Exercise Solution.srt 3.1 KB
02 - Filtering Records/010 Calculations in Where Clauses.srt 3.0 KB
25 - Advanced Query Tuning/006 Costs Flow Up.srt 3.0 KB
02 - Filtering Records/012 Solving Calculations.srt 2.9 KB
26 - Simple Common Table Expressions/001 Common Table Expressions.srt 2.9 KB
21 - Approaching and Writing Complex Queries/007 Solving for Posts by User.srt 2.9 KB
30 - Handling Concurrency and Reversibility with Transactions/005 Closing Aborted Transactions.srt 2.9 KB
20 - Implementing Database Design Patterns/007 007-db.sql 2.8 KB
09 - Assembling Queries with SubQueries/013 Exercise Solution.srt 2.8 KB
03 - Working with Tables/001 The Plan Moving Forward.srt 2.8 KB
04 - Relating Records with Joins/007 A Joinful Solution.srt 2.7 KB
17 - How to Build a 'Mention' System/002 Adding Captions and Locations.srt 2.6 KB
16 - How to Build a 'Like' System/005 Making a Reaction System Instead.srt 2.6 KB
23 - A Look at Indexes for Performance/007 Index Types.srt 2.5 KB
02 - Filtering Records/009 A Where With Lists Solution.srt 2.5 KB
21 - Approaching and Writing Complex Queries/009 Solution for Likes Per User.srt 2.5 KB
33 - Accessing PostgreSQL From API's/002 Initial Setup.srt 2.4 KB
05 - Aggregation of Records/013 Solution.srt 2.4 KB
09 - Assembling Queries with SubQueries/026 A Quick Solution.srt 2.4 KB
02 - Filtering Records/018 Solution for Deleting Rows.srt 2.3 KB
06 - Working with Large Datasets/008 Of Course You Remember!.srt 2.2 KB
05 - Aggregation of Records/010 Grouping Solution.srt 2.2 KB
20 - Implementing Database Design Patterns/006 006-db.sql 2.2 KB
08 - Unions and Intersections with Sets/007 Exercise Solution.srt 2.2 KB
07 - Sorting Records/006 Exercise Solution.srt 2.1 KB
08 - Unions and Intersections with Sets/005 Union Exercise Overview.srt 2.1 KB
06 - Working with Large Datasets/003 Some Group By Practice.srt 2.1 KB
02 - Filtering Records/016 A Solution for Updating Rows.srt 2.0 KB
09 - Assembling Queries with SubQueries/007 Select Solution.srt 1.9 KB
21 - Approaching and Writing Complex Queries/005 Solution for User ID's.srt 1.9 KB
09 - Assembling Queries with SubQueries/032 Exercise Solution.srt 1.9 KB
04 - Relating Records with Joins/005 Exercise Overview.srt 1.8 KB
09 - Assembling Queries with SubQueries/011 Exercise Overview.srt 1.8 KB
21 - Approaching and Writing Complex Queries/006 Posts by a Particular User.srt 1.8 KB
09 - Assembling Queries with SubQueries/005 Exercise Overview.srt 1.7 KB
01 - Simple - But Powerful - SQL Statements/014 Exercise Solution.srt 1.6 KB
01 - Simple - But Powerful - SQL Statements/012 Calculating Phone Revenue.srt 1.6 KB
33 - Accessing PostgreSQL From API's/001 Section Goal.srt 1.6 KB
20 - Implementing Database Design Patterns/005 005-db.sql 1.5 KB
04 - Relating Records with Joins/015 Exercise Overview.srt 1.5 KB
09 - Assembling Queries with SubQueries/017 Exercise Overview.srt 1.5 KB
02 - Filtering Records/006 A Where Solution.srt 1.5 KB
32 - Schema vs Data Migrations/005 005-index.js 1.3 KB
21 - Approaching and Writing Complex Queries/008 Likes Per User.srt 1.3 KB
21 - Approaching and Writing Complex Queries/001 Quick Note About Adding Some Data.html 1.3 KB
03 - Working with Tables/021 015-tables-cumulative.sql 1.3 KB
09 - Assembling Queries with SubQueries/030 Exercise Overview.srt 1.3 KB
01 - Simple - But Powerful - SQL Statements/002 Course Resources.html 1.3 KB
05 - Aggregation of Records/008 Exercise Overview.srt 1.2 KB
05 - Aggregation of Records/011 Adding a Layer of Difficulty.srt 1.1 KB
20 - Implementing Database Design Patterns/004 004-db.sql 1.1 KB
02 - Filtering Records/007 Where With Lists.srt 1.1 KB
32 - Schema vs Data Migrations/006 Web Server Setup Instructions.html 1.0 KB
10 - Selecting Distinct Records/004 A Distinct Solution.srt 1006 bytes
03 - Working with Tables/020 014-tables-cumulative.sql 994 bytes
02 - Filtering Records/004 A Where Exercise Overview.srt 946 bytes
32 - Schema vs Data Migrations/011 Migrations Setup Instructions.html 925 bytes
10 - Selecting Distinct Records/002 Exercise Overview.srt 879 bytes
20 - Implementing Database Design Patterns/003 003-db.sql 791 bytes
09 - Assembling Queries with SubQueries/024 Exercise Overview.srt 746 bytes
03 - Working with Tables/019 Commands You’ll Need for the Next Video.html 691 bytes
07 - Sorting Records/004 Exercise Overview.srt 688 bytes
03 - Working with Tables/017 012-tables-cumulative.sql 600 bytes
03 - Working with Tables/013 009-tables-cumulative.sql 536 bytes
03 - Working with Tables/020 014-tables.sql 469 bytes
15 - Database Structure Design Patterns/005 005-design.dbml 455 bytes
01 - Simple - But Powerful - SQL Statements/015 012-sql.sql 404 bytes
01 - Simple - But Powerful - SQL Statements/008 005-sql-cumulative.sql 384 bytes
20 - Implementing Database Design Patterns/002 002-db.sql 375 bytes
32 - Schema vs Data Migrations/011 01-lng-lat-to-loc.js 364 bytes
03 - Working with Tables/012 008-tables-cumulative.sql 348 bytes
03 - Working with Tables/021 015-tables.sql 340 bytes
03 - Working with Tables/013 009-tables.sql 326 bytes
01 - Simple - But Powerful - SQL Statements/001 Join Our Community!.html 318 bytes
01 - Simple - But Powerful - SQL Statements/008 005-sql.sql 278 bytes
31 - Managing Database Design with Schema Migrations/005 A Note About Node Installation.html 264 bytes
03 - Working with Tables/017 012-tables.sql 199 bytes
03 - Working with Tables/012 008-tables.sql 197 bytes
03 - Working with Tables/011 007-tables.sql 194 bytes
03 - Working with Tables/011 007-tables-cumulative.sql 172 bytes
01 - Simple - But Powerful - SQL Statements/006 003-sql.sql 104 bytes
02 - Filtering Records/001 013-sql.sql 48 bytes

Udemy - SQL and PostgreSQL The Complete Developer's Guide (7.2024)

File List

Download Torrent

Related Resources

Copyright Infringement