Data & Analytics 1: Data Engineering
level of course unit
Bachelor
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
none
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
German
number of ECTS credits allocated
6
eLearning quota in percent
20
course-hours-per-week (chw)
3
planned learning activities and teaching methods
Presentations, group work, project work, individual tasks, presentations and discussions
semester/trimester when the course unit is delivered
1
name of lecturer(s)
STGL
year of study
1
course unit code
DAT1
type of course unit
integrated lecture
mode of delivery
Compulsory
work placement(s)
no