Complete Intro to SQL PostgreSQL | 4756FEF8E92483527303A5A850C8FFED048469DD

Complete Intro to SQL PostgreSQL

Name	Complete Intro to SQL & PostgreSQL	DOWNLOAD Copy Link
Total Size	3.1 GB
Total Files	53
Last Seen	2024-11-19 00:50
Hash	4756FEF8E92483527303A5A850C8FFED048469DD

/3. SQL Commands/
7. Ingredients API Solution.mp4	150.2 MB
1. Inserting Data and Managing Conflicts.mp4	89.0 MB
2. Updating & Deleting Data.mp4	47.1 MB
3. Selecting, Paginating, & Using Where Clauses.mp4	94.3 MB
4. Using LIKE, ILIKE, & SQL Functions.mp4	54.2 MB
5. node-postgres & SQL Injection.mp4	68.1 MB
6. Ingredients API Exercise.mp4	76.6 MB
/1. Introduction/
2. SQL Setup with Docker.mp4	64.2 MB
1. Introduction.mp4	89.0 MB
/2. Databases and Tables/
1. SQL Overview & Creating a Database.mp4	97.6 MB
2. Creating & Populating a Table.mp4	64.4 MB
3. Altering a Table & Postgres Data Types.mp4	77.2 MB
/4. Joins and Constraints/
1. Understanding Relationships & Joins.mp4	85.3 MB
2. Left, Right, & Outer Joins.mp4	45.9 MB
3. Natural & Cross Joins.mp4	27.1 MB
4. Foreign Keys & Managing References.mp4	43.1 MB
5. Many-to-Many Relationship.mp4	87.5 MB
6. Using the CHECK Constraint.mp4	50.9 MB
7. Using the DISTINCT Statement.mp4	72.2 MB
8. Recipes Exercise.mp4	45.8 MB
9. Recipes Solution.mp4	129.5 MB
/5. JSONB/
1. JSON vs. JSONB.mp4	69.4 MB
2. Adding JSONB to Recipes Table.mp4	64.7 MB
3. When to Use JSONB.mp4	36.2 MB
/6. Aggregation/
1. Understanding Aggregation.mp4	25.7 MB
2. Filtering Aggregates with HAVING.mp4	40.7 MB
/7. Functions Triggers and Procedures/
1. Storing Queries with Functions.mp4	107.5 MB
2. Functions vs. Procedures.mp4	53.6 MB
3. Calling Functions with Triggers.mp4	69.5 MB
/8. The Movie Database/
1. The Movie Database Setup.mp4	50.1 MB
2. The Movie Database Exercise.mp4	33.8 MB
3. The Movie Database Solution Most Money.mp4	14.5 MB
4. The Movie Database Solution Keanu Reeves.mp4	33.0 MB
5. The Movie Database Solution Most Revenue.mp4	63.6 MB
6. The Movie Database Solution Most Keywords.mp4	19.8 MB
7. The Movie Database Solution Most Movies.mp4	33.0 MB
8. Setup pgAdmin.mp4	51.7 MB
/9. Query Performance/
1. Analyzing Queries with EXPLAIN.mp4	86.7 MB
2. Identifying what to Index.mp4	38.9 MB
3. Creating an Index.mp4	61.0 MB
4. Using a GIN Index.mp4	64.0 MB
5. Creating a Partial Index.mp4	41.0 MB
6. Indexing a Derivative Value.mp4	39.9 MB
/10. Views, Subqueries & Arrays/
1. Creating Views & Inserting Data.mp4	49.4 MB
2. Joining Between Views.mp4	47.8 MB
3. Optimizing Queries with Materialized Views.mp4	68.9 MB
4. Indexing Materialized Views.mp4	22.4 MB
5. Using Subqueries.mp4	31.7 MB
6. Creating an Array from a Subquery.mp4	41.9 MB
/11. Transactions, Window Functions, and Self Join/
1. Transactions.mp4	96.8 MB
2. Window Functions.mp4	65.4 MB
3. Self Join.mp4	33.7 MB
/12. Wrapping Up/
1. Wrapping Up.mp4	24.4 MB
Total files 53