Week 09


Please fill in the following Doodle until Wednesday, February 29, 2012 in order to determine the date of the take-home exam:


Answer "Yes" if you are free, "(Yes)" if you have private plans, and "No" if you have another exam. In any other case, please select the best fitting option and leave a comment.

Exercise Tuesday (28.02.2012)

Exercise 7.1.2, 7.2.2, 7.2.4, 7.4.1, 7.5.2, 8.2.2

Lecture Thursday (01.03.2012)

The seventh lecture will close the SQL part of the course by introducing Constraints, Triggers, Views, Transactions, and Indexes. We will also consider the differences between the SQL standard and PostgreSQL w.r.t. advanced SQL constructs.


Views, Transactions, Indexes, SQL vs PostgreSQL


Chapter 6.6, Chapters 8.[3,4]

Lecture Friday (02.03.2012)

In the eigth lecture we will learn how to write programs that interact with databases based on call level interfaces for Java and Python.


Interfacing with SQL, JDBC, Psycopg2


Chapter 9

Design by 1234.info | Modified by Peter Schneider-Kamp | CSS 2.0