Description

Database technology is a key technology in practical and applied computer science. The central theme of this course is the modeling, construction, and use of databases. The specific topics covered in the lecture are as follows:

1. Introduction to Database Systems
2. The Entity Relationship (ER) model and the Enhanced-ER (EER) model
3. The Relational Data Model
4. The Structured Query Language (SQL)
5. Advanced SQL
6. SQL as Data Definition Language (DDL) Data Manipulation Language (DML)
7. Database Programming
8. Physical Database Design
9. Query Processing
10. Concurrency and Recovery
11. NoSQL Databases

Prerequisites

Discrete Structures, Introduction to Informatics 1

Literature

• Alfons Kemper, André Eickler: Datenbanksysteme. Eine Einführung. 10., aktualisierte und erweiterte Auflage,Oldenbourg Verlag, 2015
• A. Kemper, M. Wimmer: Übungsbuch: Datenbanksysteme. 3. Auflage Oldenbourg Verlag, 2012
• A. Silberschatz, H. F. Korth, S. Sudarshan: Database System Concepts. Sixth Edition, McGraw-Hill, 2010

Further details in TUMonline