| Dozent/in |
Dr Ivan Giangreco |
| Veranstaltungsart |
Vorlesung |
| Code |
FS251036 |
| Semester |
Frühjahrssemester 2025 |
| Durchführender Fachbereich |
Wirtschaftswissenschaften |
| Studienstufe |
Master |
| Termin/e |
Di, 11.02.2025, 09:15 - 16:00 Uhr, 3.B47
Mi, 12.02.2025, 09:15 - 16:00 Uhr, 3.B47
Do, 13.02.2025, 09:15 - 15:00 Uhr, 3.B47 |
| Umfang |
2 Semesterwochenstunden |
| 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 |
To attend the course /
exercise, registration via e-learning platform OLAT is required. Registration
is possible from 20 January – 11 February 2025. The students themselves are
responsible for checking the creditability of the course to their course of
study.
Direct link to OLAT course:
to follow |
| Prüfung |
***IMPORTANT*** In order to acquire credits, resp. to take the examination, registration via the Uni Portal within 20 January - 11 February 2025 is ESSENTIALLY REQUIRED. Further information on registration: www.unilu.ch/wf/pruefungen |
| Abschlussform / Credits |
Written exam / 3 Credits
|
| Hörer-/innen |
Ja |
| Kontakt |
ivan.giangreco@doz.unilu.ch |
| Literatur |
Elmasri/Navathe: Fundamentals of Database Systems.
Ramakrishnan/Gehrke: Database Management Systems. |