File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Product and Other Certifications and the fly likes want  to become oracle certified...... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Certification » Product and Other Certifications
Bookmark "want  to become oracle certified......" Watch "want  to become oracle certified......" New topic

want to become oracle certified......

Alan Hermin
Ranch Hand

Joined: Feb 16, 2006
Posts: 290
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

Joined: Apr 17, 2006
Posts: 23
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]

SCJP 1.4 SCWD 1.4
Alan Hermin
Ranch Hand

Joined: Feb 16, 2006
Posts: 290
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...?

Americo Souza
Ranch Hand

Joined: Nov 22, 2004
Posts: 76

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 ]

AMERICO SOUZA<br />MSCS, BSCS and BSEE <br />ACHIEVEMENTS<br />CompTIA (A+), Cisco (CCNA), Oracle (OCA - PL/SQL), Sun (Java, J2EE and EJB).<br />Currently persuing Oracle's Forms Certification
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: want to become oracle certified......
Similar Threads
what are procedures in sql ?
Oracle Certification
Stroed Procedure&PL/SQL
OCP 9i Developer title is changed.
Multiple repeat insert