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 | |
4-1 | Exam 1 Review | Exam Review (Chapters 1-5) | Exam 1 on Thursday, 08/08 at 11:00 AM via Canvas | |
4-2 | Database Design - ER Diagram |
[slides]
ER Case Study |
Chapter 6 | |
5-1 | Transfer ER to Relational Schema | [slides] | Chapter 6 | |
5-2 | Database Design: Normalization | [slides] Normalization Example |
Chapter 7 | |
6 | Exam 2 Review | Exam 2 Review (Chapters 6, 7) | Exam 2 on Tuesday, 08/20 at 11:00 AM via Canvas |
Team number | Team member | Demo Date |
---|---|---|
#1 | 1.Jacob Spier, 2.Gerardo Anthony Marioni, 3.Abigail Rosas | |
#2 | 1.Alejandro Ortega, 2.Vanessa Juarez, 3.Christopher Lagos | |
#3 | 1.Mirta Mazariego | |
#4 | 1.Ali Maamoun, 2.Jittapatana (Patrick) Prayunpruk, 3.Cailin Jefferson, 4.Adrian Carreno | |
#5 | 1.Narek Asaturyan, 2.Adrian Leon, 3.Lilianna Rosales | |
#6 | 1.Ashot Gharibyan, 2.Mohammed I Hussain, 3.Timothy Tracy | |
#7 | 1.Vinicius Bosque, 2.Federico Bailaque, 3.Daniel Barlam | |
#8 | 1.Miguel Datoc | |
#9 | 1.Zaid Alabwaini, 2.Amgad Fahim, 3.Christian Javalios | |
#10 | 1.Arash Asadi, 2.Mitra Farsi | |
#11 | 1.Edward Orlov, 2.Rucha Kothikar, 3.Pragya Sangwan | |
#12 | 1.Chance Chime |