Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1
File List
- 3. SQL Commands/7. Ingredients API Solution.mp4 143.3 MB
- 4. Joins and Constraints/9. Recipes Solution.mp4 123.5 MB
- 3. SQL Commands/1. Inserting Data and Managing Conflicts.mp4 119.1 MB
- 7. Functions Triggers and Procedures/1. Storing Queries with Functions.mp4 102.5 MB
- 2. Databases and Tables/1. SQL Overview & Creating a Database.mp4 93.1 MB
- 11. Transactions, Window Functions, and Self Join/1. Transactions.mp4 92.3 MB
- 3. SQL Commands/3. Selecting, Paginating, & Using Where Clauses.mp4 89.9 MB
- 1. Introduction/1. Introduction.mp4 84.9 MB
- 4. Joins and Constraints/5. Many-to-Many Relationship.mp4 83.4 MB
- 9. Query Performance/1. Analyzing Queries with EXPLAIN.mp4 82.7 MB
- 4. Joins and Constraints/1. Understanding Relationships & Joins.mp4 81.4 MB
- 2. Databases and Tables/3. Altering a Table & Postgres Data Types.mp4 73.6 MB
- 3. SQL Commands/6. Ingredients API Exercise.mp4 73.1 MB
- 4. Joins and Constraints/7. Using the DISTINCT Statement.mp4 68.9 MB
- 7. Functions Triggers and Procedures/3. Calling Functions with Triggers.mp4 66.3 MB
- 5. JSONB/1. JSON vs. JSONB.mp4 66.2 MB
- 10. Views, Subqueries & Arrays/3. Optimizing Queries with Materialized Views.mp4 65.7 MB
- 3. SQL Commands/5. node-postgres & SQL Injection.mp4 64.9 MB
- 11. Transactions, Window Functions, and Self Join/2. Window Functions.mp4 62.3 MB
- 5. JSONB/2. Adding JSONB to Recipes Table.mp4 61.7 MB
- 2. Databases and Tables/2. Creating & Populating a Table.mp4 61.4 MB
- 1. Introduction/2. SQL Setup with Docker.mp4 61.2 MB
- 9. Query Performance/4. Using a GIN Index.mp4 61.0 MB
- 8. The Movie Database/5. The Movie Database Solution Most Revenue.mp4 60.7 MB
- 9. Query Performance/3. Creating an Index.mp4 58.2 MB
- 3. SQL Commands/4. Using LIKE, ILIKE, & SQL Functions.mp4 51.6 MB
- 7. Functions Triggers and Procedures/2. Functions vs. Procedures.mp4 51.1 MB
- 8. The Movie Database/8. Setup pgAdmin.mp4 49.3 MB
- 4. Joins and Constraints/6. Using the CHECK Constraint.mp4 48.5 MB
- 8. The Movie Database/1. The Movie Database Setup.mp4 47.7 MB
- 10. Views, Subqueries & Arrays/1. Creating Views & Inserting Data.mp4 47.1 MB
- 10. Views, Subqueries & Arrays/2. Joining Between Views.mp4 45.6 MB
- 3. SQL Commands/2. Updating & Deleting Data.mp4 44.9 MB
- 4. Joins and Constraints/2. Left, Right, & Outer Joins.mp4 43.8 MB
- 4. Joins and Constraints/8. Recipes Exercise.mp4 43.7 MB
- 4. Joins and Constraints/4. Foreign Keys & Managing References.mp4 41.1 MB
- 10. Views, Subqueries & Arrays/6. Creating an Array from a Subquery.mp4 39.9 MB
- 9. Query Performance/5. Creating a Partial Index.mp4 39.1 MB
- 6. Aggregation/2. Filtering Aggregates with HAVING.mp4 38.8 MB
- 9. Query Performance/6. Indexing a Derivative Value.mp4 38.0 MB
- 9. Query Performance/2. Identifying what to Index.mp4 37.1 MB
- 5. JSONB/3. When to Use JSONB.mp4 34.5 MB
- 8. The Movie Database/2. The Movie Database Exercise.mp4 32.2 MB
- 11. Transactions, Window Functions, and Self Join/3. Self Join.mp4 32.1 MB
- 8. The Movie Database/4. The Movie Database Solution Keanu Reeves.mp4 31.5 MB
- 8. The Movie Database/7. The Movie Database Solution Most Movies.mp4 31.4 MB
- 10. Views, Subqueries & Arrays/5. Using Subqueries.mp4 30.2 MB
- 4. Joins and Constraints/3. Natural & Cross Joins.mp4 25.8 MB
- 6. Aggregation/1. Understanding Aggregation.mp4 24.5 MB
- 12. Wrapping Up/1. Wrapping Up.mp4 23.3 MB
- 10. Views, Subqueries & Arrays/4. Indexing Materialized Views.mp4 21.4 MB
- 8. The Movie Database/6. The Movie Database Solution Most Keywords.mp4 18.9 MB
- 8. The Movie Database/3. The Movie Database Solution Most Money.mp4 13.8 MB
- 3. SQL Commands/3. Selecting, Paginating, & Using Where Clauses.vtt 20.5 KB
- 2. Databases and Tables/1. SQL Overview & Creating a Database.vtt 20.3 KB
- 7. Functions Triggers and Procedures/1. Storing Queries with Functions.vtt 18.6 KB
- 1. Introduction/1. Introduction.vtt 18.2 KB
- 11. Transactions, Window Functions, and Self Join/1. Transactions.vtt 16.0 KB
- 9. Query Performance/1. Analyzing Queries with EXPLAIN.vtt 15.5 KB
- 5. JSONB/1. JSON vs. JSONB.vtt 14.3 KB
- 4. Joins and Constraints/1. Understanding Relationships & Joins.vtt 14.0 KB
- 4. Joins and Constraints/9. Recipes Solution.vtt 13.9 KB
- 3. SQL Commands/7. Ingredients API Solution.vtt 13.8 KB
- 2. Databases and Tables/3. Altering a Table & Postgres Data Types.vtt 13.7 KB
- 5. JSONB/2. Adding JSONB to Recipes Table.vtt 13.5 KB
- 8. The Movie Database/5. The Movie Database Solution Most Revenue.vtt 13.3 KB
- 2. Databases and Tables/2. Creating & Populating a Table.vtt 13.1 KB
- 4. Joins and Constraints/5. Many-to-Many Relationship.vtt 12.8 KB
- 3. SQL Commands/5. node-postgres & SQL Injection.vtt 12.6 KB
- 1. Introduction/2. SQL Setup with Docker.vtt 12.2 KB
- 9. Query Performance/3. Creating an Index.vtt 12.0 KB
- 3. SQL Commands/6. Ingredients API Exercise.vtt 11.7 KB
- 9. Query Performance/4. Using a GIN Index.vtt 11.6 KB
- 7. Functions Triggers and Procedures/3. Calling Functions with Triggers.vtt 11.5 KB
- 10. Views, Subqueries & Arrays/1. Creating Views & Inserting Data.vtt 11.4 KB
- 7. Functions Triggers and Procedures/2. Functions vs. Procedures.vtt 11.1 KB
- 10. Views, Subqueries & Arrays/3. Optimizing Queries with Materialized Views.vtt 10.5 KB
- 4. Joins and Constraints/7. Using the DISTINCT Statement.vtt 10.5 KB
- 3. SQL Commands/4. Using LIKE, ILIKE, & SQL Functions.vtt 10.2 KB
- 11. Transactions, Window Functions, and Self Join/2. Window Functions.vtt 9.3 KB
- 8. The Movie Database/8. Setup pgAdmin.vtt 9.1 KB
- 3. SQL Commands/2. Updating & Deleting Data.vtt 8.8 KB
- 4. Joins and Constraints/2. Left, Right, & Outer Joins.vtt 8.7 KB
- 6. Aggregation/2. Filtering Aggregates with HAVING.vtt 8.3 KB
- 8. The Movie Database/1. The Movie Database Setup.vtt 8.0 KB
- 9. Query Performance/2. Identifying what to Index.vtt 7.7 KB
- 10. Views, Subqueries & Arrays/2. Joining Between Views.vtt 7.7 KB
- 9. Query Performance/6. Indexing a Derivative Value.vtt 7.4 KB
- 4. Joins and Constraints/6. Using the CHECK Constraint.vtt 7.3 KB
- 4. Joins and Constraints/4. Foreign Keys & Managing References.vtt 7.3 KB
- 11. Transactions, Window Functions, and Self Join/3. Self Join.vtt 6.9 KB
- 6. Aggregation/1. Understanding Aggregation.vtt 6.7 KB
- 5. JSONB/3. When to Use JSONB.vtt 6.6 KB
- 10. Views, Subqueries & Arrays/6. Creating an Array from a Subquery.vtt 6.2 KB
- 9. Query Performance/5. Creating a Partial Index.vtt 6.2 KB
- 10. Views, Subqueries & Arrays/5. Using Subqueries.vtt 6.0 KB
- 8. The Movie Database/7. The Movie Database Solution Most Movies.vtt 5.8 KB
- 12. Wrapping Up/1. Wrapping Up.vtt 5.4 KB
- 8. The Movie Database/2. The Movie Database Exercise.vtt 5.3 KB
- 8. The Movie Database/4. The Movie Database Solution Keanu Reeves.vtt 4.8 KB
- 4. Joins and Constraints/8. Recipes Exercise.vtt 4.6 KB
- 4. Joins and Constraints/3. Natural & Cross Joins.vtt 4.0 KB
- 8. The Movie Database/3. The Movie Database Solution Most Money.vtt 3.6 KB
- 8. The Movie Database/6. The Movie Database Solution Most Keywords.vtt 3.4 KB
- 10. Views, Subqueries & Arrays/4. Indexing Materialized Views.vtt 3.2 KB
- Readme.txt 138 bytes
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via anywarmservice[AT]gmail.com. Remember to include the full url in your complaint.