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

About the Author

ALICE RISCHERT chairs the Database Application Development and Design track at the Computer Technology and Application Program at Columbia University. She has taught Oracle SQL to hundreds of students and has presented at Oracle conferences. Rischert has worked with Oracle for over 10 years and currently consults on large Oracle data warehouse and system integration projects.

Foreword by Peter Koletze

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

Edition details

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