Compare Oracle (SQL PL/SQL) Certifications
Sven W.Oct 30 2007 — edited Nov 4 2007I'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?