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

  • ISBN13:


  • ISBN10:


  • Edition: 1st
  • Format: Package
  • Copyright: 12/23/2009
  • Publisher: McGraw-Hill Education
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $68.00 Save up to $10.20
  • Buy New


Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.


A fully integrated study system for Oracle Certification exam 1Z0-047This exclusive Oracle Press guide covers all of the objectives on the newly created Oracle SQL Expert exam in detail, including control privileges, creating indexes and constraints, altering existing schema objects, creating and querying external tables, and using the advanced SQL features to query and manipulate data within the database.Oracle Database SQL Expert Exam Guide features real-world examples, practice questions, and chapter summaries to help you learn the material. The CD-ROM contains two practice exams and an electronic copy of the book.

Author Biography

April Wells is an Oracle DBA, an Oracle Apps DBA, and the author of several computer books. She has been a presenter at several Oracle User Group conferences.


Table of Contents

Retrieving Data Using the SQL Select Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables
Using Subqueries to Solve Queries
Using the Set Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects
Managing Objects with Data Dictionary Views
Controlling User Access
Managing Schema Objects
Manipulating Large Data Sets
Generating Reports by Grouping Related Data
Managing Data in Different Time Zones
Retrieving Data Using Subqueries
Hierarchical Retrieval
Regular Expression Support
Table of Contents provided by Publisher. All Rights Reserved.

Rewards Program

Write a Review