• Post Reply Bookmark Topic Watch Topic
  • New Topic

Oracle Certification?  RSS feed

hasan khan
Ranch Hand
Posts: 223
Eclipse IDE Firefox Browser Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i am preparing for Oracle PL/SQL Developer Certified Associate. It includes 2 papers (http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=48#1)

a) 1Z0-007 Introduction to Oracle9i: SQL� (http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_org_id=1001&lang=US&p_exam_id=1Z0_007)
b) 1Z0-147 Program with PL/SQL (http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_org_id=1001&lang=US&p_exam_id=1Z0_147)

please suggest me some good books
Chris Hendy
Ranch Hand
Posts: 98
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!