Oracle Corporation introduced the first Relational Database Management System based on the IBM System/R model and the first database management system utilizing IBM's Structured Query Language (SQL) technology. Today, the Oracle DBMS is supported on over 80 different operating environments, ranging from IBM mainframes, DEC VAX minicomputers, UNIX-based minicomputers, Windows NT and several proprietary hardware-operating system platforms, and is clearly the world's largest RDBMS vendor.
PL/SQL
Introduction to Oracle's PL/SQL programming language, includes writing and running PL/SQL programs from SQL*Plus and iSQLPlus, declaring and using variables and constants - Taken with the PL/SQL Stored Program Units course covers topics for Oracle9i PL/SQL Developer Certified Associate Examination #1Z1-147 and if taken with the SQL*Plus covers topics for Introduction to Oracle SQL and PL/SQL Examination #1Z0-001.
PL/SQL Stored Program Units
Course provides practical experience in developing and writing triggers, functions, procedures and packages, also introduces some of the Oracle-supplied packages including DBMS_LOB for handling Large Objects. Together with the PL/SQL course this course covers the topics required for the Oracle9i PL/SQL Developer Certified Associate Examination #1Z1-147 and all the topics required for the Oracle8i Develop PL/SQL Program Units Examination #1Z0-101. Before taking any exam, please ensure you have the recommended experience.
Oracle 9i DBA Architecture and Administration
Designed to give the Oracle database administrator practical experience in setting up, administering and troubleshooting an Oracle8i or Oracle9i database, gain an understanding of the architecture and processes of the Oracle server and ensure the integrity and availability of your company’s data within the Oracle environment. This course covers the main architecture and administration topics for the Oracle9i Database: Fundamentals I examination (IZ0-031).
Oracle Database 10G DBA - Part 1
Gives Oracle database administrator practical experience in setting up, administering and troubleshooting an Oracle10g database, gain an understanding of the architecture and processes of the Oracle database server, ensure the integrity and availability of your company’s data within the Oracle environment, monitor performance, perform basic backup and recovery of the database. This course covers the main examination topics of the Oracle exam #1Z1-042 Oracle Database 10g: Administration I.
Oracle9i Reports Developer
This course introduces the delegate to the main concepts of Oracle9i Reports Developer. It is designed to give delegates practical experience in designing and creating Web and paper reports using the Report Wizard, to add dynamic report data to static HTML pages and to publish reports on the Web.
Forms 9i – Part 1
Practical experience in using Oracle Forms to develop and deploy database applications, main features and components of a Form investigated and implemented, Forms Services components and configuration files customised for deployment - Together with the Forms - Part II course, this course is suitable for delegates intending to sit the Oracle9i Forms Developer Build Internet Applications Examination #1Z0-141.
Discoverer for End Users
Introduction to the end user of Oracle Discoverer Tool for processing workbooks, concept of the End User Layer and how, by building and manipulating workbooks, you can perform analysis of the data sources at your disposal.
