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

• 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 two exercise sheets, which are solved by the students as  a homework and handed in.
• Ahead of the deadlines, teaching assistants offer consultation hours.
• The first exercise is checked by the teaching assistants and returned to the students (enhanced with some feedback)
• The correct solutions are presented by the lecturers and discussed with the audience in extra lectures.
• The second exercise is dicussed with a teaching assistant in a personal meeting. During the discussion the solutions will be checked for correctness, and even more the students understanding of the topic are evaluated and feedback is provided.

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.