Name: SQL and PostgreSQL: Introductions Course for Beginners
Rating: 4.4 (860 reviews)

SQL and PostgreSQL: Introductions Course for Beginners

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.

$14.99 / $24.99

Introduction to SQL

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

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

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

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

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

Data Manipulation Language

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