Ships from: acton, MA
Usually ships in 1-2 business days
The Hands-On Oracle SQL Course That's Fast, Easy, & Web-charged!
FREE Access to Interactive Oracle SQL Training Web Site
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:
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!
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.
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 ...
(NOTE: All chapters conclude with Test Your Thinking.)
1. SQL and Data.
Overview
Technical Advisor: Douglas Scherer
The Hands-On Oracle SQL Course That's Fast, Easy, & Web-charged!
FREE Access to Interactive Oracle ...