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.
Registration for participation takes place via Moodle. If you are interested, please register there, as further communication will take place via this platform during the course. 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.
Lectures will be given in English.