aspose file tools*
The moose likes Product and Other Certifications and the fly likes Which Oracle certification to give? 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 "Which Oracle certification to give?" Watch "Which Oracle certification to give?" New topic
Author

Which Oracle certification to give?

Anjali Shah
Ranch Hand

Joined: May 17, 2006
Posts: 41
Hie,

I am a java developer and I am not so good with databases... as in I understand the basic concepts but I have never written stored procedures myself neither have I written any triggers or complex queries.
I want to learn it but I dont want to get totally in depth knowlege of databases as a DBA.. so I thought of giving OCA exam.
Now I cant decide which one to give- 9i or 10g and both of them look very different in their course coverage?
Which one is most suited to my needs...?

please advice..

Thanks
[ June 14, 2006: Message edited by: Anjali Shah ]
Srinivasa Raghavan
Ranch Hand

Joined: Sep 28, 2004
Posts: 1228
Since your are in the initial stage and aiming for a developer track , I feel you can better try Oracle 9i Sql ( 1Z0-007) and the other exam for Pl/Sql ( Not sure about the exam code I think it's 1Z0-147 )
[ June 14, 2006: Message edited by: Srinivasa Raghavan ]

Thanks & regards, Srini
MCP, SCJP-1.4, NCFM (Financial Markets), Oracle 9i - SQL ( 1Z0-007 ), ITIL Certified
Barry Bassi
Ranch Hand

Joined: Dec 20, 2005
Posts: 49
Hi Anjali and Srinivasa.

What about self study materials for 1Z0-007 and 1Z0-147 ? Are there any self-study kit avaiable for these exams?


Thanx.

Regards,
Barry.


SCJP 5.0, SCWCD 1.4, SCBCD 1.3, MySQL 5 Developer, ZCE, EUCIP Core<br /> <br />OCA 9i (in progress..)<br />SCJD UrlyBird (in progress..)
Srinivasa Raghavan
Ranch Hand

Joined: Sep 28, 2004
Posts: 1228
OCP Introduction to Oracle9i: SQL Exam Guide by Jason Couchman is one of the good books for Sql exam.
Murali Mohan Atmakuri
Greenhorn

Joined: Jan 02, 2006
Posts: 20
Hi Anjali,

Thanks for the post! This was exactly what I was looking from a couple of weeks.
My investigation is for Basic Oracle

1z0-007 has basic sql and advanced sql
1z0-001 has basic sql and pl sql

I prefer 1z0-007 to kick off and then write another plsql

Thanks


SCJP, SCWCD, SCBCD,OCP 9i - basics
Murali Mohan Atmakuri
Greenhorn

Joined: Jan 02, 2006
Posts: 20
Hi Srinivasa Raghavan ,

How much time would it take for preparing for 1z0-007.
Please provide us with some material.
Srinivasa Raghavan
Ranch Hand

Joined: Sep 28, 2004
Posts: 1228
Murali,

Preparation time varies for each individual. It depends upon your experiance in oracle, you reading & understanding capability. I feel it shouldn't take more than a month for this exam.
As I said in my previous post OCP Introduction to Oracle9i: SQL Exam Guide by Jason Couchman is one of the good books for Sql exam
Barry Bassi
Ranch Hand

Joined: Dec 20, 2005
Posts: 49
Hi all!

What about Sibex study guides for 1z0-007 preparation?

Thanx.

Regards,
Barry.
Mouly Kumaraswamy
Greenhorn

Joined: Apr 17, 2006
Posts: 23
Hi Barry,

Recently I bought the Sybex study guides for 1Z0-007 (Biju Thomas). Albeit I've read only the first chapter, I think it is sufficient to take a good shot at the exam. I chose this book over the offical study guide because I felt it had better reviews.


SCJP 1.4 SCWD 1.4
ajay pratap
Greenhorn

Joined: Jun 26, 2006
Posts: 7
hi does anyone has soem online study material guide for the oracle 9i exam .if u have please post the link .
thanks
Americo Souza
Ranch Hand

Joined: Nov 22, 2004
Posts: 76
Hi,

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 ]
you can find some old editions of PL-SQL books. They are still valid for certifications purposes.

Good luck in your exam!!
[ 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
Murali Mohan Atmakuri
Greenhorn

Joined: Jan 02, 2006
Posts: 20

Hi Barry,

Recently I bought the Sybex study guides for 1Z0-007 (Biju Thomas). Albeit I've read only the first chapter, I think it is sufficient to take a good shot at the exam. I chose this book over the offical study guide because I felt it had better reviews.



What is Sybex study guide about? How can i get it? Is there an online pdf for the same.
Please give the details

Murali
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Which Oracle certification to give?