Win a copy of Succeeding with AI this week in the Artificial Intelligence and Machine Learning forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
  • Junilu Lacar
  • Tim Cooke
  • Jeanne Boyarsky
  • Knute Snortum
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Piet Souris
  • salvin francis
  • fred rosenberger
  • Frits Walraven

want to become oracle certified......

Ranch Hand
Posts: 290
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 290
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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...?

Ranch Hand
Posts: 76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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 ]
It is an experimental device that will make my mind that most powerful force on earth! More powerful than this tiny ad!
Two software engineers solve most of the world's problems in one K&R sized book
    Bookmark Topic Watch Topic
  • New Topic