Database Concepts (English course for "Datenbanken I")
Organization
| Lecturer: | Prof. Dr. rer. nat. habil. Gunter Saake |
| Lecture: | LSF-Entry |
| Tutors: | |
| 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 Saake, Kai-Uwe Sattler und Andreas Heuer (MITP-Verlag, 2018)
|
Datenbanken Gunter Saake, Kai-Uwe Sattler, Andreas Heuer 777 Seiten, |