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: #9584 in Books
• Published on: 2008-05-29
• Original language: English
• Number of items: 1
• Binding: Paperback
• 581 pages

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

Lots of errors, but otherwise ok
This book has a lot of errors in, which I would consider to be a problem for anyone actually studying for the exam. I'd also agree that many of the topics tested on the exam are not fully covered here - I have already taken the exam, and several things were questioned that were not mentioned at all in the textbook. In addition, some of the errors were in the test questions and answers in both the book and downloaded material, which is very confusing. Overall I would say this book should only be used as a backup text to something better edited and more comprehensive.

Great Help for the exam
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....:-)

Helpful but not useful
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