| Week | Topic | Course Materials | Note | |
|---|---|---|---|---|
| 1-1 | Course Overview | [syllabus] | ||
| 1-2 | Introduction to Database |
[slides]
[video1] , [video2] , [video3] |
Chapter 1 | |
| 2-1 | Introduction to SQL - Part 1 |
[slides]
[video1] , [video2] , [video3] |
Chapter 3
Reference Book Database |
|
| 2-2 | Introduction to SQL - Part 2 |
[Slides from previous week used]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] |
Chapter 3 | |
| 2-3 | SQL Practice - Part 1 |
|
||
| 3-1 | Intermediate SQL - Part 1 |
[slides]
[video1] , [video2] , [video3] , [video4] , [video5] |
Chapter 4 | |
| 3-2 | Advanced SQL |
[slides]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] |
Chapter 5 | |
| 3-3 | SQL Practice - Part 2 |
|
||
| 3-4 | Relational Algebra |
[slides]
[video1] , [video2] |
Chapter 2 |