Oca/Ocp: Introduction to Oracle9i SQL: Study Guide [With CDROM]

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... This description may be from another edition of this product.

• 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 been brought to the harsh 'reality',started studying the book, religiously answering the questions in the chapter etc.Completed all the chapters, took the bonus exams(from the book) ,again took all the chapter exams ( at the sametime referring to sections where i made a mistake).redid the assesment test as well Best of all, my friend who also passed the exams sent me a question paper ( that be purchased in ebay) based on Jason Couchman's book OCP Introduction to Oracle 9i:SQL Exam guide. Took that exam( about 111 questions)..and everytime went back to the book reading the chapters and sections where i got it wrong So on a net scale, studied the book twice THE EXAM: Appeared the exam yesterday and passed with 85 %..all those which i got wrong were obscure topics (ex :view name that u will use to find constraints in a column, syntax for modifying a constraint etc)There was not a single questions on roles.privileges,grant option,admin option etc. I will also not agree with those who said the book was over emphasising aggregates,group functions etc. there were quite a few questions in the exam and u will use it very often As a matter of fact, the question paper from jason was very very closely aligned with the questions i got in the exam.My objective b4 going over the certification was to learn the basics..and i am not sure if any other book could have done a better job. Examination was secondary for me.. If passing the exam is primary for u..don't miss the simulation exams of Jason Couchman ( of course u need to study )..but if u want to learn every aspect of SQL ( ex :Soundex which even a senior DBA might not use once a year)..go for this.

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 covers a lot of topics - more than 100% of what is needed to pass the exam. Real exam would be a cake-walk. This book is a definite preparatory material.

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 reading through the book. Eqally great about this book is the fact that it can serve as a great reference book (Especially liked the two chapters covering functions). Good value for your money.

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 along with the two bonus tests provided on the CD. I found that the level of questions in the real exam was slightly easier than that of the practice tests on the CD. How do I know? I used just this one book for preparation and scored 54/57 today afternoon. Wish you luck!

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.