IT-DES offers at regular intervals a series of tutorials on Oracle.

These tutorials are usually held in the IT auditorium, bldg.31 3-004, starting at 10:00.

The tutorials are given in English, last approximately 1hour each, are free of charge and do not need prior registration.

The powerpoint files of each tutorial will be available here as soon as the tutorial has been given.

Some old tutorials were recorded and have links pointing to an EDMS Documentation page offering you the Recorded Tutorial link in the Associated URL section. If you have problems viewing the recorded tutorials, please check the troubleshooting page.

Under each tutorial link you will also find the slides and SQL code of the examples used for you to repeat at your convenience on your computer.

2006 New Curriculum:

• Thu. 30 March 2006 - Design (Nilo Segura)
• Thu. 20 April 2006 - SQL I (Eva Dafonte Perez)
• Thu. 27 April 2006 - SQL II (Lucia Moreno Lopez)
• Thu. 4 May 2006 - Oracle Architecture (Montse Collados)
• Thu. 11 May 2006 - Tuning (Michal Kwiatek)
• Thu. 1st June 2006 - PL/SQL I (Basic PL/SQL) (Eva Dafonte Perez)
• Thu. 8 June 2006 - PL/SQL II (Nilo Segura)
• Thu. 15 June 2006 - Tools and Languages Bindings (Nilo Segura)

If you need more information about this 2006 series, please contact Catherine.Delamare@cern.ch

Below you can access the material of the previous sessions:

2002-2003 Curriculum:

• Thu. 10 October 2002 - General Introduction (Nilo Segura)
• Thu. 17 October 2002 - Database design and very basic SQL (Paula Figueiredo)
• Thu. 24 October 2002 - SQL (1/3) (Monica Marinucci)
• Thu. 31 October 20002 - Database Architecture (Nilo Segura)
• Thu. 7 November 2002 - Advanced SQL (2/3) (Andrea Valassi)
• Thu. 14 November 2002 - Advanced SQL (3/3) (Andrea Valassi)
• Thu. 28 November 2002 - Tuning (Eric Grancher )
• Thu. 5 December 2002 - List of Oracle Tools (Eric Grancher and Nilo Segura)
• Thu. 23 January 2003 - PL/SQL (Marcin Nowak)
• Thu. 30 January 2003 - PL/SQL and the web (Montse Collados)
• Thu. 6 February 2003 - Java (1/2) (Dirk Duellmann)
• Thu. 13 March 2003 - Java (2/2) (Montse Collados)
• Thu. 15 May 2003 - OO database and access via C++ and Java (Dirk Geppert)
• Thu. 22 May 2003 - UML for RDBMS - Oracle approach (Krzysztof Nienartowicz)

2001 Curriculum:

• Thu. 18 October 2001- General introduction (Nilo Segura)
• Thu. 25 October 2001- Basic SQL and database design (Eric Grancher)
• Thu. 8 November 2001- Advanced SQL and Oracle8i features (Eric Grancher)
• Thu. 15 November 2001 - PL/SQL (Montse Collados)
• Thu. 22 November 2001 - PL/SQL and the Web and the Web (Montse Collados)
• Thu. 29 November 2001 - Java and Oracle (1/2) (Eric Grancher)
• Mon. 17 December 2001 - Java and Oracle (2/2) (Eric Grancher)

The books recommended in this series can be obtained from the CERN Computing Bookshop. The list of titles includes: