Database Concepts (English course for "Datenbanken I")

Organization

Lecturer: Prof. Dr. rer. nat. habil. Gunter Saake
Lecture: LSF-Entry
Tutors:

Sadeq Darrab

Exercise: LSF-Entry
Material: Moodle-Link
Credits:  5 CP for Bachelor, 6 CP for Master (Module Handbook)

News

  • The course is held as an online course in the summer semester 2023, starting from 10.04.2024. Please register for the course via Moodle.
  • The first exercise will be discussed in the week of 22.04.2024
  • All the course material will be posted on Moodle.
  • Link to SQLValidator for checking your SQL statements.

Exam Requirements

  • Register for an exercise group via Moodle.
  • Submit and have a positive assessment of 60 percent of all exercise tasks in this course.
  • Present your solutions at least four times during the exercises.
  • The exam will be a written exam.

Contents 

  • Motivation and History  
  • Background Concept and Architecture
  • Data Models for Design
  • Data Models for Implementation
  • Database Design and Data Definition
  • Query and Update Operations
  • Relational Database Languages
  • Database Application Programming
  • Integrity Constraints, Transactions and Triggers
  • Views and Access Control

Literature

Datenbanken - Konzepte und Sprachen von Gunter SaakeKai-Uwe Sattler und Andreas Heuer (MITP-Verlag, 2018)

undefined

Datenbanken
Konzepte und Sprachen

Gunter Saake, Kai-Uwe Sattler, Andreas Heuer

777 Seiten,
39,95 , geb.,
März 2018,
ISBN 978‐3‐95845‐777‐5
Mitp-Verlag; Auflage: 6

Last Modification: 08.03.2024 - Contact Person: