• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Devaka Cooray
  • Ron McLeod
  • paul wheaton
Saloon Keepers:
  • Tim Moores
  • Piet Souris
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Frits Walraven
  • Scott Selikoff

Oracle Certification [ OCA]

 
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi All
Im working as a Java/J2ee Developer and I have taken SCJP 1.4
Now im planning to take up Database Certification.
I was thinking about OCA but I dont have much idea about it.
Can anyone help with this.
I want to know far will it be helpful.
Some of my friends have told me to consider IBM DB2 certification.
I want to know which one is better in terms of scope.
Thanks in advance
 
Ranch Hand
Posts: 76
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 link 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!!

[ March 31, 2006: Message edited by: Americo Souza ]
[ August 03, 2007: Message edited by: Ulf Dittmer ]
 
Tarun Rai
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Americo Souza:
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 link 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!!

[ March 31, 2006: Message edited by: Americo Souza ]



Hi Americo

Thanks a lot for your advice.
I also like to know if I can take

1Z0-007 Introduction to Oracle9i: SQL
and
1Z0-031 Oracle9i Database: Fundamentals I

to become an OCA and not PL/SQL exam.

I dont have any prior experience in PL/SQL as such.
[ August 03, 2007: Message edited by: Ulf Dittmer ]
 
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Niranjan,

I think the major difference between 1Z0-007 Introduction to Oracle9i: SQL
and 1Z0-031 Oracle9i Database: Fundamentals I, is that the first can be done from home via network while the other requires a prometric certification center.
 
Americo Souza
Ranch Hand
Posts: 76
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Niranjan,

Unfortunately Oracle change its OCA developer tests a couple of years ago. The "Database Fundamentals" exam is no longer required. You have to take both exams which are focused in programing only: SQL and PL/SQL

Pls check their site at:

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=48#1
[ April 07, 2006: Message edited by: Americo Souza ]
 
You ridiculous clown, did you think you could get away with it? This is my favorite tiny ad!
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic