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:
At the moment, we assume that the course can be held in presence, but we are closely monitoring the pandemic situation, and we are prepared to switch to an online or hybrid setting.
For students who cannot attend the classes in presence (e.g., due to visa or quarantine issues), we provide lecture recordings from the past year.
No formal registration (Portal2 or ILIAS) is required, but you are invited to join the ILIAS group.
Slides:
Exercises:
Video recordings, 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.
Date | Lecture | Exercise |
16.2. | Introduction | Introduction |
23.2. | SQL Part 1 | SQL Part 1 |
2.3. | SQL Part 2 | SQL Part 2 |
9.3. | ER Models | ER Models |
16.3. | Normal Forms | Normal Forms |
23.3. | Index and Hashing | Index and Hashing |
30.3. | DB Architectures | DB Architectures |
6.4. | Query Processing | Query Processing + Intro Easter Eggcercise |
13.4. | Easter Break | Easter Break |
20.4. | Easter Break | Easter Break |
27.4. | Query Optimization | Query Optimization |
4.5. | Transactions and Concurrency | Transactions and Concurrency |
11.5. | Recovery | Recovery |
18.5. | Application Development | Application Development |
25.5. | -- | Wrap up and Q&A |
The exam will take place on Friday, June 17th, time and location tba.