Book description
Whether you're studying for the Oracle 9i SQL exam or just need to take the New Features update exam, Oracle 9i: SQL Exam Cram 2 can help you get certified. This efficient study guide follows the exam objectives clearly and concisely. New Features materials are also included in the book, as well as a full-customizable practice test engine on CD. Oracle 9i: SQL Exam Cram 2 is your smartest way to get certified.
Table of contents
- Copyright
- Oracle 9i Cram Sheet
- A Note from Series Editor Ed Tittel
- About the Author
- We Want to Hear from You!
- Introduction
- Self-Assessment
- 1. Getting Started with Oracle Database
- 2. Retrieving Data (SELECT)
- 3. Filtering (WHERE) and Sorting Data (ORDER BY)
- 4. Operators, Conditions, Pseudocolumns, and Expressions
- 5. Single Row Functions
- 6. Joining Tables
- 7. Groups and Summaries (GROUP BY)
- 8. Subqueries and Other Specialized Queries
- 9. SQL*Plus Formatting
- 10. Changing Data (DML)
- 11. Tables, Datatypes, and Constraints (DDL)
- 12. Views, Indexes, Sequences, and Synonyms (DDL)
- 13. Security (DDL)
- 14. Practice Test #1 (60 questions)
- 15. Answer Key to Practice Test #1
- 16. Practice Test #2
- 17. Answer Key to Practice Test #2
- A. CD Contents and Installation Instructions
- B. Need to Know More?
- Glossary
Product information
- Title: Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007)
- Author(s):
- Release date: September 2004
- Publisher(s): Pearson IT Certification
- ISBN: 9780789732484
You might also like
book
Oracle Database 10g The Complete Reference
Get a thorough understanding of Oracle Database 10 g from the most comprehensive Oracle database reference …
book
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition
The second edition of O'Reilly's bestselling Oracle Essentials has been updated to include the latest Oracle …
book
Oracle Database 10g DBA Handbook
Everything a DBA needs to know in one volume--this is the must-have reference for anyone working …
book
Achieving Extreme Performance with Oracle Exadata
Maximize Oracle Exadata Capabilities Leverage all of the powerful features available in the Oracle Exadata Database …