James Di Ianni Director Oracle Certification Program Oracle

James Di. Ianni Director Oracle Certification Program Oracle Corporation

Oracle Certified Professional Program - Value, Overview, Learning

Agenda Ÿ Value and Benefits of the Oracle Certified Professional Credential Ÿ Oracle Certification Program Overview Ÿ Oracle Certified Master Practicum Ÿ Learning and preparation Ÿ References Ÿ Questions and answers Ÿ Next steps

Value and Benefits

Value of the Oracle Certification Credential Ÿ Competitive edge, differentiation & credibility = Job Opportunities Ÿ Improved Efficiencies – – – Certified professionals handle more support calls Companies advocating certification report less downtime Employer ROI Payback in only nine months because of savings due to increased internal effectiveness IDC Ÿ Quicker adoption of technology Ÿ Improved customer service - Harte Hanks, December 2002

What OCPs Have Said Ÿ Three out of four OCPs feel their certification gives them greater confidence. Ÿ Three out of five OCPs feel they have a competitive edge over their non certified counterparts. Ÿ 70% feel the OCP process has helped them maintain skills. Ÿ Two thirds of OCPs working as consultants have benefited through: – – – New contracts Client retention Greater access to new opportunities Harte Hanks, December 2002

Benefits of the Oracle Certification Credential Ÿ Use of OCA, OCP, and OCM logos for endorsement of your career by leveraging Oracle’s established brand equity Ÿ OTN Support Network, Oracle Press Discounts Ÿ Special event access Ÿ Ability to join the certification member community with more than 197, 000 from around the globe

OCP Program Overview

Oracle Certification Program OCM Oracle Certified Master Achieved by the Top Oracle Professionals OCP Oracle Certified Professional OCA Oracle Certified Associate Hiring Manager Approved Industry Benchmark Get Certified, Establish Credibility, Increase Opportunities Answers the Demand for more Oracle Professionals Learn Online Test Online Get a Job Online

Why Three Certification Tiers? Ÿ Provides a tool for IT managers to use in making hiring decisions Ÿ More closely aligned with job roles and skill levels Ÿ OCA can be used as the first step in a professional career and development path Ÿ OCP demonstrates professional commitment Ÿ OCM provides a performance based benchmark for hiring experts

Oracle Certification Paths Ÿ OCA: – – – Oracle 9 i DBA Certified Associate Oracle 9 i. AS Web Administrator Certified Associate Oracle 9 i PL/SQL Developer Certified Associate Ÿ OCP: – – Oracle 8 i DBA Certified Professional Oracle 9 i DBA Certified Professional Oracle 6 i Internet Application Developer Certified Professional Oracle 9 i Forms Developer Certified Professional Ÿ OCM: – Oracle 9 i Database Administrator Certified Master

Upgrading Your Certification Ÿ OCP: Developer – Upgrade from Developer 6/6 i – Oracle 9 i Forms Developer Upgrade Exam Ÿ OCP: Database Administrator – – 7. 3 – 9 i: One upgrade exam (For 7. 3 and 8. 0 DBA OCPs) 8 i – 9 i: One upgrade exam (For 8 i DBA OCPs) Ÿ 10 g Certification Plans – – – OCA Level OCP Level Streamlined upgrade paths from 7. 3, 8. 0, 8 i, and 9 i

Oracle Certified Master Credential

What is the Oracle 9 i DBA Certified Master? Ÿ Two day, live application performance test Ÿ Proctored exam environment Ÿ Candidates are scored on their ability to complete complex scenarios and resolve technical problems Ÿ Strict time frames are enforced for each scenario Ÿ Although the OCM is conducted in an Oracle classroom it is a certification exam and not a course Ÿ Pass rate is 60% for first time takers

OCM Candidate Prerequisites Ÿ Must have Oracle 9 i DBA Certified Professional credential Ÿ Must have “Attended” at least two instructor led advanced courses from approved list Ÿ Minimum of 3 – 4 years of practical experience as an Oracle DBA Ÿ Knowledge of Oracle 9 i database technology and features

Oracle 9 i DBA Certified Master Content Areas Ÿ Database Configuration Ÿ Oracle Network Configuration Ÿ Oracle Enterprise Manager Ÿ Data Management Ÿ Database Management Ÿ Performance Management Ÿ Database Availability Ÿ Standby Database and Data Guard

Minimum Required OCM Participant Skills Ÿ Working knowledge of Linux: – – – Formatting and executing basic OS commands Creating and navigating through directory structures File management using copy, move, and remove Linux environment text editors (Line Mode or GUI) Setting environment variables

Minimum Required OCM Participant Skills Ÿ Ability to locate and launch Oracle 9 i executables: – – – – – Database Creation Assistant Listener Utility Oracle Net Manager Oracle Net Configuration Assistant OEM OMS Oracle Password Utility RMAN Utility SQLPLUS

Minimum Required OCM Participant Skills Ÿ Proficient with working in a command line environment Ÿ Proficient with using Oracle Enterprise Manager Ÿ Advanced knowledge and use of Oracle 9 i (9. 0. 2. 2) features and functionality Ÿ Familiarity with navigating through non searchable Oracle documentation Ÿ Familiarity with navigating through and the functions of Konqueror browser software Ÿ Ability to employ “BEST PRACTICES” when working in an Oracle 9 i database environment to solve complex technical problems

Who Does the Best on the OCM? Ÿ People who have practiced in an Oracle 9 i database environment Ÿ People who have completed tasks relevant to each of the objectives within each functional area on the practicum Ÿ People who have practiced in a Linux environment Ÿ People who have practiced in a Konqueror environment Ÿ People who study!!!!!

Tech Tips for OCM Preparation Ÿ Use “BEST PRACTICES” for: – Database performance – Database backup, restores, and recovery Ÿ Study the areas you are the most familiar with, allowing you to complete the most activities within stated time frames Ÿ Familiarize yourself with using Oracle 9 i tools in a Linux environment Ÿ Practice recovery from different failure scenarios

Six Steps to Get Started With Oracle Certification 1. Visit the Oracle Certification Program Website – – www. oracle. com/education/certification Review the Link for First Steps 2. Decide on the track that best fits your career path – Should you not have a path chosen, consult with an Oracle University Representative to get you started 3. Figure out your preparation level with STS practice exams and test content checklists on the OCP website – Find where you have skill gaps and address them before testing

Six Steps to Get Started With Oracle Certification 4. Consult with OU for Preparation Assistance and Guidance 5. Take your first exam online! * 9 i DBA and Developer Tracks Only) 6. Register for additionally required exams with Prometric at www. 2 test. com

Learning and Preparation from Oracle University Ÿ Certified OU instructors are the best in the industry Ÿ Curriculum maps directly to job roles and exams Ÿ Emphasis on applying knowledge and skill vs. memorization Ÿ Hands on practice and labs on real software installations provide REAL skill Ÿ Various training methods (classroom and online) Ÿ Self Test Software practice tests help you Identify skill gaps and areas where you need more prep

Valuable References Ÿ Oracle Certification Programs Global Site – www. oracle. com/education/certification Ÿ Oracle University Global Site – www. oracle. com/education Ÿ Oracle Online Learning – www. oracle. com/education/oln Ÿ Oracle Technology Network – http: //otn. oracle. com

Q& A QUESTIONS ANSWERS

Next Steps…. Ÿ Recommended demos/locations – – – OCP Lounge Oracle Test Center DBA Hot Seat Ÿ Visit the DEMOgrounds for a review of available online OCP prep content Ÿ Visit the Self Test Software booth in the exhibition hall

Reminder – please complete the Oracle. World online session survey Thank you.