After successful completion of the course, students are able to

• devise mechanisms for guaranteeing given integrity constraints in a relational schema and to implement them in SQL on a relational database management system (RDBMS);
• comprehending and developing database queries using advanced SQL language features;
• develop and apply procedures in a procedural database programming language;
• evaluate properties of parallel transactions and to identify problems caused by parallel processing of transactions;
• systematically apply different isolation levels;
• execute and understand the presented methods and concepts for recovery and concurrency control.

• Database programming (with pgSQL)
• SQL-extensions
• Transactions
• error handling / recovery
• concurrency control

• This course will be held in a distance-learning format.
• This course is offered in a blocked format: the recordings will be put online on Mondays and Wednesdays. The lecture part (not the exercises) will end on December 1, 2021.
• This course will be held both in English and in German: the lectures, the exercise, and the exams will be available in both languages.
• The topics of the course are presented during the lectures.
• In the exercise part of the course, the application of the presented methods, concepts, and algorithms are trained.
• The exercise part consists of exercise sheets, which are solved by the students as homework and handed in.
• Practicing the formulation of SQL queries is done in an online tool.
• Ahead of the deadlines questions can be asked in the forum, teaching assistants will answer them there.
• Exercises are discussed and checked by teaching assistants.

Note:

This course is only for student who already passed the course "Data Modelling" and as part of the transitional regulations for the degree course scheme starting in 2017 are not required to take the full course "Database Systems", which now includes all of the content of "Data Modelling".

ECTS Breakdown:

15h   lectures (1h preliminary meeting, 14h lectures)
14h   preparation for and repetition of lectures
26h   solving exercise sheets
 0,5h exercise interview
18h   exam preparation
 1,5h exam
-----------------
75h (= 25h * 3ECTS)

The final evaluation is based on the performance at the exercises (evaluation of the first exercise sheet is based on the submission, evaluation of the second exercise sheet also heavily depends on the performance at the meeting with the Tutor) and a written exam.

Bitte beachten Sie, dass eine gleichzeitige Anmeldung zu den LVAs Datenbanksysteme oder Datenmodellierung nicht erlaubt sind. Bei Anmeldung zu mehr als einer dieser drei LVAs mit Ende der Anmeldefrist erfolgt eine Abmeldung von allen drei LVAs.

Anmeldungen aller Studierenden aus Informatik und Wirtschaftsinformatik werden bestätigt. Studierende anderer Studien je nach vorhandener Kapazität.

The topics presented as part of the course "Data Modelling" are assumed to be known by the student. They are not recalled or repeated as part of the lectures. If needed, the corresponding lectures of the course "data modelling", which take place before the lecture of the present course, should be visited.