Obtainig Your Oracle 11g Database Certified Associate credential

November 6, 2009 at 1:20 pm | Posted in Certification Paths, Oracle | Leave a comment
Tags: ,

In a world where everybody claims to have the skill sets for a particular job, how do you distinguish yourself? By getting yourself certified. Oracle has rolled out the Oracle 11g Database Certified Associate credential.  You can get this certification by passing two exams. The first exam can be any one of the following three:

  • Introduction to Oracle9i SQL (1z0-007) This test has 52 questions and a duration of 120 minutes. You need to get at least 71% of the questions correct to achieve a passing score. The exam price for this test is $95 instead of the normal $125. You can take this exam online instead of traveling to a testing center to take the test. However, this test covers the older Oracle9i version. This test will expire before other tests that you take to achieve any certification. In my opinion, you should test on the latest version.
  • Oracle Database SQL Expert (1z0-047). This test has 70 questions and a duration of 120 minutes. You need to get at least 66% of the questions correct to achieve a passing score. This test costs $125 and you must take this test at a Pearson Vue testing center.
  • Oracle Database 11g: SQL Fundamentals I (1z0-051) This test has 70 questions and a duration of 120 minutes. You need to get at least 60% of the questions correct to achieve a passing score. The cost of this test is $95 instead of $125. You can take this exam online instead of traveling to a testing center to take the test. I would suggest taking this test because it covers the latest version, Oracle Database 11g. The test can be taken at your convenience since you can take the test online. You do not have to take time off from work to travel to a test center. You can also save some money because the test is $95 instead of $125.

The second exam needed for certification is the Oracle Database 11g: Administration I (1z0-052). This test has 70 questions and has a duration of 120 minutes. You need to get at least 66% of the questions correct to achieve a passing score. The test costs $125 and you must take the test at a Pearson Vue testing center.

None of the above tests are easy. The best way to pass any of the above exams is to know what is on the exam. You can go to the Oracle Web site to find recommended training and prep materials and exam topics. You should go through each of the Exam Topics for each exam. Once you have mastered each exam topic, you should take a practice exam to find where you are deficient. I highly recommend Transcender’s Oracle certification practice tests.

You can also move up to the Oracle 11g Database Administrator Certified Professional once you have achieved your Associate credential. You must take an instructor-led Oracle approved training course either online or at a training center.  You can take any of the following classes to qualify:

  • Oracle Database 11g: Introduction to SQL
  • Oracle Database 11g: Introduction to SQL Ed 1 LVC
  • Oracle Database 11g: SQL Fundamentals I
  • Oracle Database 11g: SQL Fundamentals l Ed 1 LVC
  • Oracle Database 11g: SQL and PL/SQL Fundamentals
  • Oracle Database 11g: SQL and PL/SQL Fundamentals Ed 1 LVC
  • Oracle Database 11g: Develop PL/SQL Program Units
  • Oracle Database 11g: Administration Workshop I
  • Oracle Database 11g: Administration Workshop I Ed 1.1 LVC
  • Oracle Database 11g: Administration Workshop II
  • Oracle Database 11g: Data Warehousing Fundamentals

Then you must pass the Oracle 11g Database: Administration II Exam (1a0-053).

If you are one of those over-achievers, you can strive for the Oracle 11g Database Administrator Certified Master credential. This is not for the weak. You have to complete a two advanced  hands-on classes from the following list:

  • Oracle Database 11g: Performance Tuning
  • Oracle Database 11g: RAC Administration
  • Oracle Database 11g: Data Guard Administration
  • Oracle Database 11g: Implement Streams
  • Oracle Database 11g: Security
  • Oracle Database 11g: Administer a Data Warehouse
  • Oracle Database 11g: OLAP Essentials
  • Oracle Database 11g: SQL Tuning Workshop
  • Oracle Database 11g: Program with PL/SQL
  • Oracle Database 11g: Program with PL/SQL Ed 1 LVC
  • Oracle Database 11g: Advanced PL/SQL
  • Oracle Spatial 11g: Essentials
  • Oracle Database 11g: New Features for Administrators
  • Oracle Database 11g: New Features for 9i DBAs

These classes can be taken online or at a training center.   You must also pass a grueling examination that takes two days. Two days, I tells ya!  This examination is not offered through Pearson Vue but at Oracle’s testing center in Chicago. Oh yeah, the cost of this exam is $2000. Hotel, airfare and the cost of psychological care that you may need after taking the test is not included.

Happy certifying,

–George Monsalvatge

Leave a Comment »

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.
Entries and comments feeds.

%d bloggers like this: