Important: This course is open only to MMDS students!
The course provides an introduction to relational database systems. The course will cover the following topics:
No formal registration (Portal2 or ILIAS) is required, but you are invited to join the ILIAS group.
Slides:
Exercises:
Exercise solutions and additional materials will be made available in the corresponding ILIAS group.
The course will be based on the book Database System Concepts by Silberschatz et al.
Week | Wednesday (Lecture) | Wednesday (Exercise) |
---|---|---|
14.02.2018 | Introduction | Introduction |
21.02.2018 | SQL Part 1 | SQL Part 1 |
28.02.2018 | SQL Part 2 | SQL Part 2 |
07.03.2018 | ER Models | ER Models |
14.03.2018 | Normal Forms | Normal Forms |
21.03.2018 | Index and Hashing | Index and Hashing & Big exercise |
28.03.2018 | -- (Easter Break) | -- (Easter Break) |
04.04.2018 | -- (Easter Break) | -- (Easter Break) |
11.04.2018 | DB Architectures | DB Architectures & Big exercise |
18.04.2018 | Query Processing | Query Processing & Big exercise |
25.04.2018 | Query Optimization | Query Optimization |
02.05.2018 | Transactions and Concurrency | Transactions and Concurrency |
09.05.2018 | -- (canceled) | -- (canceled) |
16.05.2018 | Recovery | Recovery |
23.05.2018 | Application Development | Application Development |