BNFD - Your DBA NoteBook On The Net!!!

Tuesday, September 11, 2007

Oracle 8i & 9i DBA certification

The Oracle Certification Program continues to be the most popular certification among all database vendors.Oracle has completely revamped the DBA Certification track with the release of the Oralce9i database. To best understand the modifications that the DBA track has undergone, it's best to first review the Oracle8i DBA track.
To become an Oracle8i Certified Professional (OCP) DBA, the certification candidate needed to pass five exams:
Introduction to Oracle: SQL and PL/SQL
Oracle8i: Architecture and Administration
Oracle8i: Backup and Recovery
Oracle8i: Performance Tuning
Oracle8i: Network Administration
With Oracle9i, the DBA Certification track is now divided into 2 primary tiers, as well as a third Master-level tier:
Oracle9i Certified Associate (OCA)
Oracle9i Certified Professional (OCP)
Oracle9i Certified Master (OCM)

Oracle9i Certified Associate (OCA) :

Oracle’s 9i OCA DBA (Database Administrator) certification is for “apprentice skill level” IT professionals who have have a foundation of knowledge that will allow them to act as a junior team member working with database administrators or application developers. Associate (OCA) requires passing two exams:
Introduction to Oracle9i: SQL
Oracle9i Database: Fundamentals I

Oracle9i Certified Professional (OCP):
The OCP tier was designed for mid to senior-level DBAs with one or more years of focused Oracle DBA experience. The knowledge and skills obtained from completing this tier of the certification program prepare the DBA to provide the full assortment of DBA-related tasks...from Database Design and Development to production tasks such as Performance Tuning and Backup & Recovery.
The Oracle9i Certified Professional (OCP) requires passing the two exams in the OCA Tier, plus two additional exams:
Oracle9i Database: Fundamentals II
Oracle9i Database: Performance Tuning

Oracle9i Certified Master (OCM):
There is a third tier to the Oracle9i DBA Certification Track, the OCM. This track is targeted at very senior level DBAs and Oracle consultants.The OCM designation first requires that you obtain your Oracle9i OCP credential. Once this is secured, Oracle requires that you take two advanced Oracle courses from Oracle University. These are Instructor-led courses

Oracle9i: Program with PL/SQL
Oracle9i: Advanced PL/SQL
Oracle9i: SQL Tuning Workshop
Oracle9i: Database: Real Application Clusters
Oracle9i: Database: Data Guard Administration
Oracle9i: Database: Implement Partitioning
Oracle9i: Data Warehouse Administration
Oracle Net Services: Advanced Administration
Oracle9i: Advanced Replication
Oracle9i: Enterprise Manager
Once you've completed the course requirements, you can then register for and take the "practicum" exam. The practicum is a two-day, hands-on performance exam that requires the candidate to perform a number of tasks using Oracle9i on the Linux platform. Some of the skills that need to be proven include: database configuration, replication, partitioning, parallel operations, diagnostics, troubleshooting, performance tuning, and backup and recovery...all with "real-world" scenarios.

2 comments:

Santosh Tripathy said...

Thank you very much for the guidelines you have given for my preparation to become an Oracle Certified DBA...I was confused what to read first, what book to choosee, to go for tutors or different sites...I think this article gives me idea at the base level about how to go about it. Thanks again.

Anonymous said...

This is nice to find simple way to certification.
Thanks