OCA: Oracle Database 11g Administrator Certified Associate Study Guide: (Exams1Z0-051 and 1Z0-052) [Paperback]

Biju Thomas (Author)

Book Description

Publication Date: April 6, 2009 | ISBN-10: 0470395125 | ISBN-13: 978-0470395127 | Edition: 1

Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification—this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple tables, and exploring the Oracle database architecture. Plus, you’ll learn how to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, and more.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

For Instructors: Teaching supplements are available for this title.

Editorial Reviews

From the Back Cover

Prepare for two OCA certification exams with this one book

Study, practice, and review for OCA certification in Oracle 11g, Oracle's new release of its top-selling database software. Inside this in-depth guide, you'll find full coverage of essential topics for two required OCA certification exams: SQL Fundamentals I (1Z0-051) and Administration I (1Z0-052). Explore topics such as basic SQL SELECT statements, group functions, creating schema objects, restricting and sorting data, and much more with this essential two-in-one guide. Inside, you'll find:

• Full coverage of all exam objectives in a systematic approach, so you can be confident you're getting the instruction you need for the exam

• Practical hands-on exercises to reinforce critical skills

• Real-world scenarios that put what you've learned in the context of actual job roles

• Challenging review questions in each chapter to prepare you for exam day

• Exam Essentials, a key feature in each chapter that identifies critical areas you must become proficient in before taking the exam

• A handy tear card that maps every official exam objective to the corresponding chapter in the book, so you can track your exam prep objective by objective

Look inside for complete coverage of all exam objectives.

Featured on the CD

SYBEX TEST ENGINE:

Test your knowledge with advanced testing software. Includes all chapter review questions and bonus exams.

ELECTRONIC FLASHCARDS:

Reinforce your understanding with flashcards that can run on your PC, Pocket PC, or Palm handheld.

Also on CD, you'll find the entire book in searchable and printable PDF. Study anywhere, any time, and approach the exam with confidence.

About the Author

Biju Thomas, OCA, OCP, is a senior database administrator with more than 15 years of Oracle application development and database management experience. He has coauthored five Oracle certification books published by Sybex and has written articles for multiple Oracle technical publications.

Product Details

• Paperback: 1152 pages
• Publisher: Sybex; 1 edition (April 6, 2009)
• Language: English
• ISBN-10: 0470395125
• ISBN-13: 978-0470395127
• Product Dimensions: 8.5 x 8.1 x 2.2 inches
• Shipping Weight: 2.4 pounds (View shipping rates and policies)
• Average Customer Review: 3.5 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #302,447 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

5 of 6 people found the following review helpful:

5.0 out of 5 stars Best Oracle Book, September 18, 2009

By 

P. Philipose (dallas) - See all my reviews
(REAL NAME)   

This review is from: OCA: Oracle Database 11g Administrator Certified Associate Study Guide: (Exams1Z0-051 and 1Z0-052) (Paperback)

I like this book. Simple and well organized. I have been a DBA for 12 years now.
But forgot many features in newer versions. This has everything with examples.
This book is good for beginners as well as seasoned DBA's
I must read for all DBA's !

paul

9 of 15 people found the following review helpful:

2.0 out of 5 stars Horrible SQL Section - Decent DBA Section, June 5, 2010

By 

Stephen Kirby (Missoula, MT USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: OCA: Oracle Database 11g Administrator Certified Associate Study Guide: (Exams1Z0-051 and 1Z0-052) (Paperback)

I have been a DBA for a 15 years and wanted to take the certification tests to improve marketability. Since I need to take two tests ... why not get a 5 star rated book to learn both tests at once? [It was 5 star when I bought the book ... hence the review ]

Well the biggest reason for giving this a poort review is that the SQL section, the first test to be passed, in covered extremely poorly. Descriptions of the commands are limited and examples are sparse. I went through the book with the idea that this was everything I would need to pass the Oracle SQL exam ... and discovered I was wrong. The material covered here was about 50% of the material needed and the exam questions in this book, vs. the actual test, were no comparison. The real test was significantly harder. Material on the exams was not covered period, and what was covered did not really help me to understand all the 'boundary' cases that the exam focuses on.

The sections covering database architecture are much better. I happen to know this material very well as this is where my day-to-day activities lie. The material was a much better match to the material needed for the test and it was reflected in the fact that nearly 2/3'rd of the book focuses on DBA topics vs. SQL.
Summary ... this is a decent book for studying for the DBA exam, but for the SQL exam it is far from acceptable. A better, though still flawed, SQL book would be: OCA: Oracle Database 11g Administrator Certified Associate Study Guide: (Exams1Z0-051 and 1Z0-052)