OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Ex... and over 2 million other books are available for Amazon Kindle . Learn more

Buy New

Sign in to turn on 1-Click ordering.
Buy Used
Used - Like New See details
Price: 16.23

Trade in Yours
For a 4.26 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading OCA Oracle Database 11g SQL Fundamentals I Exam Guide on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

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

John Watson , Roopesh Ramklass
3.6 out of 5 stars  See all reviews (9 customer reviews)
RRP: 39.99
Price: 24.79 & FREE Delivery in the UK. Details
You Save: 15.20 (38%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Tuesday, 15 July? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition 23.55  
Paperback 24.79  
Trade In this Item for up to 4.26
Trade in OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Oracle Press) for an Amazon Gift Card of up to 4.26, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more
There is a newer edition of this item:
OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press) OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press)
In stock.

Book Description

1 July 2008 9780071597869 978-0071597869 Pap/Cdr

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

Special Offers and Product Promotions

  • Spend 30 and get Norton 360 21.0 - 3 Computers, 1 Year 2014 for 24.99. Here's how (terms and conditions apply)

Frequently Bought Together

OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Oracle Press) + OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052): Administration 1 Exam Guide + OCP Oracle Database 11g Administration II Exam Guide: Exam 1Z0-053 (Oracle Press)
Price For All Three: 84.94

Buy the selected items together

Product details

  • Paperback: 581 pages
  • Publisher: McGraw-Hill Osborne; Pap/Cdr edition (1 July 2008)
  • Language: English
  • ISBN-10: 9780071597869
  • ISBN-13: 978-0071597869
  • ASIN: 0071597867
  • Product Dimensions: 3.2 x 18.5 x 23.1 cm
  • Average Customer Review: 3.6 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Bestsellers Rank: 159,373 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

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.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

Most Helpful Customer Reviews
11 of 11 people found the following review helpful
5.0 out of 5 stars Proper exam in a box 30 April 2009
Format:Paperback|Verified Purchase
Just passed the exam and have to say that 10+ years SQL day to day experience does not help at all, unless you read this book properly, as about 60% of exam questions are not real-life and you need to know the theory. This book covers all the questions and helps you with understanding of issues rather than memorising the code which will not help at the exam - you don't even get the time to analyse the questions and scripts properly - just get the keywords and jump to code to find the match.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
3.0 out of 5 stars Good book, however, it's full of errors. 6 Sep 2013
Format:Paperback|Verified Purchase
This book is a must have for anyone wanting to sit the exam. However, there are plenty of errors, grammatical and in some cases code errors. The precision and quality of the book regresses with each chapter.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
4.0 out of 5 stars Useful Preparation 3 Mar 2012
By asl
Format:Paperback|Verified Purchase
Despite having nearly 20 years SQL experience, I bought this book after seeing some 'example questions' on the Internet which, frankly, scared me into believing the exam was going to be far harder than I was anticipating and it would betray my inexperience at later versions of SQL. Working through this book, I thought the example questions were so straightforward I could have managed without it. Buy this book if you're preparing for the OCP exams - better to waste a few quid on it than miss out by a couple of percentage points and have to pay for a re-test.

The book was sold second-hand - but you'd never have known it was anything but brand new. The very useful CD with a very useful dummy practice test on it. had a small scratch on it but it polished out and, after a few retries, worked fine.
Comment | 
Was this review helpful to you?
3.0 out of 5 stars "Least convincing words: Not really" 25 Jun 2014
By bartosz
Format:Paperback|Verified Purchase
Although it introduces you to the paradigm of SQL book doesn't fully cover the exam. The Lab Questions is the minimum that you should know. Some questions on the exam will test your knowledge from at least 5 nested chapters in one question (not to scare you). This is a good book for an introduction . I'm not ashamed to say that I have failed my first exam spending at least 60h on the book but the self tests aren't really challenging(my AVG score was 87% ).
I have passed 051 today but this book was about 70% of a help. Search for other sources as an addition.
Comment | 
Was this review helpful to you?
Format:Paperback|Verified Purchase
I want to like this book because it contains all the information that you need to sit the 1Z0-051 exam laid out in an easily digestible manner; however, the lackluster copy-editing makes this very hard. Simple grammatical and spelling errors reoccur time and time again to the extent that it becomes annoying.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category