Oracle Training at CERN DB Workshop for LHC

Oracle Training at CERN DB Workshop for LHC online/offline developers Montse Collados – IT/DES January 2005 Oracle Training at CERN Montse Collados

Outline n Oracle tutorials n Oracle web based courses n Oracle on-site courses n Oracle external courses January 2005 Oracle Training at CERN Montse Collados 2

Outline n Oracle tutorials n Oracle web based courses n Oracle on-site courses n Oracle external courses January 2005 Oracle Training at CERN Montse Collados 3

Workshops & Tutorials Organised by IT-ADC and IT-DES groups – ADC would be happy to setup similar events focused to the physics environment n Either as workshop or individual seminars – Sessions of 1 h/1 h 30 per topic – Theory & Demos n Access to tutorial materials use in this physics database workshop n – http: //agenda. cern. ch/full. Agenda. php? ida=a 044825 n Generic Oracle training – http: //cern. ch/db/training/tutorial. html January 2005 Oracle Training at CERN Montse Collados 4

Existing Tutorials n n n n General introduction Database Design and basic SQL (1/3) Advanced SQL I (2/3) Advanced SQL II (3/3) Database Architecture n Tuning Oracle Tools PL/SQL and the Web Java Relational (1/2) Java and the Web (2/2) OO database, C++, Java n UML and Oracle n n n Many of which have been presented this week January 2005 Oracle Training at CERN Montse Collados 5

Tutorials material January 2005 Oracle Training at CERN Montse Collados 6

Outline n Oracle tutorials n Oracle web based courses n Oracle on-site courses n Oracle external courses January 2005 Oracle Training at CERN Montse Collados 7

Oracle Web Based Courses n Organized by Technical Training n Variable duration (around 1 day) n Subscription valid for 3 months n Low cost (around 50 chf/course) n Just in Time n http: //cern. ch/humanresources/external/training/tech/WBTech. T / January 2005 Oracle Training at CERN Montse Collados 8

Oracle Web Based Courses January 2005 Oracle Training at CERN Montse Collados 9

Web Based Courses Subjects n 39 courses on Oracle – SQL – PL/SQL – Oracle Forms – Reports – Administration – Backup – Tuning January 2005 Oracle Training at CERN Montse Collados 10

Outline n Oracle tutorials n Oracle web based courses n Oracle on-site courses n Oracle external courses January 2005 Oracle Training at CERN Montse Collados 11

Oracle On-Site Courses n Organised by IT/DES & Technical Training Service n Provided by an external company n Variable duration (2 -5 days) n 500 -1300 chf n Needs registration n In TT Premises n http: //cern. ch/hr-web/external/training/tech/software/te_softw. asp January 2005 Oracle Training at CERN Montse Collados 12

Oracle (Andiamo) Introduction to databases ? days Oracle Curriculum at CERN Database Analysis & Design SQL 2 -3 days Java Programming ? days Andiamo 3 days Oracle (Andiamo Customized) Jdeveloper PL/SQL (Web Progr) January 2005 ? days XML (9 i) 3 days BC 4 J, Db Triggers, ) using Jdeveloper 2 days Java. DB (JDBC, Servlets, JSP, 5 days Oracle Developer Forms 5 days Oracle Designer: First Class 5 days (Intro, Programming) 3 days PL/SQL Introduction to XML 2 days Oracle features for developers 3 days Other Oracle Training at CERN Montse Collados 13

Outline n Oracle tutorials n Oracle web based courses n Oracle on-site courses n Oracle external courses January 2005 Oracle Training at CERN Montse Collados 14

Oracle External Courses n More expensive – Travel + hotel + course registration n IT/DES can help if needed n Recommended only if: – Very specific course (not offered at CERN) – Urgent courses January 2005 Oracle Training at CERN Montse Collados 15

Conclusion Duration Cost Oracle tutorials short free Oracle web based courses 1 day ~ 50 chf Oracle on 1 -3 days site courses Oracle external courses January 2005 Response Location Type CERN Desk Overview Introduction Flexible Desk / Home Pre / Post Reference ~ 1000 chf Registration CERN Expensive Can be fast Off site Oracle Training at CERN Montse Collados Urgent Specific 16

To Stay Informed n IT-ADC Physics Database Service – For physics database workshops http: //wwwdb. web. cern. ch/wwwdb/phydb n LCG 3 D Project – For distributed database deployment in LCG – http: //lcg 3 d. cern. ch IT-DES Training Web Page: http: //cern. ch/db/training/ n News Group: news: //cern. oracle news: //cern. computing n Contact: IT/DES or IT/ADC: technical choice Technical Training Services: organization n January 2005 Oracle Training at CERN Montse Collados 17