Name Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1

File Type video

Size 2.96GB

UpdateDate 2025-1-9

hash *****AE5C7D53C6FDA048C86FA3621D87B7AA12

Hot 1

Files 3. SQL Commands/7. Ingredients API Solution.mp4 | 143.28MB 1. Introduction/1. Introduction.mp4 | 84.91MB 1. Introduction/1. Introduction.vtt | 18.24KB 1. Introduction/2. SQL Setup with Docker.mp4 | 61.22MB 1. Introduction/2. SQL Setup with Docker.vtt | 12.16KB 2. Databases and Tables/1. SQL Overview & Creating a Database.mp4 | 93.06MB 2. Databases and Tables/1. SQL Overview & Creating a Database.vtt | 20.27KB 2. Databases and Tables/2. Creating & Populating a Table.mp4 | 61.39MB 2. Databases and Tables/2. Creating & Populating a Table.vtt | 13.05KB 2. Databases and Tables/3. Altering a Table & Postgres Data Types.mp4 | 73.63MB 2. Databases and Tables/3. Altering a Table & Postgres Data Types.vtt | 13.71KB 3. SQL Commands/1. Inserting Data and Managing Conflicts.mp4 | 119.11MB 3. SQL Commands/2. Updating & Deleting Data.mp4 | 44.93MB 3. SQL Commands/2. Updating & Deleting Data.vtt | 8.84KB 3. SQL Commands/3. Selecting, Paginating, & Using Where Clauses.mp4 | 89.91MB 3. SQL Commands/3. Selecting, Paginating, & Using Where Clauses.vtt | 20.49KB 3. SQL Commands/4. Using LIKE, ILIKE, & SQL Functions.mp4 | 51.65MB 3. SQL Commands/4. Using LIKE, ILIKE, & SQL Functions.vtt | 10.15KB 3. SQL Commands/5. node-postgres & SQL Injection.mp4 | 64.93MB 3. SQL Commands/5. node-postgres & SQL Injection.vtt | 12.60KB 3. SQL Commands/6. Ingredients API Exercise.mp4 | 73.09MB 3. SQL Commands/6. Ingredients API Exercise.vtt | 11.74KB Readme.txt | 138B 3. SQL Commands/7. Ingredients API Solution.vtt | 13.85KB 4. Joins and Constraints/1. Understanding Relationships & Joins.mp4 | 81.36MB 4. Joins and Constraints/1. Understanding Relationships & Joins.vtt | 13.97KB 4. Joins and Constraints/2. Left, Right, & Outer Joins.mp4 | 43.82MB 4. Joins and Constraints/2. Left, Right, & Outer Joins.vtt | 8.68KB 4. Joins and Constraints/3. Natural & Cross Joins.mp4 | 25.83MB 4. Joins and Constraints/3. Natural & Cross Joins.vtt | 4.00KB 4. Joins and Constraints/4. Foreign Keys & Managing References.mp4 | 41.15MB 4. Joins and Constraints/4. Foreign Keys & Managing References.vtt | 7.28KB 4. Joins and Constraints/5. Many-to-Many Relationship.mp4 | 83.42MB 4. Joins and Constraints/5. Many-to-Many Relationship.vtt | 12.80KB 4. Joins and Constraints/6. Using the CHECK Constraint.mp4 | 48.53MB 4. Joins and Constraints/6. Using the CHECK Constraint.vtt | 7.32KB 4. Joins and Constraints/7. Using the DISTINCT Statement.mp4 | 68.88MB 4. Joins and Constraints/7. Using the DISTINCT Statement.vtt | 10.47KB 4. Joins and Constraints/8. Recipes Exercise.mp4 | 43.69MB 4. Joins and Constraints/8. Recipes Exercise.vtt | 4.60KB 4. Joins and Constraints/9. Recipes Solution.mp4 | 123.49MB 4. Joins and Constraints/9. Recipes Solution.vtt | 13.90KB 5. JSONB/1. JSON vs. JSONB.mp4 | 66.23MB 5. JSONB/1. JSON vs. JSONB.vtt | 14.31KB 5. JSONB/2. Adding JSONB to Recipes Table.mp4 | 61.66MB 5. JSONB/2. Adding JSONB to Recipes Table.vtt | 13.46KB 5. JSONB/3. When to Use JSONB.mp4 | 34.52MB 5. JSONB/3. When to Use JSONB.vtt | 6.55KB 6. Aggregation/1. Understanding Aggregation.mp4 | 24.52MB 6. Aggregation/1. Understanding Aggregation.vtt | 6.67KB 6. Aggregation/2. Filtering Aggregates with HAVING.mp4 | 38.79MB 6. Aggregation/2. Filtering Aggregates with HAVING.vtt | 8.27KB 7. Functions Triggers and Procedures/1. Storing Queries with Functions.mp4 | 102.52MB 7. Functions Triggers and Procedures/1. Storing Queries with Functions.vtt | 18.56KB 7. Functions Triggers and Procedures/2. Functions vs. Procedures.mp4 | 51.08MB 7. Functions Triggers and Procedures/2. Functions vs. Procedures.vtt | 11.06KB 7. Functions Triggers and Procedures/3. Calling Functions with Triggers.mp4 | 66.30MB 7. Functions Triggers and Procedures/3. Calling Functions with Triggers.vtt | 11.50KB 8. The Movie Database/1. The Movie Database Setup.mp4 | 47.73MB 8. The Movie Database/1. The Movie Database Setup.vtt | 8.00KB 8. The Movie Database/2. The Movie Database Exercise.mp4 | 32.21MB 8. The Movie Database/2. The Movie Database Exercise.vtt | 5.34KB 8. The Movie Database/3. The Movie Database Solution Most Money.mp4 | 13.83MB 8. The Movie Database/3. The Movie Database Solution Most Money.vtt | 3.57KB 8. The Movie Database/4. The Movie Database Solution Keanu Reeves.mp4 | 31.48MB 8. The Movie Database/4. The Movie Database Solution Keanu Reeves.vtt | 4.85KB 8. The Movie Database/5. The Movie Database Solution Most Revenue.mp4 | 60.67MB 8. The Movie Database/5. The Movie Database Solution Most Revenue.vtt | 13.26KB 8. The Movie Database/6. The Movie Database Solution Most Keywords.mp4 | 18.90MB 8. The Movie Database/6. The Movie Database Solution Most Keywords.vtt | 3.37KB 8. The Movie Database/7. The Movie Database Solution Most Movies.mp4 | 31.44MB 8. The Movie Database/7. The Movie Database Solution Most Movies.vtt | 5.76KB 8. The Movie Database/8. Setup pgAdmin.mp4 | 49.33MB 8. The Movie Database/8. Setup pgAdmin.vtt | 9.13KB 9. Query Performance/1. Analyzing Queries with EXPLAIN.mp4 | 82.69MB 9. Query Performance/1. Analyzing Queries with EXPLAIN.vtt | 15.47KB 9. Query Performance/2. Identifying what to Index.mp4 | 37.13MB 9. Query Performance/2. Identifying what to Index.vtt | 7.73KB 9. Query Performance/3. Creating an Index.mp4 | 58.16MB 9. Query Performance/3. Creating an Index.vtt | 12.00KB 9. Query Performance/4. Using a GIN Index.mp4 | 61.03MB 9. Query Performance/4. Using a GIN Index.vtt | 11.63KB 9. Query Performance/5. Creating a Partial Index.mp4 | 39.08MB 9. Query Performance/5. Creating a Partial Index.vtt | 6.16KB 9. Query Performance/6. Indexing a Derivative Value.mp4 | 38.05MB 9. Query Performance/6. Indexing a Derivative Value.vtt | 7.43KB 10. Views, Subqueries & Arrays/1. Creating Views & Inserting Data.mp4 | 47.12MB 10. Views, Subqueries & Arrays/1. Creating Views & Inserting Data.vtt | 11.42KB 10. Views, Subqueries & Arrays/2. Joining Between Views.mp4 | 45.56MB 10. Views, Subqueries & Arrays/2. Joining Between Views.vtt | 7.71KB 10. Views, Subqueries & Arrays/3. Optimizing Queries with Materialized Views.mp4 | 65.74MB 10. Views, Subqueries & Arrays/3. Optimizing Queries with Materialized Views.vtt | 10.54KB 10. Views, Subqueries & Arrays/4. Indexing Materialized Views.mp4 | 21.36MB 10. Views, Subqueries & Arrays/4. Indexing Materialized Views.vtt | 3.18KB 10. Views, Subqueries & Arrays/5. Using Subqueries.mp4 | 30.23MB 10. Views, Subqueries & Arrays/5. Using Subqueries.vtt | 5.97KB 10. Views, Subqueries & Arrays/6. Creating an Array from a Subquery.mp4 | 39.92MB 10. Views, Subqueries & Arrays/6. Creating an Array from a Subquery.vtt | 6.20KB 11. Transactions, Window Functions, and Self Join/1. Transactions.mp4 | 92.31MB 11. Transactions, Window Functions, and Self Join/1. Transactions.vtt | 16.04KB 11. Transactions, Window Functions, and Self Join/2. Window Functions.mp4 | 62.32MB 11. Transactions, Window Functions, and Self Join/2. Window Functions.vtt | 9.33KB 11. Transactions, Window Functions, and Self Join/3. Self Join.mp4 | 32.09MB 11. Transactions, Window Functions, and Self Join/3. Self Join.vtt | 6.88KB 12. Wrapping Up/1. Wrapping Up.mp4 | 23.26MB 12. Wrapping Up/1. Wrapping Up.vtt | 5.39KB