Week | Date | Lectures and Reading | Deadlines |
01 | June 18, Mon | Syllabus, Lecture 1a: Introduction, Lecture 1b: DBMS, Lecture 1c: Conceptual Modeling | |
June 20, Wed | Lecture 1c: Conceptual Modeling | Assignment 1 | |
02 | June 25, Mon | Lecture 2a: EER Modeling, Lecture 2b: ER to Relational Mapping | |
June 26, Wed | Lecture 2b: ER to Relational Mapping, Lecture 2c: Normalization, Lecture 3a: Basic SQL | Midterm 1 | |
03 | July 02, Mon | MySQL Workshop, Lecture 3b: Relational Algebra | |
July 04, Wed | No Class. 4th of July Holiday | ||
04 | July 09, Mon | Lecture 4: Hashing & Indexing | Assignment 2 |
July 11, Wed | Lecture 5: Semi-structured Data | Midterm 2 | |
05 | July 16, Mon | Lecture 6a: NoSQL Databases, MongoDB workshop | |
July 18, Wed | Lecture 6b: Database Trends, Course Wrap-up/Revisions | Assignment 3 | |
Monday July 23 | Final Exam, 1.00 pm - 3.00 pm | 8-345 |