Database Theory (1DV013)

Professor

Time & Place

Compare here (1DV013).

Teaching Period

I (2014-09-01 till 2014-10-31)

Important Information

Because of the reduced teaching load of Prof. Kerren in this semester, he only provides the lectures incl. slides for this course. For all other questions with respect to introduction, assignments, exams, etc., interested students have to contact Kostiantyn Kucher instead.

Prerequisites

60 higher education credits in Computer Science including a course in Programming and Data Structures as well as good programming experiences.

Credits

7.5 ECTS

Topic

Database Theory

This course is intended to give students a solid background in database systems and theory, with a focus on relational database management systems. Topics include general information on database systems, data modeling (E/R model, relational data model), database design theory, data definition and manipulation languages (SQL), and database programming interfaces.

Schedule

Preliminary Schedule:

#	Date	Topic	Slides
1	2014-09-01	Introduction
2	2014-09-08	Database Management Systems (Intro)
3	2014-09-11	Entity-Relationship (E/R) Model
4	2014-09-15	Relational Data Model - Part I
5	2014-09-18	Relational Data Model - Part II
6	2014-09-25	Relational Algebra
7	2014-09-29	Structured Query Language (SQL) - Part I
8	2014-10-02	Structured Query Language (SQL) - Part II
9	2014-10-09	Application Programming with SQL