This is a fully integrated study system for Oracle Certification exam 1Z0-047. This 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.

• Introduction to SQL
• Using DDL Statements to Create and Manage Tables
• Manipulating Data
• 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
• Retrieving Data Using Subqueries
• Creating Other Schema Objects
• Managing Schema Objects
• Using the Set Operators
• Generating Reports by Grouping Related Data
• Managing Objects with Data Dictionary Views
• Manipulating Large Data Sets
• Hierarchical Retrieval
• Regular Expression Support
• Controlling User Access
• Appendix A. About the CD
• Glossary
• Index