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:
Avg. Customer Rating: 5.0 / 5.0
Great Help for the exam:
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....:-)
