| Week | Date | Description |
Material
|
| W01 | 05/13/2019 | Lecture 01: Syllabus, Course Overview and Introduction Lecture 02: Relational Database Model |
|
| W01 | 05/15/2019 | Lecture 03: Formal Query Languages: Relational Algebra |
|
| W02 | 05/20/2019 | Lecture 04:Structured Query Language SQL - DDL |
|
| W02 | 05/22/2019 | Lecture 05: Structured Query Language SQL – DML |
|
| W03 | 05/29/2019 | Lecture 05: Structured Query Language SQL – DML |
|
| W04 | 06/03/2019 | Lecture 06: SQL Views |
|
| W05 | 06/10/2019 | Lecture 07: Access control Lecture 08: Integrity Constraints &Transactions in SQL Lecture 09: Semantic Integrity Constraints |
|
| W05 | 06/12/2019 | Lecture 10: Database programming |
|
| W06 | 06/17/2019 | Lecture 11: Normalization | |
| W06 | 06/19/2019 | Lecture 11: Normalization |
|
| W07 | 06/24/2019 | Review for Lectures 6-11 Lecture 12: Conceptual Database Design & ER-Model |
|
| W07 | 06/26/2019 | Lecture 12: Conceptual Database Design & ER-Model Lecture 13: Data Storage |
|
| W08 | 07/01/2019 | Lecture 13: Data Storage | |
| W08 | 07/03/2019 | Lecture 13: Data Storage Review for midterm exam |
|
| W09 | 07/08/2019 | Midterm |
|
| W09 | 07/10/2019 | Lecture 14: Access Paths or Index Structures for Files |
|
| W10 | 07/15/2019 | Lecture 15: Query Processing and Optimization |
|
| W10 | 07/17/2019 | Lecture 16: Transaction Processing |
|
| W11 | 07/22/2019 | Lecture 17: Transaction Recovery |
|
| W11 | 07/24/2019 | Review for final exam |
|
| W12 | 07/29/2019 | Lecture 18: Big Data, NoSQL, NewSQL and More |
|
| W12 | 07/31/2019 | Final Exam |