How should I learn database system concepts

Database systems: concepts and models

Course enrollment

To attend the lecture, please refer to the Moodle course enroll. Information about the lecture, exercise or exam and other announcements will only be communicated via the Moodle. The course is activated at the beginning of the semester.

Lecture content

This course serves to deepen and broaden the database-specific content from the courseInformation systems. The content from this course that is relevant for understanding is, however, briefly repeated so that you can follow the material even if you have not attended this course. We also address other courses of study or interested master’s students who would like to deepen their knowledge in the field of databases. The following topics are dealt with in detail:

  • Data modeling with ERM
  • Basics of relational database systems: relational data model, functional and multi-valued dependencies and normal forms
  • Advanced SQL programming: stored procedures, PL / SQL, triggers, recursive SQL
  • Selected internals of DBMS: persistent storage, index structures, query optimization and transactions
  • Aspects of the expandability of database management systems (DBMS)
  • Selected aspects of current database technologies
  • Data science aspects in the context of medical data

Content requirements

Basic knowledge of relational databases, as taught in the bachelor's program Programming Systems, is an advantage. The relevant basics are recapitulated again for career changers.

materials

The lecture materials for the lecture are managed via Moodle and offered there.

Exercises

The exercises serve to deepen the material of the lecture in a meaningful way through selected tasks. They take place on a topic-specific basis and (mostly) every 2 weeks. The dates of the exercises are communicated in the lecture and via the Moodle course.

Trainer

Michael Stach

time and place

lecture
The first lecture will take place on Tuesday, November 3rd, 2020.

Further information is available from the Moodle course.

Exercises
irregular

Rotation

every winter semester

exam

The course can be taken at the end of the semester in the form of a written exam.