OCA Oracle Database SQL Expert Exam Guide, Exam 1Z0-047 / Edition 1

OCA Oracle Database SQL Expert Exam Guide, Exam 1Z0-047 / Edition 1

by Steve O'Hearn, Gavin Powell
     
 

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

See more details below

Overview

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

Read More

Product Details

ISBN-13:
9780071614214
Publisher:
McGraw-Hill Professional Publishing
Publication date:
12/31/2009
Series:
Oracle Press Series
Pages:
796
Sales rank:
701,972
Product dimensions:
7.30(w) x 9.10(h) x 1.70(d)

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

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >