Complete Intro to SQL & PostgreSQL

Focused View

7:19:31

11 View

1. Introduction

1. Introduction.mp4

11:57

2. SQL Setup with Docker.mp4

08:13

2. Databases and Tables

1. SQL Overview & Creating a Database.mp4

14:11

2. Creating & Populating a Table.mp4

09:54

3. Altering a Table & Postgres Data Types.mp4

10:35

3. SQL Commands

1. Inserting Data and Managing Conflicts.mp4

11:57

2. Updating & Deleting Data.mp4

07:32

3. Selecting, Paginating, & Using Where Clauses.mp4

15:56

4. Using LIKE, ILIKE, & SQL Functions.mp4

08:43

5. node-postgres & SQL Injection.mp4

09:09

6. Ingredients API Exercise.mp4

08:11

7. Ingredients API Solution.mp4

13:57

4. Joins and Constraints

1. Understanding Relationships & Joins.mp4

11:45

2. Left, Right, & Outer Joins.mp4

06:35

3. Natural & Cross Joins.mp4

03:44

4. Foreign Keys & Managing References.mp4

06:34

5. Many-to-Many Relationship.mp4

13:03

6. Using the CHECK Constraint.mp4

06:02

7. Using the DISTINCT Statement.mp4

08:49

8. Recipes Exercise.mp4

03:59

9. Recipes Solution.mp4

14:17

5. JSONB

1. JSON vs. JSONB.mp4

10:39

2. Adding JSONB to Recipes Table.mp4

10:25

3. When to Use JSONB.mp4

04:45

6. Aggregation

1. Understanding Aggregation.mp4

05:09

2. Filtering Aggregates with HAVING.mp4

07:07

7. Functions Triggers and Procedures

1. Storing Queries with Functions.mp4

13:58

2. Functions vs. Procedures.mp4

07:43

3. Calling Functions with Triggers.mp4

08:58

8. The Movie Database

1. The Movie Database Setup.mp4

06:36

2. The Movie Database Exercise.mp4

04:23

3. The Movie Database Solution Most Money.mp4

02:52

4. The Movie Database Solution Keanu Reeves.mp4

06:01

5. The Movie Database Solution Most Revenue.mp4

10:42

6. The Movie Database Solution Most Keywords.mp4

03:30

7. The Movie Database Solution Most Movies.mp4

05:03

8. Setup pgAdmin.mp4

07:31

9. Query Performance

1. Analyzing Queries with EXPLAIN.mp4

12:57

2. Identifying what to Index.mp4

05:36

3. Creating an Index.mp4

09:19

4. Using a GIN Index.mp4

10:03

5. Creating a Partial Index.mp4

05:37

6. Indexing a Derivative Value.mp4

05:50

10. Views, Subqueries & Arrays

1. Creating Views & Inserting Data.mp4

09:15

2. Joining Between Views.mp4

06:35

3. Optimizing Queries with Materialized Views.mp4

08:37

4. Indexing Materialized Views.mp4

02:56

5. Using Subqueries.mp4

04:52

6. Creating an Array from a Subquery.mp4

05:49

11. Transactions, Window Functions, and Self Join

1. Transactions.mp4

13:29

2. Window Functions.mp4

08:39

3. Self Join.mp4

05:57

12. Wrapping Up

1. Wrapping Up.mp4

03:35

More details

User Reviews

Rating

average 0

Total votes0

Focused display

At Frontend Masters, we pride ourselves on offering courses designed and taught by leading experts actively employing their skills at renowned companies such as Netflix, Spotify, Google, and Stripe. Our curriculum is continually refreshed to align with the most recent advancements, guaranteeing that our learners are equipped with industry-standard best practices and cutting-edge techniques.