Oracle
8i DBA Overview
The Oracle8i Certified Database Administrator Track is a certification path that results in the award of a credential to proven performers in the role of database administrator. The track consists of five tests designed so you can translate your knowledge and skills into a tangible, well-recognized professional certification.
The Best Database Administrators (DBAs)
-
Operate primarily behind the scenes.
-
Watch for ways to fine-tune day-to-day performance to prevent unscheduled crises, such as a crashed database or hours of expensive downtime.
-
Know they stand between optimal performance and an event that could bring their company to a standstill.
This critical
work requires a broad understanding of the architecture and processes
of the Oracle database, as well as plenty of hands-on experience
solving problems.
Candidate
Qualifications
Most candidates for DBA certification combine up-to-date training
with some level of on-the-job experience. There is no "typical"
candidate. If you are seeking certification to gain entry into
the IT industry, you will need more than training to earn the
credential. Many of the questions in the OCP tests are based on
realistic job scenarios. In addition to the appropriate training,
you will need hands-on experience with the software.
At Cyber Networks Ltd, we offer two paths to the Oracle8i Certified Database Administrator:
1. Oracle8
to Oracle8i Upgrade Path (1 exam)
Candidates certified on Oracle8 can take "Exam 1Z0-010 Oracle8:
New Features for Administrators" to upgrade their certification
to Oracle8i.
2. Oracle8i
Core Path (5 Exams)
New OCP candidates can take the core exams below exclusively from
the Oracle8i track.
| Course Name | Duration(Hours) | Exam | Exam Title |
| Introduction to SQL and PL/SQL | 30 | 1Z0-001 | Introduction to Oracle: SQL ® and PL/SQL™ |
| Oracle8i: Architecture and Administration | 30 | 1Z0-023 | Oracle8i Architecture and Administration |
| Oracle8i: Backup and Recovery Workshop | 18 | 1Z0-025 | Oracle8i Backup and Recovery |
| Oracle8i: Performance Tuning Workshop | 12 | 1Z0-024 | Oracle8i Performance and Tuning |
| Oracle8i: Network Administration | 30 | 1Z0-026 | Oracle8i Network Administration |
Introduction to Oracle: SQL and PL/SQL (5 days)
1. Oracle SQL:
Basic SELECT Statements
2. Oracle SQL: DML and DDL
3. Oracle SQL: Data Retrieval Techniques
4. Oracle PL/SQL: Basics
Enterprise DBA Part 1A: Architecture and Administration (5 days)
1. Oracle8i Database
Administration: Manage an Instance
2. Oracle8i Database Administration: Create a Database
3. Oracle8i Database Administration: Manage Storage Structures
4. Oracle8i Database Administration: Manage Data Storage
5. Oracle8i Database Administration: Manage Security
Enterprise DBA Part 1B: Backup and Recovery (3 Days)
1. Oracle8i Backup
and Recovery: Strategies and Backups
2. Oracle8i Backup and Recovery: Troubleshooting and Recovery
Enterprise DBA Part 2: Performance and Tuning (2 days)
1. Oracle8i Performance
Tuning: Strategies and Tecniques
2. Oracle8i Performance Tuning: Manage Memory, And Disk I/O
3. Oracle8i Performance Tuning: Optimizing Sorts and Minimizing Contention
Enterprise DBA Part 3: Network Administration (5 days)
1. Oracle8i Network
Administration: Net8 Architecture and Basic Configuration
2. Oracle8i Network Administration: Net8 Additional Configuration
and Troubleshooting