| Week | Topic | Course Materials | Note | |
|---|---|---|---|---|
| 1 |
Course Overview Introduction to Database |
[slides]
[video1] , [video2] , [video3] |
Chapter 1 | |
| 2 | Relational Algebra |
[slides]
[video1] , [video2] |
Chapter 2 | |
| 3 | Introduction to SQL - Part 1 |
[slides]
[video1] , [video2] , [video3] |
Chapter 3
Reference Book Database |
|
| 4 | Introduction to SQL - Part 2 |
[Slides from previous week used]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] |
Chapter 3 | |
| 5 | SQL Practice - Part 1 |
|
||
| 6 | Database Design - ER Diagram |
[slides]
ER Case Study |
Chapter 6 | |
| 7 | Transfer ER to Relational Schema | Chapter 6 | ||
| 8 | Intermediate SQL - Part 1 |
[slides]
[video1] , [video2] , [video3] , [video4] , [video5] |
|
|
| 9 | Intermediate SQL - Part 2 |
|
|
|
| 10 | SQL Practice - Part 2 |
|
||
| 11 | Advanced SQL |
[slides]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] |
|
|
| 12 | Database Design: Normalization - Part 1 |
|
||
| 13 | Database Design: Normalization - Part 2 |
|
||
| 14 |
Database Design: Relation Decomposition Indexing |
|
||
| 15 | NoSQL Databases |
| Team number | Team member | Demo Date |
|---|---|---|
| #1 |
|
|
| #2 |
|
|
| #3 |
|
|
| #4 |
|
|
| #5 |
|
|
| #6 |
|
|
| #7 |
|
|
| #8 |
|
|
| #9 |
|
|
| #10 |
|
|
| #11 |
|
|
| #12 |
|
|
| #13 |
|
|
| #14 |
|
|
| #15 |
|
|
| #16 |
|
|
| #17 |
|
|
| #18 |
|
|
| #19 |
|
|
| #20 |
|
|
| #21 |
|
|
| #22 |
|
|
| #23 |
|
|
| #24 |
|
|
| #25 |
|
|
| #26 |
|
|
| #27 |
|
|
| #28 |
|
|
| #29 |
|
|