Textbooks Categories

Partner Link

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

OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051) (Osborne Oracle Press)
Author :  John Watson
 Roopesh Ramklass
Publishe :  McGraw-Hill Osborne Media
List Price :  $59.99
Our Price :  $34.73
Used Price :  $29.34
Customer Rating :  
 

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

Awesome Book
Vamsi M. Avala
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
H. THOTA
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
B. M. H. Jayasundara
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....:-)