SQL and PostgreSQL: Introductions Course for Beginners

What’s included

$14.99 / $24.99

Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.

4.59

Pay once, own it forever

Video Courses

Introduction to SQL

Lectures	Duration
1. Section Introduction	1m 14s
2. Databases and SQL	3m 25s
3. Installing PostgreSQL	6m 1s
4. Setting Up the Database	10m 34s

1. Section Introduction

1m 14s

2. Databases and SQL

3m 25s

3. Installing PostgreSQL

6m 1s

4. Setting Up the Database

10m 34s

Selecting from a Table in SQL

Lectures	Duration
1. Section Introduction	2m 10s
2. Select	5m 32s
3. Select Where	6m 12s
4. Multiple Wheres	9m 36s
5. Solution 1: Selecting From a Table	3m 46s
6. In, Not In	7m 21s
7. Between	5m 31s
8. CODE: SQL for BETWEEN	7m 40s
9. Like	5m 46s
10. Solution 2: Selecting From a Table	7m 31s
11. Order By	6m 4s
12. Limiting Number of Results	5m 25s
13. Distinct	5m 6s
14. Setting a Column Name Alias	4m 32s

1. Section Introduction

2m 10s

2. Select

5m 32s

3. Select Where

6m 12s

4. Multiple Wheres

9m 36s

5. Solution 1: Selecting From a Table

3m 46s

6. In, Not In

7m 21s

7. Between

5m 31s

8. CODE: SQL for BETWEEN

7m 40s

9. Like

5m 46s

10. Solution 2: Selecting From a Table

7m 31s

11. Order By

6m 4s

12. Limiting Number of Results

5m 25s

13. Distinct

5m 6s

14. Setting a Column Name Alias

4m 32s

Selecting from Multiple Tables in SQL

Lectures	Duration
1. Section Introduction	54s
2. Joins in SQL	2m 24s
3. Inner Join Part 1	4m 4s
4. Inner Join Part 2	3m 35s
5. Solution 1: Selecting from Multiple Tables	3m 59s
6. Left Join	3m 3s
7. Right Join	11m 44s
8. Full Join	3m 45s
9. Solution 2: Selecting from Multiple Tables	5m 59s
10. Joining More Than Two Tables	13m 47s
11. Union	11m 34s
12. Solution 3: Selecting from Multiple Tables	6m 30s

1. Section Introduction

54s

2. Joins in SQL

2m 24s

3. Inner Join Part 1

4m 4s

4. Inner Join Part 2

3m 35s

5. Solution 1: Selecting from Multiple Tables

3m 59s

6. Left Join

3m 3s

7. Right Join

11m 44s

8. Full Join

3m 45s

9. Solution 2: Selecting from Multiple Tables

5m 59s

10. Joining More Than Two Tables

13m 47s

11. Union

11m 34s

12. Solution 3: Selecting from Multiple Tables

6m 30s

Aggregate Functions in SQL

Lectures	Duration
1. Section Introduction	54s
2. What are Aggregate Functions	2m 24s
3. Count	4m 4s
4. Min and Max	3m 35s
5. Sum	3m 59s
6. Average	3m 3s
7. Group By	11m 44s
8. Having	3m 45s
9. Solution: Aggregate Functions	5m 59s

1. Section Introduction

54s

2. What are Aggregate Functions

2m 24s

3. Count

4m 4s

4. Min and Max

3m 35s

5. Sum

3m 59s

6. Average

3m 3s

7. Group By

11m 44s

8. Having

3m 45s

9. Solution: Aggregate Functions

5m 59s

Data Definition Language

Lectures	Duration
1. Section Introduction	1m
2. What is Data Definition Language?	1m 23s
3. Data Types	7m 54s
4. Primary Keys	3m
5. Foreign Keys	2m 50s
6. Creating Tables: Part 1	10m 39s
7. Creating Tables: Part 2	8m 51s
8. Solution 1: Data Definition Language	3m 41s
9. Modifying Tables: Adding and Removing Columns	5m 29s
10. Modifying Tables: Modifying Columns	10m 12s
11. Removing Tables	1m 42s
12. Deleting All Rows from Tables	1m 58s
13. Solution 2: Data Definition Language	3m 35s

1. Section Introduction

2. What is Data Definition Language?

1m 23s

3. Data Types

7m 54s

4. Primary Keys

5. Foreign Keys

2m 50s

6. Creating Tables: Part 1

10m 39s

7. Creating Tables: Part 2

8m 51s

8. Solution 1: Data Definition Language

3m 41s

9. Modifying Tables: Adding and Removing Columns

5m 29s

10. Modifying Tables: Modifying Columns

10m 12s

11. Removing Tables

1m 42s

12. Deleting All Rows from Tables

1m 58s

13. Solution 2: Data Definition Language

3m 35s

Data Manipulation Language

Lectures	Duration
1. Section Introduction	36s
2. What is Data Manipulation Language?	56s
3. Inserting Data into Tables	9m 16s
4. Updating Data in Tables	7m 44s
5. Deleting Data from Tables	4m 31s
6. Solution: Data Manipulation Language	6m 6s

1. Section Introduction

36s

2. What is Data Manipulation Language?

56s

3. Inserting Data into Tables

9m 16s

4. Updating Data in Tables

7m 44s

5. Deleting Data from Tables

4m 31s

6. Solution: Data Manipulation Language

6m 6s