First of all Thanks for all your wishes. Today I am going to answer all your questions on How to become ORACLE DBA.
After completing my internship from Center for Development of Telematics (C-DOT) Govt. of India, I enrolled for the Oracle DBA course. Along with this I have also done certification course in Java programming and C programming. You can have a look of my Resume or connect with me on my LinkedIn.
I opted for classroom program which involves 4 hours classes 5 days a week.
For study material I got Oracle e-books and course presentations.
This module concentrates on fundamentals as well as Advance SQL. In this module you will learn a lot about SQL. You can also check my SQL video tutorial for assistance.This module has 20 chapters which are divided into 2 parts.
After completing Oracle Database 10g: Introduction to SQL as mentioned above, you’ll have 2 weeks of Linux (RHEL) training. When you are done with Oracle Database 10g: Introduction to SQL you can appear for 1st exam. If you successfully complete this exam then you will qualify as Oracle Certified SQL expert.
This is the Second module of Oracle DBA certification and the second phase of How to become oracle DBA.
In this module you will learn several advance Oracle topics such as Installation, Managing oracle instance, Memory management, SQL tuning, a little bit about backups and recovery, Oracle net services, Move data between databases and files.This module has 18 chapters.
After completing Oracle 10g Database Administration Workshop-1 you can appear for your second exam. On successful completion of this exam you will qualify as Oracle certified Associate (OCA).
Last and the toughest Module in Oracle DBA certification this is the third phase of how to become oracle DBA.
This module mainly concentrates on Database recovery and backups.This module has 17 chapters.
After completing Oracle 10g Database Administration Workshop- 2 you can appear for your 3rd exam and on successful completion you will qualify as oracle certified professional
You can take this exam after completing first module Oracle Database 10g: Introduction to SQL. This is an online multiple choice based exam concentrating on SQL/PLSQL knowledge.
This exam is valid for Oracle Database 10g, Oracle Database 11g, Oracle Database 11g Release 2, and Oracle Database 12c.
It is a 2 hour (160 mins.) exam and has 70 multiple choice questions. To pass this exam you have to secure minimum 66% means you have to correctly answer at least 47 questions.
This is an online exam thus you will get your result after 10 minutes of completing this exam. If you successfully complete this exam you will get an Oracle Database SQL Certified Expert certificate both e-certificate and printed certificate which will get delivered at your registered address.You can visit Oracle website for payment and other information
This exam is also known by the name of OCA or Oracle certified associate. This is because on successful completion of this exam you will be an Oracle Database 10g Administrator Certified Associate.
Oracle Database 10g: Administration-1 is a 2 hour (160 mins.) exam with 84 multiple choice questions. To pass this exam you have to secure minimum 68% which means you have to correctly answer at least 58 questions. This is valid against Oracle Database 10g R2.You can visit Oracle website for payment and other information
After successfully completing this exam you will be an Oracle Database 10g Administrator Certified Professional.
Like other two this is also a multiple choice online exam which has 70 questions with duration of 90 minutes. To clear this exam you have to secure at-least 70% which means 49 correct answers.
The exam is valid against Oracle Database 10g and Oracle Database 10g R2. On successful completion of this exam you will get a Oracle Database 10g Administrator Certified Professional printed as well as e-certificate.You can visit Oracle website for payment and other information
So, there you go! Hope these details help you in your endeavor to become an Oracle Certified DBA. I have tried to make the whole process easy to understand and follow. Please Do Share This Blog. Good Luck Folks!
You can DOWNLOAD SQL script and presentation used in the Video and in this article.