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
Web-Pages.
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