Oracle SQL Interactive Workbook (2nd Edition) [Paperback]

Alice Rischert (Author)

Book Description

ISBN-10: 0131002775 | ISBN-13: 978-0131002777 | Publication Date: January 3, 2003 | Edition: 2

Oracle SQL Interactive Workbook, Second Edition is the only integrated book-and-Web learning solution that teaches all the Oracle 9i SQL skills you need, hands on, through labs, exercises, and projects-complete with a Web-based training site! Fully updated for Oracle 9i, author Alice Rischert covers all types of joins (including the new ANSI join syntax); SQL functions; subqueries set operators; sequences, views, and indexes; data dictionary; dynamic SQL; security; optimization; the SQL*Plus and iSQL*Plus environments; and much more.

Editorial Reviews

From the Back Cover

• Write efficient Oracle SQL statements—now!
• Fully updated for Oracle 9i (including Release 2)
• No Oracle SQL experience necessary!
• Avoid the common pitfalls
• Dozens of self-review questions and answers make sure you understand!
• 100's of exercises cover the real-world tasks that matter most!

New to Oracle development? This integrated book-and-Web learning solution will help you master Oracle SQL—fast! Fully updated for Oracle 9i, it teaches every Oracle SQL skill you need through hands-on labs, exercises, projects, and our exclusive, FREE Web-based training site. You'll master all types of joins (including the new ANSI join syntax); SQL functions; subqueries; set operators; sequences, views, and indexes; the data dictionary; dynamic SQL; security; optimization; the SQL*Plus and iSQL*Plus environments; and much more.

Every Prentice Hall Oracle Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more:

• "Test Your Thinking" project solutions and detailed explanations
• Additional self-review exercises with instant feedback and explanations
• Gain knowledge that takes years to acquire. This book makes you leap ahead of the pack!
• The essential SQL knowledge and beyond, presented in an easy-to-understand format

About the Author

ALICE RISCHERT chairs the Database Application Development and Design track at the Computer Technology and Application Program at Columbia University. She has taught Oracle SQL to hundreds of students and has presented at Oracle conferences. Rischert has worked with Oracle for over 10 years and currently consults on large Oracle data warehouse and system integration projects.

Foreword by Peter Koletze

See all Editorial Reviews

Product Details

• Paperback: 851 pages
• Publisher: Prentice Hall; 2 edition (January 3, 2003)
• Language: English
• ISBN-10: 0131002775
• ISBN-13: 978-0131002777
• Product Dimensions: 9.3 x 6.9 x 1.8 inches
• Shipping Weight: 3 pounds (View shipping rates and policies)
• Average Customer Review: 3.8 out of 5 stars  See all reviews (11 customer reviews)
• Amazon Best Sellers Rank: #257,461 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

25 of 25 people found the following review helpful:

4.0 out of 5 stars Interactive Workbook - Excellent exercises, June 14, 2000

By 

Marshall Van Beurden - See all my reviews

This review is from: Oracle SQL Interactive Workbook (Interactive Workbook (Prentice Hall)) (Paperback)

The Lab exercises help to build expertise in Oracle SQL, and the examples given are clear, concise and relevant. Most of all, many of the exercises are easily applied in a production environment leading to gains in job productivity almost immediately! This is a great book for the SQL beginner, and it helps to quickly build both the tools and the confidence to be productive in the Oracle database environment. The only thing that keeps me from giving this book a 5 star rating were minor editing mistakes on some of the examples of both the book and the companion web site. Overall Excellent!

MVB

14 of 14 people found the following review helpful:

5.0 out of 5 stars Best Book for Learning Oracle SQL, October 13, 2000

By 

Steven D. Powell - See all my reviews

This review is from: Oracle SQL Interactive Workbook (Interactive Workbook (Prentice Hall)) (Paperback)

If you want to learn Oracle SQL, then go ahead and buy this book. The learning modules are short and bite-sized which facilitates the learning process. The best aspect of this program is the hands-on learning process. When you finish this program you will indeed know Oracle SQL. This is the best book available for learning Oracle SQL.

7 of 7 people found the following review helpful:

5.0 out of 5 stars Book is excellent!, January 24, 2002

By 

A. Gendle "QWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW... (Lancaster, CA United States) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Oracle SQL Interactive Workbook (Interactive Workbook (Prentice Hall)) (Paperback)

I really liked reading and doing the lessons in this book. The hands-on exercises are fantastic. Better yet, there were a few things I didn't understand clearly, and so I e-mailed the author and she answered any questions that I had. There are a few minor glitches in the book, some proof-read errors, which most of them are corrected on their web site which are listed on the errata page. I've already reported a couple errors that I found and they will update their proof-read error page. One annoying thing was having to turn back and forth to the back of the book to see the database schema diagram. The best thing to do is just photo copy the diagram so you don't have to constantly turn to the back of the book while doing the exercises.