Database Concepts (DB1 Eng)

Organization

Lecturer: Prof. Dr. Gunter Saake
Lecture: LSF-Entry
Exercise Instructor: David Broneske, Naveen GullipalliJohannes Wünsche
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 LSF -- after the first lecture.
  • 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

  1. What are Databases?
  2. Relational Databases, Data as Tables
  3. Entity Relationship Model
  4. Database Design
  5. Relational Database Design Theory 
  6. The Relational Query Language SQL 
  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.) -- to be uploaded

 

 

 

 

 

Last Modification: 19.03.2019 - Contact Person:

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