Database Concepts (DB1 Eng)

Organization

Lecturer: Prof. Dr. Gunter Saake
Lecture: LSF-Entry
Exercise Instructor: David Broneske, Naveen Gullipalli, Madhuri Hebbale 
Exercise: LSF-Entry

Exam Requirements

  • 60 percent of the exercise tasks need to be prepared
  • 4 tasks needs to be presented

News 

  • The exercises start in the third week of lectures.
  • The registration for the exercise is done using an extra tool.
  • Link to SQLValidator for checking your SQL statements.

 

Content

  • 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 Constrains, Transactions and Triggers
  • Views and Access Control

Lecture

Slides/handouts for the lecture will be made available here during the running lecture.

Introduction (PDF)

  1. What are Databases? (PDF)
  2. Relational Databases, Data as Tables (PDF)
  3. Entity Relationship Model (PDF)
  4. Database Design (PDF)
  5. The Relational Query Language SQL
  6. Relational Database Design Theory
  7. Query Basics: Algebra & Calculus
  8. Transactions, Integrity & Triggers
  9. Views and Access Control
  10. Database Application Programming

 

Exercise

  1. Exercise1 (16.04.-20.04.)
  2. Exercise2 (23.04.-27.04.)
  3. Exercise3 (30.04.-04.05. - SQLValidator can be used)

Last Modification: 23.04.2018 - Contact Person:

Sie können eine Nachricht versenden an: Webmaster
Sicherheitsabfrage:
Captcha
 
Lösung: