SQL Technologies 2002

Special Topics:
* SQL:1999 Advanced Features
* SQL:1999 Object-Relational Features
* SQL:1999 and Transaction Programming
* SQL/PSM, SQL/CLI, and Implementations
* SQL and Future Trends, SQL/XML, …
for database professionals in 2002 and in future

 

 

 

 

 

 


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
SQL-Invoked Routines, UDTs - Ocelot and survey of the big DBMSs

 

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, …
Closing session at 4011

 

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