Coding & Digital Design FT
Apply Icon

Data & Analytics 1: Data Engineering

level of course unit


Learning outcomes of course unit

The students
- understand what database systems are used for and how they work
- know different database systems and can compare them with each other
- have a detailed understanding of relational database systems
- can develop and implement data structures for a problem
- can independently represent real-world situations as a data model
- can transfer data models into a relational data structure
- can apply database systems in practice
- can interact with database systems
- can carry out basic database management activities with NoSQL systems

prerequisites and co-requisites


course contents

- Basics of database systems and data management
- Data modeling (single entity, attributes, cardinality, conditionality, relationship types)
- Key candidates, super keys, and primary keys
- Normalization of data structures (at least 1, 2, 3)
- Interaction with relational databases with the support of SQL in the areas of DDL, DML, and DQL
- Basic database management activities on advanced database concepts in the area of NoSQL

recommended or required reading

- Watson, Richard T.: Data Management. Databases and Organizations. 6th edition, eGreen Press, 2013
- Date, Chris: SQL and Relational Theory. 3rd edition, O'Reilly Media, 2015
- Kaufmann, Michael; Meier, Andreas: SQL & NoSQL Datenbanken. 9th edition. Springer Vieweg, 2022

assessment methods and criteria

Portfolio review

language of instruction


number of ECTS credits allocated


eLearning quota in percent


course-hours-per-week (chw)


planned learning activities and teaching methods

Presentations, group work, project work, individual tasks, presentations and discussions

semester/trimester when the course unit is delivered


name of lecturer(s)


year of study


course unit code


type of course unit

integrated lecture

mode of delivery


work placement(s)