Datenbanksysteme I (Sommersemester 2023)

Lecturer: Dr. Hazar Harmouch (Information Systems) , Leon Bornemann (Information Systems)
Course Website: https://hpi.de/en/naumann/teaching/current-courses/ss-23/database-systems-i.html

General Information

• Weekly Hours: 4
• Credits: 6
• Graded: yes
• Enrolment Deadline: 01.04.2023 - 07.05.2023
• Teaching Form: Lecture / Exercise
• Enrolment Type: Compulsory Elective Module
• Course Language: English

Programs, Module Groups & Modules

Description

Database systems are at the core of almost all large applications and are used in all enterprises. In this lecture, we will discuss database systems from an application perspective. We start with the conceptual design of databases using ER diagrams and their translation into the relational data model.  Then, we dig into the relational algebra that enables us to operate on top of these models. We also learn the SQL querying language, i.e., how we can create, update and search data tables. The second part of this lecture discusses advanced topics such as transaction management, programming database systems. From time to time, we will leave the application perspective and learn how a database system implements user instructions, for example during query processing or for consistency assurance.

Literature

• Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom: Database Systems - The Complete Book, Pearson Education International, 2008. The book is available in the UP library and at our chairs library. Furthermore, at Amazon.de  (earlier editions are often available at a lower price). The book is also a textbook for DBS II.

There are also a number of other (German and English) textbooks on the subject, all of which are also suitable as study guides, such as:

• Gunter Saake, Andreas Heuer, Kai-Uwe Sattler - Datenbanken: Konzepte und Sprachen, mitp Verlags GmbH & Co, 2018
• Elmasri Ramez And Navathe Shamkant: Fundamentals of Database Systems, Pearson India, 2017
• Alfons Kemper, André Eickler: Datenbanksysteme - Eine Einführung, De Gruyter Oldenbourg, 2015

Learning

Lecture and exercise (Vorlesung und Übung)

Examination

The lecture is accompanied by an exercise, the successful participation of which is a prerequisite for admission to the examination.

The performance will be assessed through a written exam. 

Dates

See the Webseite of the Information Systems Chair.

Zurück