OCE Oracle Database SQL Certified Expert Exam

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.

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.

.

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.

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 Used, Rental and eBook copies of this book are 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.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

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

Summary

Author Biography

Table of Contents

Supplemental Materials