OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Oracle Press) [Paperback]

John Watson (Author), Roopesh Ramklass (Author)

Book Description

ISBN-10: 0071597867 | ISBN-13: 978-0071597869 | Publication Date: May 29, 2008 | Edition: 1

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

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.

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.2 x 7.4 x 1.3 inches
• Shipping Weight: 2.2 pounds (View shipping rates and policies)
• Average Customer Review: 3.5 out of 5 stars  See all reviews (25 customer reviews)
• Amazon Best Sellers Rank: #106,250 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

18 of 19 people found the following review helpful:

4.0 out of 5 stars Great Studyguide for the Exam, and good overall SQL reverence, April 26, 2010

By 

J. Pelaez "Tony" (North Hills, CA United States) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: OCA Oracle Database SQL Expert Exam Guide: Exam 1Z0-047 (Oracle Press) (Paperback)

The Oracle SQL Certified Expert exam covers several topics that are not covered in books that are geared towards the SQL Fundamentals exam. It is for that reason that I purchased this book to use as a study guide for the Oracle SQL Certified Expert exam. I recently passed the exam and give full credit to the time I spent going through this book and taking the practice tests.

The books assumes a little knowledge of SQL but I think it is a great guide for both beginners, and experts alike. It is well organized and has a great index. You can read it from beginning to end and it makes logical sense, or you can simply use it as a reference to look up the portions you are interested in. Because the book is geared towards passing the exam and not simply to provide more general SQL knowledge, you won't find any examples that you work on, alongside the book, as you read. Some people might find it hard to learn that way, but for me it was great. I didn't need to have a computer in front of me to try out the code to understand what it meant. This also allowed the book to focus on some of the more subtle and conceptual aspects of the SQL language and how Oracle has implemented it. I think that is key to having passed the exam. Because the book teaches the concepts behind the SQL language, instead of just giving syntax examples, it helps you correctly answer questions that might not directly relate to examples given in the book. For example, the book has a great section on the meaning of "NULL" which is used in a lot of "trick" questions. It might not give you all possible examples of where "NULL" can be used in a question, but it does give you a good understanding of what "NULL" means in the SQL context and therefore how to answer questions that could be affected by "NULL" in their code.

My biggest gripe with the book is the fact that it only came with 70 test questions on the CD, and that the CD is Windows only. 70 questions is the equivalent to 1 practice exam. You can download an additional 70 questions from the web after registering with the publisher, but even doing that only gives you 2 practice exams worth of material. It doesn't take long to memorize all the correct answers for 140 questions. I would have preferred the book if it came with at least twice as many questions. I also think its kind of ridiculous that the CD itself is not cross platform. Such practice exams could have been developed in a way which would have allowed me to run it under Mac OS X or Linux. Instead I had to run Windows under virtualization just to take the practice exam.

12 of 12 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 review is from: OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Oracle Press) (Paperback)

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.

13 of 14 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)   

This review is from: OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Oracle Press) (Paperback)

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