permaculture playing cards
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
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
I agree. Here's the link:
subject: want to become oracle certified......
It's not a secret anymore!