| Week | Topic | Course Materials | Note | |
|---|---|---|---|---|
| 1 | Course Overview | [syllabus] | ||
| 2-1 | Introduction to Database |
[slides]
[video1] , [video2] , [video3] |
Chapter 1 | |
| 2-2 | Introduction to SQL - Part 1 |
[slides]
[video1] , [video2] , [video3] |
Chapter 3
Reference Book Database |
|
| 3-1 | Introduction to SQL - Part 2 |
[Slides from previous week used]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] |
Chapter 3 | |
| 3-2 | SQL Practice - Part 1 |
|
||
| 4 | Database Design - ER Diagram |
[slides]
ER Case Study |
Chapter 6 | |
| 5 | Transfer ER to Relational Schema | [slides] | Chapter 6 | |
| 6 | Intermediate SQL |
[slides]
[video1] , [video2] , [video3] , [video4] , [video5] |
Chapter 4 | |
| 7-1 | Advanced SQL |
[slides]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] |
Chapter 5 | |
| 7-2 | SQL Practice - Part 2 |
|
||
| 7-3 | Relational Algebra |
[slides]
[video1] , [video2] |
Chapter 2 | |
| 8 | Exam 1 Review | Exam Review (Chapters 1 - 5) | Exam 1 on Mon, 10/30 at class time via Canvas (Section 1: 09:30 AM - 10:45 AM) (Section 2: 11:00 AM - 12:15 PM) (Section 3: 02:30 PM - 03:45 PM) Exam 1 on Thu, 11/02 at class time via Canvas (Section 4: 8:30 PM - 09:45 PM) |
|
| 9 | Database Design: Normalization | [slides] Normalization Example |
Chapter 7 | |
| 10 | Exam 2 Review | Exam Review (Chapters 6 - 7) | Exam 2 (online) on Wed, 12/06 at class time via Canvas (Section 1: 09:30 AM - 10:45 AM) (Section 2: 11:00 AM - 12:15 PM) (Section 3: 02:30 PM - 03:45 PM) Exam 2 (online) on Thu, 12/14 at 8:00 PM via Canvas (Section 4: 08:00 PM - 09:15 PM) |