OCA/OCP: Introduction to Oracle9i SQL Study Guide

By Chip Dawes and Biju Thomas

Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i: * In-depth coverage of official exam objectives * Practical information on using SQL in a real-world Oracle9i environment * Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: * Writing basic SQL SELECT statements * Restricting and sorting data * Displaying data from multiple tables * Aggregating data using group functions * Producing readable output with iSQL*Plus * Creating and managing tables * Controlling user access

• Format: Hardcover
• Language: English
• ISBN: 0782140629
• ISBN13: 9780782140620
• Release Date: February 2002
• Publisher: Sybex
• Length: 592 Pages
• Weight: 2.75 lbs.
• Dimensions: 1.5" x 7.7" x 9.3"

Customer Reviews

An elegant entry point into the SQL and Oracle Universe

I am an applications developer (insulated from extensive SQL usage) who use little bit of SQL Ex :select * from contact order by created desc, select * from contact where row_id in (select row_id from another table etc).. Nothing complicated.. I purchased the book (with the thought that my knowledge with SQL is above average)..Did the first assesment test(chapter 1) in the book and failed disastrously. Having...

Just what the doctor ordered!

I recently passed the exam. Scored 54/57. I used this book and the materials that come in the CD (review questions, flash cards and 2 BONUS exams). Plus my several years of experience in Oracle also helped a lot. In my opinion, this is the only book needed to get through the exam. Although, bit of practical experience is needed to come out in flying colors. There are few mistakes, but they are easier to identify. The book...

Good for study AND reference

I bought about a dozen certification books before obtaining the MCSE DBA title and had never bothered to write a comment. But the authors of this book have done such a good job that I feel compelled to share my opinion with all of you. It's by far the best study guide I've used. It covers every aspects of the subject. The questions in the book are decent and well constructed. I'm new to Oracle but passed the test easily after...

Covers the exam 100%

I have more than 6 years of experience working with PL/SQL, but let me tell you one thing - don't attempt the 1Z0-007 exam without reading a exam guide. The fine points tested in the exam are not what every day PL/SQL programming is about. This book does an excellent job of covering all the exam objectives and just reading it cover to cover will give you adequate preparation for the test. I did all the practice questions twice...

OCA/OCP: Introduction to Oracle9i SQL Study Guide

A very good book for getting upto speed with the Oracle 9i SQL enhancements. Good for both the test and as an Oracle 9i SQL reference. I took the exam and passed easily.