Data & Analytics 1: Data Engineering
Niveau
Bachelor's program
Learning outcomes of the courses/module
The participants:
• can explain database systems
• can identify different database systems and compare them
• can describe relational database systems
• can design and develop data structures for a problem
• can independently derive real-world situations as a data model
• can apply database systems in practice
• can compare database systems
• can carry out database management activities with NoSQL systems
• can explain database systems
• can identify different database systems and compare them
• can describe relational database systems
• can design and develop data structures for a problem
• can independently derive real-world situations as a data model
• can apply database systems in practice
• can compare database systems
• can carry out database management activities with NoSQL systems
Prerequisites for the course
none
Course content
- Fundamentals of database systems and data management
- Data modeling (single entity, attributes, cardinality, conditionality, relationship types)
- Candidate keys, superkeys, and primary keys
- Normalization of data structures (at least 1, 2, 3)
- Interaction with relational databases using SQL in the areas of DDL, DML, and DQL
- Basic database management activities on advanced database concepts in the area of NoSQL
- Data modeling (single entity, attributes, cardinality, conditionality, relationship types)
- Candidate keys, superkeys, and primary keys
- Normalization of data structures (at least 1, 2, 3)
- Interaction with relational databases using SQL in the areas of DDL, DML, and DQL
- Basic database management activities on advanced database concepts in the area of NoSQL
Recommended specialist literature
- Watson, R. T. (2013): Data Management. Databases and Organizations. 6th edition, eGreen Press
- Date, C. (2015): SQL and Relational Theory. 3rd edition, O’Reilly Media, 2015
- Kaufmann, M. and Meier, A.: SQL- & NoSQL-Datenbanken. 9th edition. Springer Vieweg 2022
- Date, C. (2015): SQL and Relational Theory. 3rd edition, O’Reilly Media, 2015
- Kaufmann, M. and Meier, A.: SQL- & NoSQL-Datenbanken. 9th edition. Springer Vieweg 2022
Assessment methods and criteria
Portfolio exam
Language
German
Number of ECTS credits awarded
6
Semester hours per week
Planned teaching and learning method
Lecture, group work, project work, individual assignments, presentations and discussion
Semester/trimester in which the course/module is offered
1