Recommended Course Sequences

Note: The courses identified below do not specify a product release, (e.g., Oracle10g). It is recommended that all courses be taken under the same release.

Managers, Business Analysts, and End Users

Managers and End Users who wish to understand Oracle and may occasionally need access to data stored in an Oracle database, but will be using an "in-house" application:
  1. Oracle Concepts and Facilities
Managers and End Users who wish to understand Oracle and will need access to data stored in an Oracle database. These individuals may use an "in-house" application or develop and run their own queries:
  1. Oracle Concepts and Facilities
  2. Oracle SQL Fundamentals

Programmers and Analysts

Programmers and Analysts developing new applications or supporting existing applications that use Oracle:
  1. Oracle Concepts and Facilities
  2. Oracle SQL Fundamentals
  3. Advanced SQL
  4. Oracle PL/SQL Programming
  5. Oracle PL/SQL Program Units
  6. Oracle SQL Tuning
If responsibilities include designing a new database or administering a database for a workgroup environment, then the following courses could also be taken:
  • Logical Data Modeling
  • Oracle Database Administration Lite
Note: Many of our clients have used the Oracle Database Administration Lite course to provide developers with an in-depth exposure to the Oracle architecture. Although these individuals were not responsible for database administration, they found the material covered in the course helped them to better understand how the Oracle DBMS operates.

This course is also appropriate for experienced SQL users who are familiar with other RDBMS products.

Database Administrators

Database Administrators responsible for an Oracle database:
  1. Oracle Concepts and Facilities
  2. Oracle SQL Fundamentals
  3. Oracle PL/SQL Programming
  4. Oracle PL/SQL Program Units
  5. Oracle SQL Tuning
  6. Logical Data Modeling
  7. Oracle Database Administration
  8. Oracle Database Performance and Tuning
  9. Oracle Database Backup and Recovery

Programmers, Analysts, and Database Administrators familiar with Oracle or a non-Oracle RDBMS

For those individuals already familiar with Oracle, the New Features course would provide an overview of the new features available in the current release. Database Administrators already familiar with Oracle would benefit from the New Features for Administrators course.

For those individuals familiar with another DBMS, such as DB2 or SQL Server, the Concepts and Facilities course would be a good starting point to become acquainted with the Oracle DBMS. Because Oracle is compliant with the ANSI SQL:1999 standard, familiarity with SQL would likely make the SQL & SQL*Plus course unnecessary. The PL/SQL Programming course would then be the next course for these individuals.

Another option for people familiar with Oracle or a non-Oracle RDBMS is to take Oracle Introduction for Experienced SQL Users.

Installations interested in using the Object-Oriented features of Oracle should inquire about customized training for these features.
Note: If you are not sure which courses are right for you, give us a call and we would be pleased to discuss the individual training requirements for your organization and recommend a curriculum which could be tailored to satisfy your specific needs.

If these course descriptions do not satisfy your needs, give us a call and we can discuss a customized presentation.