Average Customer Review:
 ( 38 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
13 of 13 found the following review helpful:
 An elegant entry point into the SQL and Oracle UniverseJan 22, 2005
By T. Chandrasekhar
"gentlemans25"
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.
11 of 11 found the following review helpful:
Good for study AND referenceAug 15, 2002
By Jay
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.
8 of 8 found the following review helpful:
Just what the doctor ordered!Apr 14, 2003
By Ramsundar Lakshminarayanan
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.
8 of 8 found the following review helpful:
Good enough for passing the examApr 09, 2002
How I prepared for the exam:
- I have several years of industry experience using PL/SQL
- I read this book cover to cover and worked through all of the review questions multiple times This was enough for me to feel confident about roughly 65 to 70%of the exam questions (75% passes) and to make solid educated guesses at the rest. I passed on the first try and would recommend this book for beginners and experienced users. While this book does a good job explaining and covering the topics on the exam, I would recommend a beginner to consider supplementing this approach with a difficult practice test. This would help cover some of the trick questions and concepts that might be overlooked with a limited amount of experience.
5 of 5 found the following review helpful:
Would recommend this book for 1z0-007 examApr 04, 2005
By A. L. Govekar
"Amadeus"
I used this book to pass the Introduction to Oracle 9i: Sql 1z0-007 certification test. The fundamentals presented in this book were instrumental in getting me through (49/52).The tests and the flashcards on the cd were very helpful.
Having said that...
1. There are a few errors in the book ...nothing serious but go through the errata on the book site before you start studying.
2. This book should be supplemented by a reference book and/or self test software to better benefit from it.
Overall, I would recommend this book to anyone who wants to pass 1z0-007 and then some.
See all 38 customer reviews on Amazon.com
|
based on 38 reviews
