-

- Database systems for tabular data (relational database systems)
- The DuckDB database system in practice
- Tabular data storage outside (CSV + Parquet) and inside database systems (columnar storage + compression)
- Database systems and contemporary computer architecture
- Basics of SQL and query authoring
- Representing non-tabular data structure in tables
- Query execution and optimization
- Transactions and persistence

This lecture focusses on the basics of those database systems that are designed for the processing of tabular data (relational database systems). The students will understand how a tabular model allows for a representation of different types of data and, at the same timeThis course will focus on the fundamentals of database systems, in particular systems designed to process tabular data (relational database systems). Students will understabd how the tabular data model enables the representation of a variety of data structures while enabling efficient storage and query processing. We will discuss SQL as a modern and expressive query language over tables. Throughout the course, we will bank on the DuckDB database system. Students will get to know the extensive SQL dialect of DuckDB and will take a deep dive into selected internals of DuckDB. Participants will be able to assess the practical advantages (as well as deficits) of this database system.

Hinweis: Die Unterrichtssprache ist deutsch; alle Materialien zu dieser Vorlesung sind auf Englisch.

Teilnahmevoraussetzungen - empfohlen (aber optional):
- Grundlegende Kenntnisse in Python
- Grundlegende Kenntnisse in C oder C++

---

Note: This lecture will be taught in German; the materials will be in English.

Prerequisites - recommended (but optional):
- Basic knowledge in Python
- Basic knowledge in C or C++