Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

OCA 9i resources

 
Mihai Lihatchi
Ranch Hand
Posts: 138
Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 javaranch.com just dedicated to Oracle technology.

Thank you
Mihai
PS : Yes I am also interested in SCEA ... but this requires more preparation time .
[ December 08, 2006: Message edited by: Mihai Lihatchi ]
 
Bernd Hennson
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
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!
 
Nicholas Cheung
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Nick
 
Mihai Lihatchi
Ranch Hand
Posts: 138
Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 98
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The Oracle Developer Certification path is at

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=48#1

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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic