Database systems are the underlying technology for many modern data-driven projects. They form the backbone to efficiently persist and retrieve data in a large variety of applications, from websites storing customer data to scientific applications managing experimental data.

This course provides an introduction into the fundamentals of database systems, focusing on the relational data model. It is organized around the topic of data modeling and the implementation of a data model in a relational database system.

The course introduces the topic of data modeling and the conceptual database design using Entity-Relationship models. It will then focus on how to translate a conceptual database design into a logical database model of a relational database by introducing the design theory for relational databases. In the implementation part of the lecture, the predominant language for querying database systems Structured Query Language (SQL) will be thoroughly introduced and discussed.  Moreover, the course will present the internals of a data management system in terms of transaction processing and index structures. To the end of performing data analyses, the course will highlight hands-on methods to access and integrate heterogenous data sources.

To attend the course / exercise, registration via e-learning platform OLAT is required. Registration is possible from 8 February to 5 March 2021. The students themselves are responsible for checking the creditability of the course to their course of study.

Direct link to OLAT course:
https://lms.uzh.ch/url/RepositoryEntry/16926704075

Elmasri/Navathe: Fundamentals of Database Systems.

Ramakrishnan/Gehrke: Database Management Systems.