| Oracle Certified Associate Database Administrator 9i (Oracle OCADBA 9i): Information Center | |||
| Overview of Program | |||
| Oracle OCA-DBA 9i Requirements | |||
| Prerequisites: Understanding of computers and Databases | |||
| Must pass the 1Z0-007 exam or pass Both the 1Z0-001 and the 1Z0-031 | |||
| Exam Required 1Z0-007 | |||
| Learning Asset | Product Title | Product ID | Hours |
| Courseware | |||
| 1 | Introduction to Oracle and SQL in Oracle 9i | 66155_ENG | 3.25 |
| 1 | SQL Functions in Oracle 9i | 66472_ENG | 5.00 |
| 1 | Subqueries, Reporting, and User-Access Control in Oracle 9i | 66925_ENG | 2.50 |
| 1 | Defining and Manipulating Data in Oracle 9i | 67002_ENG | 3.50 |
| Totals | 4 | 14.25 | |
| Must pass the 1Z0-007 and 1Z0-031 if you choose not to take the 1Z0-007 Exam | |||
| Exam Required 1Z0-001 | |||
| Courseware | |||
| 1 | Oracle Introduction: SQL and SQL*Plus | SQPL01E | 4.00 |
| 1 | Oracle Introduction: Using Functions and Retrieving Data | SQPL02E | 4.00 |
| 1 | Oracle Introduction: Subqueries, Reports, and DML | SQPL03E | 4.00 |
| 1 | Oracle Introduction: Database Objects | SQPL04E | 4.00 |
| 1 | Oracle Introduction: Controlling Database Access and Integrity | SQPL05E | 3.00 |
| 1 | Oracle Introduction: PL/SQL Fundamentals | SQPL06E | 4.00 |
| 1 | Oracle Introduction: PL/SQL Cursors and Exceptions | SQPL07E | 4.00 |
| 1 | PL/SQL: Procedures and Functions | PLSPF | 6.00 |
| 1 | PL/SQL: Packages and Triggers | PLSPT | 4.00 |
| Totals | 9 | 37.00 | |
| Exam Required 1Z0-031 | |||
| Courseware | |||
| 1 | Users and Profiles in Oracle9i | 61604_ENG | 3.00 |
| 1 | Privileges and Roles in Oracle9i | 61608_ENG | 2.25 |
| 1 | Globalization and Auditing in Oracle9i | 61611_ENG | 2.00 |
| 1 | Data Storage in Oracle9i | 59293_ENG | 3.25 |
| 1 | Tables and Indexes in Oracle9i | 59296_ENG | 3.00 |
| 1 | Data Integrity in Oracle9i | 59299_ENG | 1.25 |
| 1 | Architecture and Administration Tools in Oracle9i | 58265_ENG | 2.50 |
| 1 | Database and Instance Management in Oracle9i | 58268_ENG | 2.25 |
| 1 | Database Structures in Oracle9i | 58271_ENG | 2.25 |
| Totals | 9 | 21.75 | |