OCA Oracle Database SQL Certified Expert Exam Guide: Exam 1Z0-047
by Steve O'Hearn

OCA Oracle Database SQL Certified Expert Exam Guide: Exam 1Z0-047<br>by Steve O'Hearn
Item# 0071614214
List price: $65.00
Softpro Price: $52.00

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

    Table of 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


    Unless otherwise noted above, most orders ship within 1 to 2 days. We will promptly notify you if there is a stock problem with any items on your order and provide you with an estimated delivery date. If you have a firm need by date, please provide such information in the comment section at checkout.

    Publisher: McGraw-Hill/Oracle Press
    Page Count (est.): 753
    ISBN10: 0071614214
    ISBN13: 9780071614214
    Cover: Paperback
    Pub Date: 12/9/2009