OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1z0-047)

Description

A Fully Integrated Study System for OCA Exam 1Z0-047

Prepare for the Oracle Certified Associate SQL Certified Expert exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exam 1Z0-047, including:
* DDL and SQL SELECT statements
* Manipulating, restricting, and sorting data
* Single-row and group functions
* Subqueries
* Schema objects
* Set operators
* Data dictionary views
* Large data sets
* Hierarchical retrieval
* Regular expression support
* User access control
* And more

On the CD-ROM:
* One full practice exam
* Detailed answers and explanations
* Score report performance assessment tool
* Complete electronic book
* Bonus exam available with free online registration

For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

CONTENTS:

Chapter 1. Introduction to SQL;Chapter 2. Using DDL Statements to Create and Manage Tables; Chapter 3. Manipulating Data; Chapter 4. Retrieving Data Using the SQL SELECT Statement; Chapter 5. Restricting and Sorting Data; Chapter 6. Using Single-Row Functions to Customize Output; Chapter 7. Reporting Aggregated Data Using the Group Functions; Chapter 8. Displaying Data from Multiple Tables; Chapter 9. Retrieving Data Using Subqueries; Chapter 10. Creating Other Schema Objects; Chapter 11. Managing Schema Objects; Chapter 12. Using the Set Operators; Chapter 13. Generating Reports by Grouping Related Data; Chapter 14. Managing Objects with Data Dictionary Views; Chapter 15. Manipulating Large Data Sets; Chapter 16. Hierarchical Retrieval; Chapter 17. Regular Expression Support; Chapter 18. Controlling User Access; Appendix A. About the CD; Glossary; Index