Oracle Database 11g PL/SQL Programming

Product Description

A Fully Integrated Study System for OCA Exam 1Z0-051

Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-051, including:

*
SQL SELECT statements
* Restricting and sorting data
* Single-row functions
* Conversion functions and conditional expressions
* Group functions
* Displaying data from multiple tables
* Subqueries
* Set operators
* DML and DDL statements
* Schema objects

On the CD-ROM:

* One full practice exam that simulates the actual OCA exam
* Detailed answers and explanations
* Score report performance assessment tool
* Complete electronic book
* Bonus exam available free with online registration

Product Details

* Amazon Sales Rank: #24242 in Books
* Published on: 2008-05-29
* Original language: English
* Number of items: 1
* Binding: Paperback
* 573 pages

Editorial Reviews

About the Author

John Watson, OCP, is a senior consultant with BLP management Consultants and taught for Oracle University in South Africa for four years. He is the coauthor of Oracle Database 10g OCP Certification All-in-One Exam Guide.

Roopesh Ramklass, OCP, is a technical specialist with 10 years of experience in a wide variety of IT environments.

Customer Reviews

Helpful but not useful1
The book is a good resource to give you a overview of features.However,it does not reflect the actual exam scenarios.Topics that appeared most in the exam are discussed in lighter vein.

I would suggest people to study the SQL programmer guide rather than exam guide.Once you are done with the detailed SQL pragramming, then you can briskly follow this one.

Gave it one star as I found SQL Programmer guide more useful than this one.This one is worth reading but not very helpful to pass the exam

Great Help for the exam5
The book is aimed at novice PL/SQL learners. The book discuss even the simple SQL statement deeply and in a user friendly manner.

Advanced users can brush up their knowledge and identify gaps in their knowledge.

The book uses the HR and OE sample schema in Oracle DB. Only the HR schema comes pre-installed if you use Oracle 10g Express Edition. The OE sample scripts can be installed using The Oracle Companion CD.

Good luck with exams....:-)