Booknews
Gives background in Oracle's implementation of the SQL language. Each chapter is divided into labs, with objectives, examples, and exercises on specific tasks and questions that are designed to help readers discover important aspects of the SQL language. Exercises build knowledge step by step by introducing relational database concepts, the SQL*Plus environment, and the SQL language. Labs also include explained answers, multiple-choice review questions, and critical thinking questions. Morrison works in Internet development. Rischert is co-chair of Columbia University's Database Application Development and Design track at the Computer Technology and Application Program. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Oracle SQL Interactive Workbook
by Alex Morrison, Alice RischertView All Available Formats & Editions
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
Overview
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 Risexperienced 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!
Editorial Reviews
Product Details
- ISBN-13:
- 9780130157454
- Publisher:
- Pearson Education
- Publication date:
- 05/02/2000
- Series:
- Prentice Hall Oracle Series
- Edition description:
- Older Edition
- Pages:
- 400
- Product dimensions:
- 6.88(w) x 9.08(h) x 1.50(d)
Read an Excerpt
PREFACE:
Preface
Who This Book Is For
The SQL language is the de facto standard language for relational databases. Oracle's database server is the leading relational database on the market today. This book is intended for anyone requiring a background in Oracle's implementation of the SQL language.
The book's exercises build knowledge step by step by introducing you to relational database concepts, the SQL*Plus environment, and the SQL language. Learning involves not just reading about a subject, but also doing it. The book's focus is to give the reader examples of how the SQL language is commonly used, with many exercises reinforcing the learning experience.
Unlike other SQL books, this book is not a reference book. Rather, its emphasis is on the exercises and the learning-by-doing experience. The best way to learn the SQL language is to perform the exercises and compare your answers with the sample answers and accompanying explanations.
How This Book Is Organized
Each chapter of the book is divided into labs covering a particular topic. The objective of each lab is defined at its beginning, with brief examples that introduce the reader to the covered concepts.
Following the lab's introductory examples are exercises that are the heart of the lab which reinforce and expand the reader's knowledge of the subject.
Each exercise consists of a series of steps to follow to perform specific tasks, or particular questions that are designed to help you discover the important aspects of the SQL language. The answers to these questions are given at the end of the exercises, along with more in-depth discussion of the conceptsexplored.
After you perform the exercises and compare the answers with the sample queries, answers, and explanations, the lab ends with multiple-choice Self-Review questions. These are meant to test that you have understood the material covered in the lab. The answers to these questions appear in Appendix A. There are additional Self-Review questions at this book's companion Web site, found at ...
Customer Reviews
Average Review: