| Dozent/in |
Dr Ivan Giangreco |
| Veranstaltungsart |
Vorlesung |
| Code |
FS261088 |
| Semester |
Frühjahrssemester 2026 |
| Durchführender Fachbereich |
Wirtschaftswissenschaften |
| Studienstufe |
Master |
| Termin/e |
Do, 19.02.2026, 12:15 - 18:00 Uhr, 3.B52
Fr, 20.02.2026, 09:15 - 18:00 Uhr, 3.B52
Sa, 21.02.2026, 09:15 - 15:00 Uhr, 3.B52
Sa, 28.03.2026, 09:15 - 12:00 Uhr, 3.B52 |
| Umfang |
Blockveranstaltung |
| Turnus |
Block course |
| Inhalt |
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. To the end of performing data analyses, the course will highlight hands-on methods to access and integrate heterogenous data sources. |
| Lernziele |
In this course, students will focus on both the modeling aspects of a database design and the implementation perspective. In particular, this course covers the following topics:
- Conceptual database design using Entity-Relationship modeling
- Logical database design and the relational model
- Relational database design theory
- Structured Query Language (SQL)
- Internals of database systems (transactions, index structures)
- Data and information integration
- NoSQL databases |
| Voraussetzungen |
Elementary programming skills, algebra |
| Sprache |
Englisch |
| Anmeldung |
Binding registration takes place via the UniPortal; see notes below in the «Proof of Performance» field.
For course information and materials, registration on the OLAT e-learning platform is required from 2 – 15 February 2026. The students themselves are responsible for verifying the course’s creditability towards their degree program.
Direct link to the OLAT course: to follow
|
| Leistungsnachweis |
***IMPORTANT*** In order to acquire credits, and/or take the examination, registration via the Uni Portal between 2 - 15 February 2026 is MANDATORY. Further information on registration: www.unilu.ch/wf/pruefungen |
| Abschlussform / Credits |
Individual/group presentation / 4.5 Credits
|
| Hörer-/innen |
Ja |
| Kontakt |
ivan.giangreco@doz.unilu.ch |
| Literatur |
Elmasri/Navathe: Fundamentals of Database Systems.
Ramakrishnan/Gehrke: Database Management Systems. |