Oracle SQL Interactive Workbook (Prentice Hall Ptr Oracle Series) - Softcover

Rischert, Alice

Softcover

ISBN 10: 0131002775 ISBN 13: 9780131002777

Publisher: Prentice Hall, 2002

Synopsis

Appropriate for beginning to intermediate courses in Oracle SQL.

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.

About this title

From the Back Cover:

• 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 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.

About this edition

• Publisher: Prentice Hall
• Publication date: 2002
• ISBN 10: 0131002775
• ISBN 13: 9780131002777
• Binding: Paperback
• Edition number: 2
• Number of pages: 851