OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Osborne ORACLE Press Series) (Paperback)

~ John Watson (Author), Roopesh Ramklass (Author)
Key Phrases: manipulating data, using subqueries, oracle home, Command Prompt, Output Results, All Rows Fetched (more...)

Editorial Reviews

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

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.

Product Details

• Paperback: 581 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (May 29, 2008)
• Language: English
• ISBN-10: 0071597867
• ISBN-13: 978-0071597869
• Product Dimensions: 9.1 x 7.4 x 1.3 inches
• Shipping Weight: 2.2 pounds (View shipping rates and policies)
• Average Customer Review: 3.6 out of 5 stars  See all reviews (9 customer reviews)
• Amazon.com Sales Rank: #71,319 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #1 in	Books > Computers & Internet > Certification Central > Exams > OCA & OCP
  #3 in	Books > Computers & Internet > Certification Central > Oracle
  #5 in	Books > Computers & Internet > Databases > Oracle > SQL

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

3.0 out of 5 stars Lots of errors, but otherwise ok, January 1, 2009

By	spinningplate - See all my reviews

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.

6 of 7 people found the following review helpful:

1.0 out of 5 stars Helpful but not useful, December 10, 2008

By	H. THOTA "Book Worm" (Chicago,IL,USA) - See all my reviews (REAL NAME)

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

2 of 2 people found the following review helpful:

5.0 out of 5 stars Great Help for the exam, November 23, 2008

By	B. M. H. Jayasundara "Hiran - The PoshKiD" (Nawala, Sri Lanka) - See all my reviews (REAL NAME)

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....:-)