CS 460 Databases for Data Scientists (FSS 2025)
Important: This course is open only to MMDS students who started before 2024 and MMSDS students!
Course Description
The course provides an introduction to relational database systems. The course will cover the following topics:
- Principles of data storage
- Database query languages (SQL)
- Relational modeling
- Keys and normal forms
- Hash and index structures
- Transactions and concurrency
Lecturers
Dates and Times
- Lecture: Tuesday 13:45–15:15, B6 A203
- Exercise: Wednesday 12:00–13:45, D002
Administrative Details
No formal registration (Portal2 or ILIAS) is required, but you are invited to join the ILIAS group.
Material and Literature
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.
Outline and Material
| Date | Lecture (Tuesday) | Exercise (Wednesday) |
| 10.02. | no lecture | no exercise |
| 17.02. | Introduction (PDF, 3 MB) | Introduction |
| 24.02. | SQL Part 1 (PDF, 2 MB) | SQL Part 1 |
| 03.03. | SQL Part 2 (PDF, 1 MB) | SQL Part 2 |
| 10.03. | ER Models (PDF, 3 MB) | ER Models |
| 17.03. | Normal Forms (PDF, 1 MB) | Normal Forms |
| 24.03. | Index and Hashing | |
| 31.03. | DB Architectures (PDF, 3 MB) | DB Architectures |
| 07.04. | Query Processing (PDF, 1 MB) | Query Processing + Intro Easter Eggcercise |
| 14.04. | Holiday | Holiday |
| 21.04. | Holiday | Holiday |
| 28.04. | Query Optimization (PDF, 1 MB) | Query Optimization |
| 05.05. | Transactions and Concurrency (PDF, 1 MB) | Transactions and Concurrency |
| 12.05. | Recovery (PDF, 799 kB) | Recovery |
| 19.05. | Application Development (PDF, 1 MB) | Application Development |
| 26.05. | NoSQL + Q&A (PDF, 465 kB) | NoSQL + Q&A |