OCA/OCP: Introduction to Oracle9i SQL Study Guide [Hardcover]

Chip Dawes (Author), Biju Thomas (Author)

Book Description

Publication Date: February 19, 2002 | ISBN-10: 0782140629 | ISBN-13: 978-0782140620

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

Editorial Reviews

From the Back Cover

Here’s the book you need to prepare for Exam 1Z0-007: Introduction toOracle9i:

• In-depth coverage of official examobjectives
• Practical information on using SQL in a real-world Oracle9ienvironment
• Hundreds of challenging review questions, in the book and on theCD

Authoritative coverage of all exam objectives, including:

Writing basic SQL SELECT statements

Restricting and sortingdata

Displaying data from multiple tables

Aggregating data using groupfunctions

Producing readable output with iSQL*Plus

Creating and managing tables

Controlling user access

About the Author

Chip Dawes is an OCP and has worked with Oracle databases since 1990. He is a consultant with D&D Technologies and frequently presents at various Oracle User Group conferences.

Biju Thomas, OCP, has over 7 years of Oracle database management and application development experience. He currently works as a Database Administrator Consultant for Burlington Resources in Fort Worth, TX. Both authors contributed to OCP: Oracle8i DBA SQL Study Guide.

Product Details

• Hardcover: 512 pages
• Publisher: Sybex (February 19, 2002)
• Language: English
• ISBN-10: 0782140629
• ISBN-13: 978-0782140620
• Product Dimensions: 9.3 x 7.7 x 1.5 inches
• Shipping Weight: 2.3 pounds (View shipping rates and policies)
• Average Customer Review: 3.9 out of 5 stars  See all reviews (38 customer reviews)
• Amazon Best Sellers Rank: #578,382 in Books (See Top 100 in Books)
  • #100 in Books > Computers & Technology > Databases > Relational Databases

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

13 of 13 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
(VINE VOICE)    (REAL NAME)   

This review is from: OCA/OCP: Introduction to Oracle9i SQL Study Guide (Hardcover)

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 

Jay (Fairfax, VA USA) - See all my reviews

This review is from: OCA/OCP: Introduction to Oracle9i SQL Study Guide (Hardcover)

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

This review is from: OCA/OCP: Introduction to Oracle9i SQL Study Guide (Hardcover)

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.