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 OCA 9i resources 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 "OCA 9i resources " Watch "OCA 9i resources " New topic

OCA 9i resources

Mihai Lihatchi
Ranch Hand

Joined: Oct 28, 2005
Posts: 138

Hello everybody.
Can anybody point me to some books and/or sites for Oracle Certified Associate certification ?
Some good database books references would also be useful.

What I also need is a forum similar to the amazing just dedicated to Oracle technology.

Thank you
PS : Yes I am also interested in SCEA ... but this requires more preparation time .
[ December 08, 2006: Message edited by: Mihai Lihatchi ]

Better, faster, lighter Java ... you mean Ruby right ?
SCEA5,SCBCD1.3,SCWCD5,SCJP1.4 - memories from my youth.
Bernd Hennson

Joined: Jan 30, 2006
Posts: 16
I used the Sybex books, but that was for Oracle Release 9i. Back then it required two tests to pass to become OCA - 1Z0-007 and 1Z0-031 - now it's "just" one test for 10g.
If you're looking for good database books I can personally recommend all books by Thomas Kyte, such as "Effective Oracle by Design" - he'll help you avoid common mistakes on every-day problems like resultset paging and the like. Afaik is this Tom "the Tom" behind asktoms Oracle questions.

However, good luck!

--<br />zoink,<br />Hennson<br /> <br />Certified-Java-Oracle-Moped
Nicholas Cheung
Ranch Hand

Joined: Nov 07, 2003
Posts: 4982
For preparing Oracle DBA exams, it would be better to get the ILT materials, as most questions are set based on these materials.

For practice Oracle usage, Apress's Expert Oracle9i Database Administration and Expert Oracle Database 10g Administration are also good.


SCJP 1.2, OCP 9i DBA, SCWCD 1.3, SCJP 1.4 (SAI), SCJD 1.4, SCWCD 1.4 (Beta), ICED (IBM 287, IBM 484, IBM 486), SCMAD 1.0 (Beta), SCBCD 1.3, ICSD (IBM 288), ICDBA (IBM 700, IBM 701), SCDJWS, ICSD (IBM 348), OCP 10g DBA (Beta), SCJP 5.0 (Beta), SCJA 1.0 (Beta), MCP(70-270), SCBCD 5.0 (Beta), SCJP 6.0, SCEA for JEE5 (in progress)
Chris Hendy
Ranch Hand

Joined: Mar 04, 2006
Posts: 98
For sites:

Oracle in general:

Also check out Tom Kytes meta-blog

For study advice:
[ December 09, 2006: Message edited by: Chris Hendy ]
Mihai Lihatchi
Ranch Hand

Joined: Oct 28, 2005
Posts: 138

Thank you all.
I will bookmark this page.
Yes I am intereseted in the Oracle 9i exam. I want a developer certification not an admin one.

For Bernd : Is Oracle 9i so outdated ?

Mihai .
Chris Hendy
Ranch Hand

Joined: Mar 04, 2006
Posts: 98
The Oracle Developer Certification path is at

SQL and PL/SQL will get you an OCA, to get an OCP you need Oracle Forms.

As (presumably) a Java Developer I would be surprised if you wanted to study Forms - especially since Oracle seems to want to move existing Forms developers to JDeveloper and ADF Faces.

I suggest you browse the site and come back with any questions.

As far as 9i being out of date is concerned, I recall seeing a statistic saying more than 50% of Oracle databases are still 9i, but on the other hand 11g Beta is now available. It doesn't affect your choice of Developer Certification - I don't believe there is a dedicated 10g version.
I agree. Here's the link:
subject: OCA 9i resources
It's not a secret anymore!