Oracle SQL Interactive Workbook

Fully updated and expanded for Oracle 9i, this integrated book-and-Web learning solution is designed to help students master SQL on Oracle Systems as quickly as possible. Its unique workbook-based pedagogy incorporates hands-on, real-world labs, exercises, and projects, as well as an outstanding Web-based training site containing “Test Your Thinking” project solutions and detailed explanations, an Author's Corner that connects students with the book's expert author; additional self-review exercises with instant feedback and explanations; and an exclusive Virtual Study Lounge where students can interact with each other. The book's coverage includes every fundamental SQL concept, skill, and technique, including entity-relationship diagrams, SQL*Plus, SELECT and other statements, Boolean operations, functions, pseudocolumns, joins, complex joins, subqueries, relational operators, DML, DQL, DDL, and the Oracle Data Dictionary.