Week 10

Announcements

The take-home exam will be on Thursday, March 26, 2009.

Lecture Monday (02.03.2009)

The seventh lecture will close the SQL part of the course by introducing 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]

Exercise Wednesday (04.03.2009)

Remaining exercises from 26.02.2009 in PostgreSQL

Lecture Thursday (05.03.2009)

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

Topics

Interfacing with SQL, JDBC, PHP

Reading

Chapter 9