Overview
- 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
Synopsis
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.