OCA/OCP: Introduction to Oracle9i SQL Study Guide (Hardcover)

~ (Author), (Author) "The Oracle9i database provides many useful and powerful features..." (more)
Key Phrases: column alias names, scalar subquery returns, interval datatypes, Review Questions, Name Null, Exam Essentials (more...)

Editorial Reviews

Product Description

Learn the ins and outs of 9i with the OCA/OCP: Introduction to Oracle9i SQL Study Guide. This release from Sybex will prepare you for Exam 1Z0-007, Introduction to Oracle9i: SQL. You get hundreds of challenging review questions in the book and on the CD and authoritative coverage of all exam objectives.

From the Back Cover

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 en 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

See all Editorial Reviews

Product Details

• Hardcover: 512 pages
• Publisher: Sybex (February 19, 2002)
• Language: English
• ISBN-10: 0782140629
• ISBN-13: 978-0782140620
• Product Dimensions: 9.1 x 7.7 x 1.5 inches
• Shipping Weight: 2.3 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars  See all reviews (37 customer reviews)
• Amazon.com Sales Rank: #441,851 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #2 in	Books > Computers & Internet > Certification Central > Exams > OCA & OCP
  #75 in	Books > Computers & Internet > Databases > Beginning & Introductory

Customer Reviews

Most Helpful Customer Reviews

12 of 12 people found the following review helpful:

5.0 out of 5 stars An elegant entry point into the SQL and Oracle Universe, January 22, 2005

By	T. Chandrasekhar "gentlemans25" (Pembroke pines, Florida United States) - See all my reviews (REAL NAME)

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 people found the following review helpful:

5.0 out of 5 stars Good for study AND reference, August 15, 2002

By	J. Xu (Fairfax, VA USA) - See all my reviews

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 people found the following review helpful:

5.0 out of 5 stars Just what the doctor ordered!, April 14, 2003

By	Ramsundar Lakshminarayanan - See all my reviews

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.