Section
|
Materi
|
Output
|
1.1
|
Course Introduction(section 1) |
Video
RDocs |
2.1 |
What is a Database? |
|
2.2
|
Relational Databases and SQL |
|
2.3 |
Installing PostgreSQL |
|
3.1
|
Section Introduction(section 3) |
|
3.2 |
Database Tables |
|
3.3
|
Data Types Explained |
|
3.4 |
Primary Keys and Foreign Keys |
|
3.5
|
Unique, Not Null, and Check Constraints |
|
3.6 |
Creating Our First Table |
|
3.7
|
Creating the Actors Table |
|
3.8 |
Creating a Table with a Foreign Key |
|
3.9
|
Creating the Movie Revenues Table |
|
3.10 |
Creating a Junction Table |
|
3.11
|
Modifying Tables Part 1: Adding Columns |
|
3.12 |
Modifying Tables Part 2: Changing a Columns Data Type |
|
3.13
|
Deleting Tables from a Database |
|
3.14 |
Challenge: Data Definition Language |
|
3.15
|
Solution: Data Definition Language |
|
3.16 |
Section Summary(section 3) |
|
4.1
|
Section Introduction(section 4) |
|
4.2 |
Inserting Data into a Table |
|
4.3
|
Updating Data in a Table |
|
4.4 |
Deleting Data from a Table |
|
4.5
|
Inserting Data into Our Movie Data Database |
|
4.6 |
Challenge: Data Manipulation Language |
|
4.7
|
Solution: Data Manipulation Language |
|
4.8 |
Section Summary (section 4) |
|
5.1
|
Section Introduction (section 5) |
|
5.2 |
Select Queries |
|
5.3
|
Where Clauses |
|
5.4 |
Logical Operators |
|
5.5
|
Challenge 1: Select Queries |
|
5.6 |
Solution 1: Select Queries |
|
5.7
|
In, Not In |
|
5.8 |
Like |
|
5.9
|
Between |
|
5.10 |
Challenge 2: Select Queries |
|
5.11
|
Solution 2: Select Queries |
|
5.12 |
Order By |
|
5.13
|
Limiting the Number of Results |
|
5.14 |
Fetch |
|
5.15
|
Distinct Values |
|
5.16 |
Challenge 3: Select Queries |
|
5.17
|
Solution 3: Select Queries |
|
5.18 |
Null Values |
|
5.19
|
Setting a Column Name Alias |
|
5.20 |
Concatenation |
|
5.21
|
Challenge 4: Select Queries |
|
5.22 |
Solution 4: Select Queries |
|
5.23
|
Section Summary (section 5) |
|
6.1 |
Section Introduction (section 6) |
|
6.2
|
Aggregate Functions Explained |
|
6.3 |
Count Aggregate Functions |
|
6.4
|
Sum Aggregate Function |
|
6.5 |
Min and Max Aggregate Functions |
|
6.6
|
Average Aggregate Functions |
|
6.7 |
Challenge 1: Aggregate Functions |
|
6.8
|
Solution 1: Aggregate Functions |
|
6.9 |
Grouping Data |
|
6.10
|
Having Clauses |
|
6.11 |
Challenge 2: Aggregate Functions |
|
6.12
|
Solution 2: Aggregate Functions |
|
6.13 |
Mathematical Operators |
|
6.14
|
Section Summary(section 6) |
|
7.1 |
Section Introduction(section 7) |
|
7.2
|
What Are Database Relationships? |
|
7.3 |
One to One Relationships |
|
7.4
|
One to Many Relationships |
|
7.5 |
Many to Many Relationships |
|
7.6
|
(Optional) Challenge: Database Relationships |
|
7.7 |
Solution: Database Relationships |
|
7.8
|
Section Summary (section 7) |
|
8.1 |
Section Introduction (section 8) |
|
8.2
|
SQL Joins Explained |
|
8.3 |
Inner Joins Part 1 |
|
8.4
|
Inner Joins Part 2 |
|
8.5 |
Inner Joins Part 3 |
|
8.6
|
Challenge 1: Joins |
|
8.7 |
Solution 1: Joins |
|
8.8
|
Left Joins |
|
8.9 |
Right Joins |
|
8.10
|
Full Joins |
|
8.11 |
Challenge 2: Joins |
|
8.12
|
Solutions 2: Joins |
|
8.13 |
Joining More Than Two Tables |
|
8.14
|
Challenge 3: Joins |
|
8.15 |
Solution 3: Joins |
|
8.16
|
Union |
|
8.17 |
Union All |
|
8.18
|
Challenge 4: Joins |
|
8.19 |
Solution 4: Joins |
|
8.20
|
Intersect |
|
8.21 |
Except |
|
8.22
|
Challenge 5: Joins |
|
8.23 |
Solution 5: Joins |
|
8.24
|
Section Summary. (section 8) |
|
9.1 |
Section Introduction(section 9) |
Video
RDocs |
9.2 |
Subqueries Explained |
Video
RDocs |
9.3 |
Uncorrelated Subqueries Part 1 |
|
9.4
|
Uncorrelated Subqueries Part 2 |
|
9.5 |
Challenge 1: Subqueries |
|
9.6
|
Solution 1: Subqueries |
|
9.7 |
Correlated Subqueries |
|
9.8
|
Challenge 2: Subqueries |
|
9.9 |
Solution 2: Subqueries |
|
9.10
|
Summary |
|