Oracle SQL: Interactive Workbook - Softcover

Rischert, Alice; Morrison, Alex

Softcover

ISBN 10: 0131002775 ISBN 13: 9780131002777

Publisher: Pearson P T R, 2003

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.

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 statementsnow!
• 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 SQLfast! 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: Pearson P T R
• Publication date: 2003
• Language: English
• ISBN 10: 0131002775
• ISBN 13: 9780131002777
• Binding: Paperback
• Edition number: 2
• Number of pages: 500