Week | Date | Description |
Material
|
W01 | 01/08/2019 | Lecture 01: Syllabus, Course Overview and Introduction |
|
W01 | 01/10/2019 | Lecture 02: Relational Database Model |
|
W02 | 01/15/2019 | Lecture 03: Structured Query Language SQL - DDL |
|
W02 | 01/17/2019 | Lecture 04: Conceptual Database Design & ER-Model |
|
W03 | 01/22/2019 | Lecture 05: Normalization I Finishing Lecture 04 & Introduction to normalization |
|
W03 | 01/24/2019 | Lecture 05: Normalization II |
|
W04 | 01/29/2019 | Lecture 05: Normalization III |
|
W04 | 01/31/2019 | Lecture 06: Normalization III + Formal Query Languages Finishing Lecture 05 & Introduction to SQL |
|
W05 | 02/05/2019 | Lecture 06: Formal Query Languages: Relational Algebra |
|
W05 | 02/07/2019 | Lecture 07: Structured Query Language SQL – DML |
|
W06 | 02/12/2019 | Lecture 07: Structured Query Language SQL – DML |
|
W06 | 02/14/2019 | Lecture 08: Transaction Processing |
|
W07 | 02/19/2019 | Lecture 09: Transaction Processing |
|
W07 | 02/21/2019 | Lecture 09: Views |
|
W08 | 02/26/2019 | Lecture 10-11: Access control, Integrity Constraints
&Transactions in SQL |
|
W08 | 02/28/2019 | Lecture E1: Review |
|
W09 | 03/05/2019 | Midterm |
|
W09 | 02/07/2019 | Lecture 12: Semantic Integrity Constraints |
|
W10 | 03/19/2019 | Lecture 13: Semantic Integrity Constraints JDBC API PostgreSQL JDBC info |
|
W10 | 03/21/2019 | Lecture 14: Data Storage |
|
W11 | 03/26/2019 | Lecture 14: Data Storage |
|
W11 | 03/28/2019 | Lecture 15: Access Paths or Index Structures for Files CREATE INDEX B+ tree visualization |
|
W12 | 04/02/2019 | Lecture 16: Query Processing and Optimization |
|
W12 | 04/04/2019 | Lecture 17: Query Processing and Optimization |
|
W13 | 04/09/2019 | Lecture 18: Transaction Recovery |
|
W13 | 04/11/2019 | Lecture 18: Transaction Recovery |