Most of the lecture and practice session material can be found on Moodle and on GitHub: https://github.com/DataSystemsGroupUT/data_engineering_2025
The course schedule (classes) for 2025:
| Week | Lecture | Topic | Practice | Topic | Deadline |
|---|---|---|---|---|---|
| 1 | 2025-09-01 | No class | 2025-09-02 | No class | |
| 2 | 2025-09-08 | Introduction | 2025-09-09 | Docker, Postgres | |
| 3 | 2025-09-15 | Data architecture, data modeling | 2025-09-16 | ER diagrams | |
| 4 | 2025-09-22 | Dimensional modeling | 2025-09-23 | Star schema | |
| 5 | 2025-09-29 | Data Engineering Design Patterns (Prerecorded) | 2025-09-30 | - | Project 1 (2025-10-05) |
| 6 | 2025-10-06 | Data processing and orchestration | 2025-10-07 | Airflow | P1 peer grading (2025-10-12) |
| 7 | 2025-10-13 | Data storage, OLAP | 2025-10-14 | ClickHouse | |
| 8 | 2025-10-20 | Data transformation | 2025-10-21 | dbt | |
| 9 | 2025-10-27 | Semi-structured data | 2025-10-28 | MongoDB | Project 2 (2025-11-02) |
| 10 | 2025-11-03 | Data Lakes | 2025-11-04 | Apache Iceberg | P2 peer grading (2025-11-09) |
| 11 | 2025-11-10 | Security & Privacy | 2025-11-11 | Masking, RBAC | |
| 12 | 2025-11-17 | Data Governance | 2025-11-18 | Open Metadata | |
| 13 | 2025-11-24 | Data Visualization | 2025-11-25 | Apache Superset | Project 3 (2025-11-30) |
| 14 | 2025-12-01 | Guest lecture (TBD) | 2025-12-02 | Exam prep | Project poster, P3 peer grading (2025-12-07) |
| 15 | 2025-12-08 | Exam 1* | 2025-12-09 | Exam 2* | |
| 16 | 2025-12-15 | Project presentations* | 2025-12-16 | Exam redo* |
Both lectures and practice times are 16:15-18:00, except when otherwise noted via Moodle by the teaching staff.
Exams: you choose either option 1 or option 2. If you fail the exam, OR you have doctor's written confirmation on illness, then you can take the exam redo. Redo is not possible for cases when you are not satisfied with your initial passing grade.
All classes take place physically in the classroom noted in OIS, unless otherwise noted via Moodle by the teaching staff.
There will be a Zoom recording/participation available for most classes, but online participation is not fully supported.
- NB! for exams and final project presentation, physical participation is mandatory.