(Datenbanken I/Informationssysteme I)
Description
Databases are a key technology in practical and applied computer science. Database management systems play an increasingly central role for businesses as a large part of companies‘ and user data are stored inside and managed by databases. Students will learn the principles of database management systems and how to use them. Special emphasis is placed on modelling and database design. In addition, focus is on learning the standard database language SQL which will enable students to apply the knowledge they have acquired in practice.
Objectives
In summary, after completing this course, students should be able to:
- design, create and query relational databases to retrieve information
- explain the theoretical foundations of the relational model: in particular, the relational algebra and the relational design theory (normal forms, dependencies, and decomposition)
- consider the practical aspects in the application, the use of index structures, the processing and optimization of queries, the concepts of transaction management and concurrency control
Contents
- Introduction to database management systems
- Database modelling with the entity-relationship model
- Relational model and relational algebra
- Structured query language (SQL)
- Database design theory and normalization
- Data integrity, constraints and triggers
- Physical data organization and database indices
- Querying processing and optimization
- Transaction management and recovery
- Concurrency control