Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Compare Oracle (SQL PL/SQL) Certifications

Sven W.Oct 30 2007 — edited Nov 4 2007
I'm in a position where I frequently receive job applications for Oracle SQL and PL/SQL Developer. I would like to compare my impressions for the different certification levels with your experience.

Currently there are 3 certification levels that are relevent for Oracle Developers.

1) Oracle Certified Associate SQL / PL/SQL Developer (OCA)
2) Oracle Certified Professional (OCP) = OCA + Forms/Reports or OCA + DBA know how
3) Oracle Certified SQL Expert (OCE) => This is unknown to me. I also think nobody will apply to me with this certification in the near future.

My impression is:

An OCA at least has some basic understanding for most of the elements in SQL and PL/SQL language. An OCA is able to build basic SELECT statements (GROUP BY, JOIN etc.). Tables, Views, Triggers, Indexes are known objects.

Beyond OCA: More complex issues like: mutating tables, analytic functions, selects with more than 5 tables.

OCP: There is a big difference between a Forms OCP (regardless if it is 6i or 9i) and OCP for DBAs.
But I would expect additional knowlege about performance issues (SQL statement tuning, Indexing your tables, reading an execution plan, etc.). I'm only interested in the development skills for SQL and PL/SQL. Although there is not much more knowledge required for an OCP in this field he should have a much broader overview. However my impression from some past interviews is that the quality of OCP (mainly OCP for DBA) is somehow degraded. It seems to be OCP = OCA for recent qualifications.

OCE: really an expert, I can only guess about the skills.

I know that practical knowledge is more important than a simple certification. But that is even more difficult to compare.

So what is your experience for the different certifications? Do they still guarantee some decent knowledge in the field?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2007
Added on Oct 30 2007
103 comments
4,856 views