Week | Topic | Course Materials | Note | |
---|---|---|---|---|
1 | Course Overview | [syllabus] | ||
2 | Introduction to Database |
[slides]
[video1] , [video2] , [video3] |
Chapter 1 | |
3 | Relational Algebra |
[slides]
[video1] , [video2] |
Chapter 2 | |
4 | Introduction to SQL - Part 1 |
[slides]
[video1] , [video2] , [video3] |
Chapter 3
Reference Book Database |
|
5 | Introduction to SQL - Part 2 |
[Slides from previous week used]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] |
Chapter 3 | |
6 | Introduction to SQL - Part 3 | [Slides from previous week used] | Chapter 3 | |
7 | SQL Practice - Part 1 |
|
SQL Cheat Sheet Project - Phase 1 |
|
8 | Intermediate SQL - Part 1 |
[slides]
[video1] , [video2] , [video3] , [video4] , [video5] |
|
|
9 | Intermediate SQL - Part 2 |
|
|
|
10 | SQL Practice - Part 2 |
|
SQL Cheat Sheet Project - Phase 2 |
|
11 | Midterm Exam Review |
Midterm Exam on Wed, 11/10 at class time (Section 1: 12:30 PM - 1:45 PM - Section 2: 2:00 PM - 3:15 PM |
||
12 | Advanced SQL |
[slides]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] |
|
|
13 | Database Design - ER Diagram |
[slides]
ER Case Study |
Project - Phase 3 |
|
14 |
Database Design: - Transfer ER to Relational Schema - Normalization - Part 1 |
|
||
15 | Database Design: Normalization - Part 2 |
|
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 |
|
|