Apply
now
now
Data Engineering Lab
level of course unit
BachelorLearning outcomes of course unit
This course builds on the learning objectives of the associated ILV and consolidates them in practical work with the concepts learned. The students:
- can apply database systems in practice
- can interact with database systems
- can independently create data models
- can develop and implement data structures for a problem
- can apply database systems in practice
- can interact with database systems
- can independently create data models
- can develop and implement data structures for a problem
prerequisites and co-requisites
none
course contents
The following contents are covered in this course:
- Modeling and implementation of simple entity types (appropriate attributes, primary keys, etc.)
- Modeling and implementation (DDL/DML) of 1:1, 1:n and n:m relationship types
- Modeling and implementation (DDL/DML) of recursive relationships
- Interaction with simple and complex data structures (DQL)
- Modeling and implementation of simple entity types (appropriate attributes, primary keys, etc.)
- Modeling and implementation (DDL/DML) of 1:1, 1:n and n:m relationship types
- Modeling and implementation (DDL/DML) of recursive relationships
- Interaction with simple and complex data structures (DQL)
recommended or required reading
- 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
- Date, C. (2015): SQL and Relational Theory. 3rd edition, O’Reilly Media, 2015
assessment methods and criteria
Portfolio assessment
language of instruction
Germannumber of ECTS credits allocated
2eLearning quota in percent
0course-hours-per-week (chw)
1planned learning activities and teaching methods
- Individual exercises
- Group project
- Group project
