Applied Database Systems Lab
N E W S   
30. September 2009
New Lab Dates.
Due to numerous conflicts with other courses the lab dates have been changed to Wednesday 1500-1550 and Thursdays 1305-1355.
30. September 2009
PostgreSQL Account.
For the tutorials you need to have a PostgreSQL database account. Please read the PostgreSQL User Self-Service Guide and activate your PostgreSQL database account before the first tutorial. If you cannot get a PostrgeSQL account, please fill out computing support request.
30. September 2009
The web pages are updated continuously. Tutorials are available on the web in advance. Please check here for the lates news.
T U T O R I A L S   
7th Oct. / 8th Oct. 2009 PostgreSQL Basics & Database Design
14 th / 15 th Oct. 2009 Basic SQL & Data Manipulation
21 st / 22 nd Oct. 2009 Further SQL Queries with some Example Answers
28 th / 29 th Oct. 2009 String Manipulation in PostgreSQL with some Example Answers
4 th / 5 th Nov. 2009 Data Integration Exercise with an Example Answer
11 th / 12 th Nov. 2009 Indexes
18 th / 19 th Nov. 2009 Query Execution Plans
Additional exercise regarding disk space
Please go through this short exercise before you start your work on assignment 3.
* Tutorial topics may still be subject to minor changes.
C O N T A C T   
Please send any corrections or suggestions to

Heiko Müller
Informatics Forum, Room 5.38
Office hours: Thursdays, 10:00-12:00