File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes Oracle Certification? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Oracle Certification?" Watch "Oracle Certification?" New topic

Oracle Certification?

hasan khan
Ranch Hand

Joined: Aug 04, 2003
Posts: 222

i am preparing for Oracle PL/SQL Developer Certified Associate. It includes 2 papers (

a) 1Z0-007 Introduction to Oracle9i: SQL� (
b) 1Z0-147 Program with PL/SQL (

please suggest me some good books

Chris Hendy
Ranch Hand

Joined: Mar 04, 2006
Posts: 98
For starters you can download the free documentation from

To understand how the DB works I suggest


(strictly speaking you won't need this for the exam - but for true mastery of Oracle this should be your starting point).

In addition to cover the actual exam topics you will want:

SQL Reference

PL/SQL User's Guide and Reference

Check the syllabus, you may also want the

Supplied PL/SQL Packages and Types Reference

To learn how to use the features I suggest

Application Developer's Guide - Fundamentals

If you prefer paper based books I suggest you buy Steve Feuerstein's

Oracle PL/SQL Programming

The 3rd edition (ISBN: 0596003811) covers up to Database 9ir2, the 4th edition (ISBN: 0596009771) covers 10gr2.

For SQL I used various editions of Oracle: The Complete Reference

I can't speak from personal experience but for a tutorial approach you may prefer

Mastering Oracle SQL and SQL*Plus
Lex de Haan
ISBN: 1590594487

The Amazon reviews look reasonable.
I agree. Here's the link:
subject: Oracle Certification?
It's not a secret anymore!