SQL Technologies 2002
|
Special Topics: |
|
Schedule and Preliminary Plan
for the Seminar on 20-22 March 2002 at Helia - Helsinki Business Polytechnic
|
Wednesday 20 |
SQL Technologies (Auditorium): |
|
08:30-09 |
Registration and coffee |
|
09-10 |
Introduction to SQL:1999 and the Ocelot |
|
10:20-12 |
SQL objects, types, character sets and collations, the SQL:1999 language elements, - demos of the Ocelot implementation |
|
12-13 |
Lunch break |
|
13-15 |
Constraints, assertions, triggers |
|
|
Coffee break |
|
15:15-16 |
SQL:1999 Object-Oriented Aspects, Prof. Laux |
|
16-16:30 |
SQL:1999 impact on the database technology |
|
Thursday 21 |
R1 Small Auditorium: |
|
09-10 |
SQL:1999 Data manipulation, Searching and OLAP extensions |
|
10:20-12 |
SQL Optimization |
|
12-13 |
Lunch break |
|
|
Labs at building 2 microlabs 4011/4012: |
|
13-14:20 |
Ocelot Tutorial on SQL:1999 |
|
14:40-16:30 |
SQL:1999 and Optimization Lab (SQL2000, DB2, Oracle,…) |
|
Friday 20 |
R1 Small Auditorium: |
|
09-10 |
SQL Transaction types, SQL/CLI, and Implementations |
|
10:20-12 |
SQL/PSM and Dialects |
|
12-13 |
Lunch break |
|
|
Labs at building 2 microlabs 4011/4012: |
|
13-14:20 |
SQL:1999 and Transaction Lab |
|
14:40-15:30 |
Call Level Interface |
|
15:30-16:00 |
SQL:200n, SQL/XML, … |
Speakers:
Authors of the book "SQL-99 Complete, Really" Peter Gulutzan & Trudy Pelzer
Ocelot Computer Services Inc. http://ourworld.compuserve.com/homepages/OCELOTSQL/
|
|
|
|
|
Trudy Pelzer |
The Book |
Peter Gulutzan |
Prof. Dr. Fritz Laux, Fachhochschule Reutlingen, Business & Information Science, Reutlingen, Germany
Organizers:
DBTechNet http://www.dbtechnet.org
Helsinki Business Polytechnic http://www.helia.fi
ATK-instituutin Kannatusyhdistys r.y.
For further information and enrollments please contact:
15.3.2002-19.3.2002
Carita Niskanen
tel 09-1489 0244, international +358-9-1489 0244
email: Carita.Niskanen@helia.fi
22.2.2002-13.3.2002
Pia Lemmetty
tel 09-1489 0240, international +358-9-1489 0240
email: pia.lemmetty@helia.fi
- - -
For students of Helia and HAMK the seminar is part of the study unit "Advanced SQL Programming" (2 credit units, 3 ECTS points) with the final exam on Friday 19 April 2002 at 13:00-15:30. The students will be using the Ocelot DBMS in the exam. The subject area covers parts of SQL:1999 to be announced at the seminar.
For more information please contact
Martti Laiho
email: martti.laiho@helia.fi
tel +358-9-14890 228
Right to changes reserved