| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/3. SQL Commands/7. Ingredients API Solution.mp4 |
143.3 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/1. Introduction/1. Introduction.mp4 |
84.9 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/1. Introduction/1. Introduction.vtt |
18 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/1. Introduction/2. SQL Setup with Docker.mp4 |
61.2 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/1. Introduction/2. SQL Setup with Docker.vtt |
12 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/2. Databases and Tables/1. SQL Overview & Creating a Database.mp4 |
93.1 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/2. Databases and Tables/1. SQL Overview & Creating a Database.vtt |
20 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/2. Databases and Tables/2. Creating & Populating a Table.mp4 |
61.4 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/2. Databases and Tables/2. Creating & Populating a Table.vtt |
13 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/2. Databases and Tables/3. Altering a Table & Postgres Data Types.mp4 |
73.6 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/2. Databases and Tables/3. Altering a Table & Postgres Data Types.vtt |
14 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/3. SQL Commands/1. Inserting Data and Managing Conflicts.mp4 |
119.1 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/3. SQL Commands/2. Updating & Deleting Data.mp4 |
44.9 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/3. SQL Commands/2. Updating & Deleting Data.vtt |
9 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/3. SQL Commands/3. Selecting, Paginating, & Using Where Clauses.mp4 |
89.9 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/3. SQL Commands/3. Selecting, Paginating, & Using Where Clauses.vtt |
20 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/3. SQL Commands/4. Using LIKE, ILIKE, & SQL Functions.mp4 |
51.6 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/3. SQL Commands/4. Using LIKE, ILIKE, & SQL Functions.vtt |
10 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/3. SQL Commands/5. node-postgres & SQL Injection.mp4 |
64.9 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/3. SQL Commands/5. node-postgres & SQL Injection.vtt |
13 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/3. SQL Commands/6. Ingredients API Exercise.mp4 |
73.1 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/3. SQL Commands/6. Ingredients API Exercise.vtt |
12 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/Readme.txt |
138 B |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/3. SQL Commands/7. Ingredients API Solution.vtt |
14 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/1. Understanding Relationships & Joins.mp4 |
81.4 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/1. Understanding Relationships & Joins.vtt |
14 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/2. Left, Right, & Outer Joins.mp4 |
43.8 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/2. Left, Right, & Outer Joins.vtt |
9 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/3. Natural & Cross Joins.mp4 |
25.8 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/3. Natural & Cross Joins.vtt |
4 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/4. Foreign Keys & Managing References.mp4 |
41.1 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/4. Foreign Keys & Managing References.vtt |
7 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/5. Many-to-Many Relationship.mp4 |
83.4 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/5. Many-to-Many Relationship.vtt |
13 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/6. Using the CHECK Constraint.mp4 |
48.5 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/6. Using the CHECK Constraint.vtt |
7 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/7. Using the DISTINCT Statement.mp4 |
68.9 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/7. Using the DISTINCT Statement.vtt |
10 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/8. Recipes Exercise.mp4 |
43.7 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/8. Recipes Exercise.vtt |
5 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/9. Recipes Solution.mp4 |
123.5 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/4. Joins and Constraints/9. Recipes Solution.vtt |
14 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/5. JSONB/1. JSON vs. JSONB.mp4 |
66.2 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/5. JSONB/1. JSON vs. JSONB.vtt |
14 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/5. JSONB/2. Adding JSONB to Recipes Table.mp4 |
61.7 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/5. JSONB/2. Adding JSONB to Recipes Table.vtt |
13 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/5. JSONB/3. When to Use JSONB.mp4 |
34.5 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/5. JSONB/3. When to Use JSONB.vtt |
7 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/6. Aggregation/1. Understanding Aggregation.mp4 |
24.5 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/6. Aggregation/1. Understanding Aggregation.vtt |
7 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/6. Aggregation/2. Filtering Aggregates with HAVING.mp4 |
38.8 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/6. Aggregation/2. Filtering Aggregates with HAVING.vtt |
8 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/7. Functions Triggers and Procedures/1. Storing Queries with Functions.mp4 |
102.5 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/7. Functions Triggers and Procedures/1. Storing Queries with Functions.vtt |
19 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/7. Functions Triggers and Procedures/2. Functions vs. Procedures.mp4 |
51.1 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/7. Functions Triggers and Procedures/2. Functions vs. Procedures.vtt |
11 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/7. Functions Triggers and Procedures/3. Calling Functions with Triggers.mp4 |
66.3 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/7. Functions Triggers and Procedures/3. Calling Functions with Triggers.vtt |
11 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/1. The Movie Database Setup.mp4 |
47.7 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/1. The Movie Database Setup.vtt |
8 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/2. The Movie Database Exercise.mp4 |
32.2 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/2. The Movie Database Exercise.vtt |
5 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/3. The Movie Database Solution Most Money.mp4 |
13.8 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/3. The Movie Database Solution Most Money.vtt |
4 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/4. The Movie Database Solution Keanu Reeves.mp4 |
31.5 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/4. The Movie Database Solution Keanu Reeves.vtt |
5 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/5. The Movie Database Solution Most Revenue.mp4 |
60.7 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/5. The Movie Database Solution Most Revenue.vtt |
13 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/6. The Movie Database Solution Most Keywords.mp4 |
18.9 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/6. The Movie Database Solution Most Keywords.vtt |
3 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/7. The Movie Database Solution Most Movies.mp4 |
31.4 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/7. The Movie Database Solution Most Movies.vtt |
6 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/8. Setup pgAdmin.mp4 |
49.3 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/8. The Movie Database/8. Setup pgAdmin.vtt |
9 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/9. Query Performance/1. Analyzing Queries with EXPLAIN.mp4 |
82.7 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/9. Query Performance/1. Analyzing Queries with EXPLAIN.vtt |
15 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/9. Query Performance/2. Identifying what to Index.mp4 |
37.1 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/9. Query Performance/2. Identifying what to Index.vtt |
8 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/9. Query Performance/3. Creating an Index.mp4 |
58.2 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/9. Query Performance/3. Creating an Index.vtt |
12 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/9. Query Performance/4. Using a GIN Index.mp4 |
61 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/9. Query Performance/4. Using a GIN Index.vtt |
12 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/9. Query Performance/5. Creating a Partial Index.mp4 |
39.1 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/9. Query Performance/5. Creating a Partial Index.vtt |
6 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/9. Query Performance/6. Indexing a Derivative Value.mp4 |
38 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/9. Query Performance/6. Indexing a Derivative Value.vtt |
7 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/10. Views, Subqueries & Arrays/1. Creating Views & Inserting Data.mp4 |
47.1 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/10. Views, Subqueries & Arrays/1. Creating Views & Inserting Data.vtt |
11 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/10. Views, Subqueries & Arrays/2. Joining Between Views.mp4 |
45.6 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/10. Views, Subqueries & Arrays/2. Joining Between Views.vtt |
8 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/10. Views, Subqueries & Arrays/3. Optimizing Queries with Materialized Views.mp4 |
65.7 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/10. Views, Subqueries & Arrays/3. Optimizing Queries with Materialized Views.vtt |
11 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/10. Views, Subqueries & Arrays/4. Indexing Materialized Views.mp4 |
21.4 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/10. Views, Subqueries & Arrays/4. Indexing Materialized Views.vtt |
3 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/10. Views, Subqueries & Arrays/5. Using Subqueries.mp4 |
30.2 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/10. Views, Subqueries & Arrays/5. Using Subqueries.vtt |
6 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/10. Views, Subqueries & Arrays/6. Creating an Array from a Subquery.mp4 |
39.9 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/10. Views, Subqueries & Arrays/6. Creating an Array from a Subquery.vtt |
6 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/11. Transactions, Window Functions, and Self Join/1. Transactions.mp4 |
92.3 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/11. Transactions, Window Functions, and Self Join/1. Transactions.vtt |
16 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/11. Transactions, Window Functions, and Self Join/2. Window Functions.mp4 |
62.3 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/11. Transactions, Window Functions, and Self Join/2. Window Functions.vtt |
9 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/11. Transactions, Window Functions, and Self Join/3. Self Join.mp4 |
32.1 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/11. Transactions, Window Functions, and Self Join/3. Self Join.vtt |
7 KB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/12. Wrapping Up/1. Wrapping Up.mp4 |
23.3 MB |
| Frontend Masters - Complete Intro to SQL & PostgreSQL 2023-1/12. Wrapping Up/1. Wrapping Up.vtt |
5 KB |