Search
 Databases

Tuning

Database Management Systems

SQL

PL & SQL

General

Data Warehousing

DBA

 
 
 
 
 
 
 
 
 
 
 
Home

Databases

SQL

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

OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Osborne ORACLE Press Series)
Email a friendEmailView larger imageZoom

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

 
SKU:  

In Stock
Availability:   Usually ships in 1 business days
 
 

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

 
List Price: $59.99
Our Price: $37.79 & this item ships for FREE with Super Saver Shipping.
You Save: $22.20 (37%)
 
 

Note: Item may be sold and shipped by another company. Learn more.


Product Details
Author:John Watson
Paperback:581 pages
Publisher:McGraw-Hill Osborne Media
Publication Date:May 29, 2008
Language:English
ISBN:0071597867
Package Length:9.1 inches
Package Width:7.4 inches
Package Height:1.3 inches
Package Weight:2.25 pounds
Average Customer Rating: based on 11 reviews

Customer Reviews
Average Customer Review:3.5
Write an online review and share your thoughts with other customers.

1 of 1 found the following review helpful:

3Fair Study Guide for Exam, Lacking Depth  Jun 04, 2010
I purchased this book in preparation for the Oracle Database 11g SQL Fundamentals 1 Exam. While the breadth of the material is good as it covers every topic on the exam, the presented examples are extremely simplified and often present a concept in its most basic form. In addition, the exercise questions at the end of each chapter are much too simplified. I downloaded a practice exam from Transcender and was amazed at the difference in complexity between the questions and exams provided by the book and those from Transcender. If you are taking the exam, the questions in the book as well as the exams will not fully prepare you for the exam. I highly recommend purchasing additional practice exams from Transcender; they have the look and feel of actual Oracle exam questions. I did find the study text in this book extremely useful and would recommend it in conjunction with some other study aid.

5 of 5 found the following review helpful:

1Riddled with errors, sample questions too simple  Mar 22, 2010
This book is almost useless. Namely, it is riddled with errors, doesn't cover all the exam topics, examples are way to easy in comparison with the actual test and the 2 sample tests are easy too.
I just took the online exam and passed. However:
- most of the questions were about complex SQL statements, mostly joins and subqueries
- the online test has a serious problem: namely, the question and the proposed answers are displayed in one tab
and the table structures and tabel data are displayed in a second tab. Now the catch: the tabs can't be viewed simultaneously. This is a major problem since you have to switch back and forth between the tabs and you forget either the exhibit or the question and the given answers.

I easily scored over 95% on the practice tests (from this book and other sample tests) and barely got 75% on the real test. On a final note, I do have several years of hands-on SQL experience.

1 of 2 found the following review helpful:

3This is nice book  Feb 10, 2010
This is nice book . I was looking for a book that specifically contained info on SQL*Plus syntax and a bit of SQL.
The books does cover some SQL and it does cover SQL*Plus, but it never goes into any real depth on either topics. I love real world examples that I can actually refer back to and use on the job.

0 of 1 found the following review helpful:

5Excellent  Jan 31, 2010
This is an excellent book for passing 1Z0-051 exam. It covers all topics with good explanations and exercises to practice your understanding. It is also a good SQL reference.

0 of 1 found the following review helpful:

4The book was great  Dec 17, 2009
The pdf files and test exams did line up with the chapters in the book. Both were excellent, but you could not use one to reference the other.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 About UsContact Us
 
Web business powered by Amazon WebStore