RegisterSign In

Oracle 9i OCA/OCP

ProTrain Online

Description

ORACLE 9i COURSE CURRICULUM

I. Exam 1Z0-007: Introduction to Oracle 9i: SQL OCA Curriculum

Program Overview:

Oracle have jointly developed e-Learning content on Oracle's leading relational database technology. Oracle certifications are some of the most sought after in the Information Technology industry. The Associate credential represents the entry level for the Oracle certification program, and is a first step for those pursuing Professional or Master credentials. Students who achieve the Oracle 9i DBA Associate Credential can demonstrate a foundation level knowledge of Oracle 9i database administration.

Target Audience:

The Oracle 9i Database Administrator Certified Associate credential is aimed at the level of those working as junior members of Oracle database administration teams.

Prerequisites:

Students should be familiar with data processing concepts, and be able to use a graphical user interface.

Requirements:

Students must pass the following exam requirements to attain an Oracle OCA 9i credential: 1Z0-007, and 1Z0-031

  • Introducing Oracle and SQL
  • Subqueries, Reporting and User-Access Control
  • SQL Functions
  • Defining and Manipulating Data

II. Exam 1Z0-031: Oracle9i Database Fundamentals I

  • Architecture and Administration Tools in Oracle9i
  • Database and Instance Management in Oracle9i
  • Database Structures in Oracle 9i
  • Data Storage in Oracle9i
  • Tables and Indexes in Oracle9i
  • Data Integrity in Oracle9i
  • Users and Profiles in Oracle9i
  • Privileges and Roles in Oracle9i
  • Globalization and Auditing in Oracle9i
  • OCP Curriculum: Requires OCA certification.
  • III. Exam 1Z0-032: Oracle9i Database: Fundamentals II

    Program Overview:

    Oracle have jointly developed e-Learning content on Oracle's leading relational database technology. Oracle certifications are some of the most sought after indications of credibility in the Information Technology marketplace. The OCP identifies competency in intermediate and advanced Oracle database administration skills.

    Target Audience:

    The Oracle 9i Database Administrator Certified Professional credential is aimed at the level of those who have progressed beyond the OCA (Associate) level certification and who have gotten hand-on experience in database administration.

    Prerequisites:

    Student should already be OCA 9i accredited. Those who have not taken their first OCP exam prior to September 1st 2002, and are not already OCP-accredited (in version 7.3, 8.0 or 8i), must attend one instructor-led class or instructor-led online course offered at an Oracle University center or at an Oracle Authorized Education Center or Partner.

    Requirements:

    Candidates pursuing Oracle9i DBA OCP must pass the following two exams: 1Z0-032, and 1Z0-033.

    • Networking Overview for Oracle9i Administrators
    • Oracle Network Configuration in Oracle9i
    • Backup and Recovery Overview and Configuration in Oracle9i
    • User-Managed and RMAN Backup and Recovery in Oracle9i
    • Recovery Manager Maintenance in Oracle9i
    • Transporting and Loading Data in Oracle9i

    IV. Exam 1Z0-033: Oracle9i Performance and Tuning

    • Performance Tuning Methodology and Tools in Oracle9i
    • Tuning Memory Structures in Oracle9i
    • Tuning Database Structures in Oracle9i
    • Tuning Systems and Applications in Oracle9i

    Also Available:

    Exam 1Z0-030: Oracle9i Database: New Features for Administrators

    Program Overview:

    In order to make the process of staying current as an Oracle Certified technical professional, those already certified on previous releases of Oracle may upgrade to each future release by simply completing one migration exam. For example, one exam upgrades the Oracle7.3 credential to Oracle8, one exam upgrades the Oracle8 credential to Oracle8i, and one exam upgrades the Oracle8i credential to Oracle9i.

    Target Audience:

    Oracle certified technical professional Database Administrators Prerequisites: Must be already certified on previous releases of Oracle

    Requirements:

    Students must pass the following exam requirement to attain an Oracle 9i upgrade credential, 1Z0-030.

    Introducing Oracle9i Database

  • Manageability Enhancements in Oracle9i
  • Availability Features in Oracle9i
  • Scalability and Performance in Oracle9i
  • Development Platform in Oracle9i
  • Security Overview for Oracle9i Administrators
  • Outcomes

    Students who achieve the Oracle 9i DBA Associate Credential can demonstrate a foundation level knowledge of Oracle 9i database administration.

    Assessment

    Students must pass the following exam requirements to attain an Oracle OCA 9i credential: 1Z0-007, and 1Z0-031

    course quick facts
    course code PRO1225
    cost $1725.00
    estimated time to
    complete course
    180 Hours
    course materials
    available
    12 Months