Oracle SQL Interactive Workbook (Interactive Workbook (Prentice Hall)) [Paperback]

Alex Morrison (Author), Alice Rischert (Author)

Book Description

Publication Date: May 2, 2000 | ISBN-10: 0130157457 | ISBN-13: 978-0130157454

Before Oracle DBAs and developers can move on to sophisticated application development, they must gain an in-depth understanding of Oracle SQL. Oracle SQL Interactive Workbook is the fastest way to master Oracle SQL. This integrated book-and-Web learning solution teaches all the Oracle SQL skills you need, through hands-on, real-world labs, exercises, projects, and our great Web-based training site! Coverage includes every key Oracle SQL concept, including: entity-relationship diagrams, the SQL*Plus environment, SELECT and other statements, Boolean operations, joins, aggregate and not-aggregate functions; pseudocolumns; complex joins and subqueries; relational operators; date and conversion functions; DML, DDL, and more. A free Web-based training module includes a Virtual Study Lounge where readers can interact with the author; "Test Your Thinking" project solutions and explanations, interactive Q&As, self-review exercises, new projects, book updates, and more!

Editorial Reviews

From the Back Cover

Foreword by Peter Koletzke
Technical Advisor: Douglas Scherer

The Hands-On Oracle SQL Course That's Fast, Easy, & Web-charged!

FREE Access to Interactive Oracle SQL Training Web Site

• Learn to write SQL fluently—now!
• No Oracle SQL experience necessary!
• Covers all key Oracle SQL concepts
• Real-life labs and "Test Your Thinking" Q&As

New to Oracle development? This integrated book-and-Web learning solution will help you master Oracle SQL — fast! Learn every Oracle SQL skill you need, through hands-on, real-world labs, exercises, projects, and our great Web-based training site. Master entity-relationship diagrams, SQL*Plus, SELECT statements, Boolean operations, functions, joins, NULLS, subqueries, relational operators, data and database object manipulation, and the Oracle dictionary.

Totally integrated with a FREE, state-of-the-art Oracle SQL learning Web site!

Every Prentice Hall 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
• Author's Corner: Your personal connection to this book's expert author
• Additional self-review exercises with instant feedback and explanations
• An exclusive Virtual Study Lounge where you can interact with other students!

Dozens of exercises cover the real-world tasks that matter most!

100s of self-review questions and answers make sure you understand!

Master the skills you need! Alex Morrison and Alice Rischert are experienced Oracle SQL instructors and database consultants who have taught hundreds of students how to effectively write Oracle SQL. Benefit from their combined Oracle knowledge of over 20 years. The Prentice-Hall Oracle Interactive Workbook series is an integrated learning system that's proven to work!

About the Author

Alexandrea Morrison and Alice Rischart are faculty members at the Columbia University School of Continuing Education. Series Technical Advisor Douglas Scherer is a certified Oracle database administrator, and President and Founder of Core Paradigm, Inc. He has been an Oracle specialist, database architect, and consultant to a wide range of leading companies, including Deutsche Bank. He is also a member of the faculty at the Columbia University School of Continuing Education.

See all Editorial Reviews

Product Details

• Paperback: 516 pages
• Publisher: Prentice Hall PTR (May 2, 2000)
• Language: English
• ISBN-10: 0130157457
• ISBN-13: 978-0130157454
• Product Dimensions: 9.1 x 6.8 x 1.5 inches
• Shipping Weight: 2.2 pounds
• Average Customer Review: 3.8 out of 5 stars  See all reviews (12 customer reviews)
• Amazon Best Sellers Rank: #2,952,075 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.