Torrent Info
Title Complete Intro to SQL & PostgreSQL
Category
Size 2.92GB

Files List
Please note that this page does not hosts or makes available any of the listed filenames. You cannot download any of those files from here.
1. Analyzing Queries with EXPLAIN.mp4 82.69MB
1. Creating Views & Inserting Data.mp4 47.12MB
1. Inserting Data and Managing Conflicts.mp4 84.91MB
1. Introduction.mp4 84.91MB
1. JSON vs. JSONB.mp4 66.23MB
1. SQL Overview & Creating a Database.mp4 93.06MB
1. Storing Queries with Functions.mp4 102.52MB
1. The Movie Database Setup.mp4 47.73MB
1. Transactions.mp4 92.31MB
1. Understanding Aggregation.mp4 24.52MB
1. Understanding Relationships & Joins.mp4 81.36MB
1. Wrapping Up.mp4 23.26MB
2. Adding JSONB to Recipes Table.mp4 61.66MB
2. Creating & Populating a Table.mp4 61.39MB
2. Filtering Aggregates with HAVING.mp4 38.79MB
2. Functions vs. Procedures.mp4 51.08MB
2. Identifying what to Index.mp4 37.13MB
2. Joining Between Views.mp4 45.56MB
2. Left, Right, & Outer Joins.mp4 43.82MB
2. SQL Setup with Docker.mp4 61.22MB
2. The Movie Database Exercise.mp4 32.21MB
2. Updating & Deleting Data.mp4 44.93MB
2. Window Functions.mp4 62.32MB
3. Altering a Table & Postgres Data Types.mp4 73.63MB
3. Calling Functions with Triggers.mp4 66.30MB
3. Creating an Index.mp4 58.16MB
3. Natural & Cross Joins.mp4 25.83MB
3. Optimizing Queries with Materialized Views.mp4 65.74MB
3. Selecting, Paginating, & Using Where Clauses.mp4 89.91MB
3. Self Join.mp4 32.09MB
3. The Movie Database Solution Most Money.mp4 13.83MB
3. When to Use JSONB.mp4 34.52MB
4. Foreign Keys & Managing References.mp4 41.15MB
4. Indexing Materialized Views.mp4 21.36MB
4. The Movie Database Solution Keanu Reeves.mp4 31.48MB
4. Using a GIN Index.mp4 61.03MB
4. Using LIKE, ILIKE, & SQL Functions.mp4 51.65MB
5. Creating a Partial Index.mp4 39.08MB
5. Many-to-Many Relationship.mp4 83.42MB
5. node-postgres & SQL Injection.mp4 64.93MB
5. The Movie Database Solution Most Revenue.mp4 60.67MB
5. Using Subqueries.mp4 30.23MB
6. Creating an Array from a Subquery.mp4 39.92MB
6. Indexing a Derivative Value.mp4 38.05MB
6. Ingredients API Exercise.mp4 73.09MB
6. The Movie Database Solution Most Keywords.mp4 18.90MB
6. Using the CHECK Constraint.mp4 48.53MB
7. Ingredients API Solution.mp4 143.28MB
7. The Movie Database Solution Most Movies.mp4 31.44MB
7. Using the DISTINCT Statement.mp4 68.88MB
8. Recipes Exercise.mp4 43.69MB
8. Setup pgAdmin.mp4 49.33MB
9. Recipes Solution.mp4 123.49MB