Complete Intro to SQL & PostgreSQL

1. 3. SQL Commands/7. Ingredients API Solution.mp4143.28MB
2. 1. Introduction/2. SQL Setup with Docker.mp461.22MB
3. 2. Databases and Tables/1. SQL Overview & Creating a Database.mp493.06MB
4. 2. Databases and Tables/2. Creating & Populating a Table.mp461.39MB
5. 2. Databases and Tables/3. Altering a Table & Postgres Data Types.mp473.63MB
6. 3. SQL Commands/1. Inserting Data and Managing Conflicts.mp484.91MB
7. 3. SQL Commands/2. Updating & Deleting Data.mp444.93MB
8. 3. SQL Commands/3. Selecting, Paginating, & Using Where Clauses.mp489.91MB
9. 3. SQL Commands/4. Using LIKE, ILIKE, & SQL Functions.mp451.65MB
10. 3. SQL Commands/5. node-postgres & SQL Injection.mp464.93MB
11. 3. SQL Commands/6. Ingredients API Exercise.mp473.09MB
12. 1. Introduction/1. Introduction.mp484.91MB
13. 4. Joins and Constraints/1. Understanding Relationships & Joins.mp481.36MB
14. 4. Joins and Constraints/2. Left, Right, & Outer Joins.mp443.82MB
15. 4. Joins and Constraints/3. Natural & Cross Joins.mp425.83MB
16. 4. Joins and Constraints/4. Foreign Keys & Managing References.mp441.15MB
17. 4. Joins and Constraints/5. Many-to-Many Relationship.mp483.42MB
18. 4. Joins and Constraints/6. Using the CHECK Constraint.mp448.53MB
19. 4. Joins and Constraints/7. Using the DISTINCT Statement.mp468.88MB
20. 4. Joins and Constraints/8. Recipes Exercise.mp443.69MB
21. 4. Joins and Constraints/9. Recipes Solution.mp4123.49MB
22. 5. JSONB/1. JSON vs. JSONB.mp466.23MB
23. 5. JSONB/2. Adding JSONB to Recipes Table.mp461.66MB
24. 5. JSONB/3. When to Use JSONB.mp434.52MB
25. 6. Aggregation/1. Understanding Aggregation.mp424.52MB
26. 6. Aggregation/2. Filtering Aggregates with HAVING.mp438.79MB
27. 7. Functions Triggers and Procedures/1. Storing Queries with Functions.mp4102.52MB
28. 7. Functions Triggers and Procedures/2. Functions vs. Procedures.mp451.08MB
29. 7. Functions Triggers and Procedures/3. Calling Functions with Triggers.mp466.3MB
30. 8. The Movie Database/1. The Movie Database Setup.mp447.73MB
31. 8. The Movie Database/2. The Movie Database Exercise.mp432.21MB
32. 8. The Movie Database/3. The Movie Database Solution Most Money.mp413.83MB
33. 8. The Movie Database/4. The Movie Database Solution Keanu Reeves.mp431.48MB
34. 8. The Movie Database/5. The Movie Database Solution Most Revenue.mp460.67MB
35. 8. The Movie Database/6. The Movie Database Solution Most Keywords.mp418.9MB
36. 8. The Movie Database/7. The Movie Database Solution Most Movies.mp431.44MB
37. 8. The Movie Database/8. Setup pgAdmin.mp449.33MB
38. 9. Query Performance/1. Analyzing Queries with EXPLAIN.mp482.69MB
39. 9. Query Performance/2. Identifying what to Index.mp437.13MB
40. 9. Query Performance/3. Creating an Index.mp458.16MB
41. 9. Query Performance/4. Using a GIN Index.mp461.03MB
42. 9. Query Performance/5. Creating a Partial Index.mp439.08MB
43. 9. Query Performance/6. Indexing a Derivative Value.mp438.05MB
44. 10. Views, Subqueries & Arrays/1. Creating Views & Inserting Data.mp447.12MB
45. 10. Views, Subqueries & Arrays/2. Joining Between Views.mp445.56MB
46. 10. Views, Subqueries & Arrays/3. Optimizing Queries with Materialized Views.mp465.74MB
47. 10. Views, Subqueries & Arrays/4. Indexing Materialized Views.mp421.36MB
48. 10. Views, Subqueries & Arrays/5. Using Subqueries.mp430.23MB
49. 10. Views, Subqueries & Arrays/6. Creating an Array from a Subquery.mp439.92MB
50. 11. Transactions, Window Functions, and Self Join/1. Transactions.mp492.31MB
51. 11. Transactions, Window Functions, and Self Join/2. Window Functions.mp462.32MB
52. 11. Transactions, Window Functions, and Self Join/3. Self Join.mp432.09MB
53. 12. Wrapping Up/1. Wrapping Up.mp423.26MB