want to become oracle certified......

[Alan Hermin]

hi all......
--i an j2ee developer , i know somw sql and pl/sql, i want to take certificate on oracle just SQL and PL/SQL..i do not know what is this certificate name.......?
--what is the good book ?
--another thing, what is the order of oracle certificates?

[Mouly Kumaraswamy]

1. Exam 1Z0-007 - Introduction to Oracle9i: SQL
2. Exam 1Z0-001 - Introduction to Oracle: SQL� and PL/SQL�
3. Exam 1Z0-147 - Program with PL/SQL

To become a OCA you have to give Exam 3 and [Exam 1 or Exam 2]

[Alan Hermin]

thnk u ...
can u give me alink to these exams at Oracle Site(if available)....?
and can u give me a good resource (book) to read...?


bye

[Americo Souza]

Hi,

Oracle basically has two developer certifications paths:
PL-SQL - It a certification language test, like SCJP
Forms - Its is a proprietary web based GUI used by Oracle only.

The "Oracle PL/SQL Developer Certified Associate" (OCA) certification requiresd the following exams:

1Z0-001 Introduction to Oracle: SQL and PL/SQL.
1Z0-147 Program with PL/SQL

I used the following books:
- Oracle 8i Certified Professional - SQL & PL/SQL Exam Guide (Exam 1Z0-001)
Jason S. Couchman - ISBN 0-07-219153-8
- Very good book. Covers all the exam subjects

- Oracle Developer PL/SQL Program units exam guide (Exam 1Z0-101)
Steve O' Hearn - ISBN 0-07-219336-0
- Very good book as well. Unfortunately it covers only 80% of the exam. Some topics for 1Z0-147 are not covered. You have to search for additional sources.

I personally recommend, Feurstein books. They are the bible for any PL-SQL developer.

At [ UD: removed links to copyrighted material ]
there were some old editions of PL-SQL books but still valid for certification purposes. Uunfortunately the page was deleted. I guess if you search in then net probably you will find them again.
[ August 03, 2007: Message edited by: Ulf Dittmer ]