Week 09

Announcements

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

http://www.doodle.com/kgiasu36i55ui249

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.

Topics

Views, Transactions, Indexes, SQL vs PostgreSQL

Reading

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.

Topics

Interfacing with SQL, JDBC, Psycopg2

Reading

Chapter 9