ODB Press

Certification resources for Oracle database professionals

The Oracle Certification Prep study guide series is designed to provide an inexpensive source of preparation material for Oracle exams. The author has over twenty Oracle credentials, with the earliest dating back to the start of the program. In these guides, he has worked to provide the information that certification seekers are most likely to be tested on during the exam in a clean and concise format.

Each guide is organized into chapters that explicitly follow the topics laid out by Oracle Education on the exam details page of their website. Each chapter introduces the subject being tested and provides information at a moderate level of detail before moving on the the next subject. The books contain no drills, self tests or 'review sections' that repeat the same information provided in the chapter you just read. Effectively every page except the table of contents covers information being tested on the exam.

The books provide a concentrated source of exam information that is compact enough to be read through multiple times. They are ideal for experienced Oracle professionals who are familiar with the topics being tested, but want a means to quickly reinforce their existing skills and bridge any gaps in their knowledge. The guides are also an excellent option as a second source of information for certification candidates.

DBA Upgrade Exams

Study Guide for 1Z0-034: Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP

Study Guide for 1Z0-050: Oracle Database 11g: New Features for Administrator

Study Guide for 1Z0-055: Oracle Database 11g: New Features for 9i OCPs

The Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP exam allows Oracle Certified Associates who hold certifications in releases 9i or 10g to upgrade directly to become an Oracle Database 11g Administrator Certified Professional. This is a relatively large and difficult upgrade exam.
The Oracle Database 11g: New Features for Administrators exam allows Oracle Certified Professionals who are certified in release 10g to upgrade to 11g. This is a very straightforward upgrade exam and includes only features added during the 11g release.
The Oracle Database 11g: New Features for 9i OCPs exam allows Oracle Certified Professionals who are certified in release 9i to upgrade directly to 11g, bypassing Oracle 10g. This exam includes questions about features that were added to the Oracle database in both 10g and 11g.

Study Guide for 1Z0-060: Upgrade to Oracle Database 12c

Study Guide for 1Z0-067: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

The Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP exam allows Oracle Certified Associates who hold certifications in releases 9i, 10g, or 11g to upgrade directly to become an Oracle Database 12c Administrator Certified Professional. This is the largest and most difficult DBA upgrade exam currently offered by Oracle.
The Upgrade to Oracle Database 12c exam allows Oracle Certified Professionals who are certified in any earlier release, including 7.3, 8, 8i, 9i, 10g, or 11g to upgrade directly to 12c. This exam is more comprehensive than earlier DBA upgrade exams and includes a section on Key DBA skills.

Database Administration Exams

Study Guide for 1Z0-052: Oracle Database 11g: Administration I

Study Guide for 1Z0-053: Oracle Database 11g: Administration II

Study Guide for 1Z0-062: Oracle Database 12c: Installation and Administration

The Oracle Database 11g: Administration I is the first of two admin exams in the Oracle 11g database adminitrator track. It covers much of the fundamental knowledge that Oracle database administrators should be aware of, including the architecture and functioning of the database and the basics of recovery.
The Oracle Database 11g: Administration II is the second admin exam in the Oracle 11g database adminitrator track. It focuses heavily on topics involving data protection and recovery. Preventing data loss is the primary responsibility of senior DBAs. It also covers topics involving performance and resource management.
The Oracle Database 12c: Installation and Administration is the first of two admin exams in the Oracle 12c database adminitrator track. It covers much of the fundamental knowledge that Oracle database administrators should be aware of, including the architecture and functioning of the database, the basics of recovery as well as database performance and resource management.

Study Guide for 1Z0-497: Oracle Database 12c Essentials

Study Guide for 1Z0-063: Oracle Database 12c: Advanced Administration

The Oracle Database 12c Essentials exam is intended to give certification candidates a reasonable background in the architecture and functionality of the Oracle database. Targeted primarily at employees of Oracle Partner Network companies, it provides information more applicable to technical salespeople and integrators than administrators.
The Oracle Database 12c: Advanced Administration is the second admin exam in the Oracle 12c database adminitrator track. About half of the test focuses on topics involving data protection and recovery. The remaining topics are about the Multitenant Architecture introduced in Oracle 12c.

Development Exams

Study Guide for 1Z0-006: Oracle Database Foundations

Study Guide for 1Z0-047: Oracle Database SQL Expert

Study Guide for 1Z0-051: Oracle Database 11g: SQL Fundamentals I

The Oracle Database Foundations exam is a novice-level exam for candidates who are students at secondary schools, 2-year colleges and 4-year colleges and universities. It is currently restricted to students who have attended an Oracle Academy course that the exam was based on.
The Oracle Database SQL Expert covers a significant number of advanced SQL topics. The knowledge required to pass this exam goes well beyond the basic SQL capabilities covered in the SQL Fundamentals exams. Many of the functions and features covered by the exam are used only occasionally even by advanced SQL developers.
The Oracle 11g SQL Fundamentals exam covers the basics of SQL queries, Data Manipulation Language and Data Definition language. The topics covered by this exam encspsulate the vast majority of the SQL functionalty that is used on a daily basis by developers and administrators.

Study Guide for 1Z0-061: Oracle Database 12c: SQL Fundamentals

Study Guide for 1Z0-144: Oracle Database 11g: Program with PL/SQL

Study Guide for 1Z0-146: Oracle Database 11g: Advanced PL/SQL

The Oracle 12c SQL Fundamentals exam covers the basics of SQL queries, Data Manipulation Language and Data Definition language. The topics covered by this exam encspsulate the vast majority of the SQL functionalty that is used on a daily basis by developers and administrators.
The Oracle Database 11g: Program with PL/SQL covers the fundamentals of developing code using the Oracle PL/SQL language. It covers the vast majority of knowledge that candidates must know in order to be effective developers.
The Oracle Database 11g: Advanced PL/SQL exam covers a number of topic area that will allow PL/SQL developers to write code that performs faster and with greater security.