TorBT - Torrents and Magnet Links Search Engine

Complete Intro to SQL & PostgreSQL

File Name
Size
3. SQL Commands/7. Ingredients API Solution.mp4
143 MB
1. Introduction/2. SQL Setup with Docker.mp4
61 MB
2. Databases and Tables/1. SQL Overview & Creating a Database.mp4
93 MB
2. Databases and Tables/2. Creating & Populating a Table.mp4
61 MB
2. Databases and Tables/3. Altering a Table & Postgres Data Types.mp4
74 MB
3. SQL Commands/1. Inserting Data and Managing Conflicts.mp4
85 MB
3. SQL Commands/2. Updating & Deleting Data.mp4
45 MB
3. SQL Commands/3. Selecting, Paginating, & Using Where Clauses.mp4
90 MB
3. SQL Commands/4. Using LIKE, ILIKE, & SQL Functions.mp4
52 MB
3. SQL Commands/5. node-postgres & SQL Injection.mp4
65 MB
3. SQL Commands/6. Ingredients API Exercise.mp4
73 MB
1. Introduction/1. Introduction.mp4
85 MB
4. Joins and Constraints/1. Understanding Relationships & Joins.mp4
81 MB
4. Joins and Constraints/2. Left, Right, & Outer Joins.mp4
44 MB
4. Joins and Constraints/3. Natural & Cross Joins.mp4
26 MB
4. Joins and Constraints/4. Foreign Keys & Managing References.mp4
41 MB
4. Joins and Constraints/5. Many-to-Many Relationship.mp4
83 MB
4. Joins and Constraints/6. Using the CHECK Constraint.mp4
48 MB
4. Joins and Constraints/7. Using the DISTINCT Statement.mp4
69 MB
4. Joins and Constraints/8. Recipes Exercise.mp4
44 MB
4. Joins and Constraints/9. Recipes Solution.mp4
124 MB
5. JSONB/1. JSON vs. JSONB.mp4
66 MB
5. JSONB/2. Adding JSONB to Recipes Table.mp4
62 MB
5. JSONB/3. When to Use JSONB.mp4
34 MB
6. Aggregation/1. Understanding Aggregation.mp4
24 MB
6. Aggregation/2. Filtering Aggregates with HAVING.mp4
39 MB
7. Functions Triggers and Procedures/1. Storing Queries with Functions.mp4
102 MB
7. Functions Triggers and Procedures/2. Functions vs. Procedures.mp4
51 MB
7. Functions Triggers and Procedures/3. Calling Functions with Triggers.mp4
66 MB
8. The Movie Database/1. The Movie Database Setup.mp4
48 MB
8. The Movie Database/2. The Movie Database Exercise.mp4
32 MB
8. The Movie Database/3. The Movie Database Solution Most Money.mp4
14 MB
8. The Movie Database/4. The Movie Database Solution Keanu Reeves.mp4
32 MB
8. The Movie Database/5. The Movie Database Solution Most Revenue.mp4
61 MB
8. The Movie Database/6. The Movie Database Solution Most Keywords.mp4
19 MB
8. The Movie Database/7. The Movie Database Solution Most Movies.mp4
31 MB
8. The Movie Database/8. Setup pgAdmin.mp4
49 MB
9. Query Performance/1. Analyzing Queries with EXPLAIN.mp4
83 MB
9. Query Performance/2. Identifying what to Index.mp4
37 MB
9. Query Performance/3. Creating an Index.mp4
58 MB
9. Query Performance/4. Using a GIN Index.mp4
61 MB
9. Query Performance/5. Creating a Partial Index.mp4
39 MB
9. Query Performance/6. Indexing a Derivative Value.mp4
38 MB
10. Views, Subqueries & Arrays/1. Creating Views & Inserting Data.mp4
47 MB
10. Views, Subqueries & Arrays/2. Joining Between Views.mp4
46 MB
10. Views, Subqueries & Arrays/3. Optimizing Queries with Materialized Views.mp4
66 MB
10. Views, Subqueries & Arrays/4. Indexing Materialized Views.mp4
21 MB
10. Views, Subqueries & Arrays/5. Using Subqueries.mp4
30 MB
10. Views, Subqueries & Arrays/6. Creating an Array from a Subquery.mp4
40 MB
11. Transactions, Window Functions, and Self Join/1. Transactions.mp4
92 MB
11. Transactions, Window Functions, and Self Join/2. Window Functions.mp4
62 MB
11. Transactions, Window Functions, and Self Join/3. Self Join.mp4
32 MB
12. Wrapping Up/1. Wrapping Up.mp4
23 MB