OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051) (Osborne Oracle Press) | 
 enlarge | Authors: John Watson, Roopesh Ramklass
Publisher: McGraw-Hill Osborne Media
Category: Book
List Price: $59.99
Buy New: $31.16
You Save: $28.83 (48%)
New (35) Used (8) from $31.16
Avg. Customer Rating:  4 reviews
Sales Rank: 17468
Media: Paperback
Edition: 1
Number Of Items: 1
Pages: 573
Shipping Weight (lbs): 2.3
Dimensions (in): 9.1 x 7.4 x 1.3
ISBN: 0071597867
Dewey Decimal Number: 005.7565
EAN: 9780071597869
ASIN: 0071597867
Publication Date: May 29, 2008
Availability: Usually ships in 1-2 business days
Shipping: International shipping available
Condition: Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.
|
| Also Available In:
|
| Similar Items:
|
| 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
|
| Customer Reviews:
 Lots of errors, but otherwise ok January 2, 2009
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.
 Awesome Book December 22, 2008
This book is just awesome. I just went through all the chapters at a glance. Will come with a more detailed review once I am done with my exam.
Regards
Vam
 Helpful but not useful December 10, 2008
1 out of 2 found this review helpful
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
Great Help for the exam November 23, 2008
1 out of 1 found this review helpful
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....:-)
|
|
|
