Datenbanken I/ Informationssysteme I

Instructors: Jun.-Prof. Dr. Panagiotis Bouros
Shortname: Datenbanken I
Course No.: 08.079.228
Course Type: Vorlesung/Übung

Contents


  1. Introduction to database management systems
  2. Database modelling with the entity-relationship model
  3. Relational model and relational algebra
  4. Structured query language (SQL) 
  5. Database design theory and normalization
  6. Data integrity, constraints and triggers
  7. Physical data organization and database indices
  8. Querying processing and optimization
  9. Transaction management and recovery
  10. Concurrency control

Additional information

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.
In summary, after completing this course, students should be able to:

  1. design, create and query relational databases to retrieve information
  2. explain the theoretical foundations of the relational model: in particular, the relational algebra and the relational design theory (normal forms, dependencies, and decomposition)
  3. to 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

Digitale Lehre

Short Description :
MS Teams

Description:

Additional Information

Dates

Date (Day of the week) Time Location
04/18/2023 (Tuesday) 12:00 - 14:00 00 521 N 1
1342 - Naturwissenschaftliches Hörsaalgebäude
04/25/2023 (Tuesday) 12:00 - 14:00 00 521 N 1
1342 - Naturwissenschaftliches Hörsaalgebäude
05/02/2023 (Tuesday) 12:00 - 14:00 00 521 N 1
1342 - Naturwissenschaftliches Hörsaalgebäude
05/09/2023 (Tuesday) 12:00 - 14:00 00 521 N 1
1342 - Naturwissenschaftliches Hörsaalgebäude
05/16/2023 (Tuesday) 12:00 - 14:00 00 521 N 1
1342 - Naturwissenschaftliches Hörsaalgebäude
05/23/2023 (Tuesday) 12:00 - 14:00 00 521 N 1
1342 - Naturwissenschaftliches Hörsaalgebäude
05/30/2023 (Tuesday) 12:00 - 14:00 00 521 N 1
1342 - Naturwissenschaftliches Hörsaalgebäude
06/06/2023 (Tuesday) 12:00 - 14:00 00 521 N 1
1342 - Naturwissenschaftliches Hörsaalgebäude
06/13/2023 (Tuesday) 12:00 - 14:00 00 521 N 1
1342 - Naturwissenschaftliches Hörsaalgebäude
06/20/2023 (Tuesday) 12:00 - 14:00 00 521 N 1
1342 - Naturwissenschaftliches Hörsaalgebäude
06/27/2023 (Tuesday) 12:00 - 14:00 00 521 N 1
1342 - Naturwissenschaftliches Hörsaalgebäude
07/04/2023 (Tuesday) 12:00 - 14:00 00 521 N 1
1342 - Naturwissenschaftliches Hörsaalgebäude
07/11/2023 (Tuesday) 12:00 - 14:00 00 521 N 1
1342 - Naturwissenschaftliches Hörsaalgebäude
07/18/2023 (Tuesday) 12:00 - 14:00 00 521 N 1
1342 - Naturwissenschaftliches Hörsaalgebäude