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

• 22 - Understanding the Internals of PostgreSQL/006 Heap File Layout.mp4-338.39 MB
• 23 - A Look at Indexes for Performance/010 Behind the Scenes of Indexes.mp4-238.29 MB
• 31 - Managing Database Design with Schema Migrations/001 A Story on Migrations.mp4-88.61 MB
• 04 - Relating Records with Joins/011 Four Kinds of Joins.mp4-75.16 MB
• 09 - Assembling Queries with SubQueries/027 Probably Too Much About Correlated Subqueries.mp4-66.89 MB
• 27 - Recursive Common Table Expressions/005 Walking Through Recursion.mp4-65.98 MB
• 25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost.mp4-64.58 MB
• 32 - Schema vs Data Migrations/009 Transaction Locks.mp4-62.64 MB
• 18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System.mp4-60.55 MB
• 25 - Advanced Query Tuning/003 A Touch More on Costs.mp4-55.34 MB
• 17 - How to Build a 'Mention' System/001 Additional Features Around Posts.mp4-54.04 MB
• 24 - Basic Query Tuning/004 Solving an Explain Mystery.mp4-49.05 MB
• 32 - Schema vs Data Migrations/002 Dangers Around Data Migrations.mp4-44.32 MB
• 17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions.mp4-44.21 MB
• 23 - A Look at Indexes for Performance/003 How an Index Works.mp4-43.22 MB
• 17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags.mp4-42.88 MB
• 30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions.mp4-42.15 MB
• 03 - Working with Tables/009 Understanding Foreign Keys.mp4-41.56 MB
• 36 - Fast Parallel Testing/013 Programmatic Schema Creation.mp4-41.17 MB
• 32 - Schema vs Data Migrations/005 A Small Web Server.mp4-40.67 MB
• 31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations.mp4-40.15 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.08 MB
• 16 - How to Build a 'Like' System/007 Polymorphic Association Alternative Implementation.mp4-39.49 MB
• 04 - Relating Records with Joins/013 Does Order Matter.mp4-35.92 MB
• 01 - Simple - But Powerful - SQL Statements/004 Database Design.mp4-35.37 MB
• 29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query.mp4-35.07 MB
• 09 - Assembling Queries with SubQueries/010 Example of a Subquery in a From.mp4-34.37 MB
• 16 - How to Build a 'Like' System/006 Polymorphic Associations.mp4-33.43 MB
• 15 - Database Structure Design Patterns/002 Using a SQL Design Tool.mp4-32.43 MB
• 25 - Advanced Query Tuning/002 Calculating Cost by Hand.mp4-32.19 MB
• 04 - Relating Records with Joins/019 Three Way Joins.mp4-32.08 MB
• 36 - Fast Parallel Testing/003 Connecting to a DB For Tests.mp4-32 MB
• 13 - PostgreSQL Complex Datatypes/004 More on Number Data Types.mp4-30.51 MB
• 03 - Working with Tables/002 Approaching Database Design.mp4-30.48 MB
• 34 - Data Access Pattern - Repositories/005 Fixing Casing.mp4-30.31 MB
• 31 - Managing Database Design with Schema Migrations/002 Migration Files.mp4-28.84 MB
• 25 - Advanced Query Tuning/005 Startup vs Total Costs.mp4-28.66 MB
• 31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations.mp4-28.53 MB
• 09 - Assembling Queries with SubQueries/008 Subqueries in a From.mp4-28.32 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.85 MB
• 09 - Assembling Queries with SubQueries/016 Data Structure with Where Subqueries.mp4-27.68 MB
• 27 - Recursive Common Table Expressions/003 Why Use Recursive CTE's.mp4-27.27 MB
• 24 - Basic Query Tuning/002 Explain and Explain Analyze.mp4-27.15 MB
• 36 - Fast Parallel Testing/002 Assertions Around User Count.mp4-26.88 MB
• 14 - Database-Side Validation and Constraints/007 Applying a Unique Constraint to One column.mp4-26.77 MB
• 36 - Fast Parallel Testing/015 Test Helpers.mp4-26.41 MB
• 03 - Working with Tables/004 One-to-Many and Many-to-One Relationships.mp4-26.25 MB
• 03 - Working with Tables/018 Constraints Around Deletion.mp4-25.98 MB