This Study Guide is targeted at IT professionals who are looking to become an Oracle Database Certified SQL Expert. The book provides information covering all of the exam topics for the Oracle Expert exam: "1Z0-047: Oracle Database SQL Expert".
The books in the Oracle Certification Prep series are built in lockstep with the test topics provided by Oracle Education's certification program. Each book is intended to provide the information that will be tested in a clean and concise format. The guides introduce the subject you'll be tested on, follow that with the information you'll need to know for it, and then move on to the next topic. They contain no drills or unrealistic self-tests to bump the page count without adding value. The series is intended to provide a concentrated source of exam information that is compact enough to be read through multiple times.
This series is ideal for experienced Oracle professionals that are familiar with the topic being tested, but want a means to rapidly reinforce their existing skills and bridge any gaps in their knowledge. It is also an excellent option as a second source of information for candidates pursuing certification.
This is the affordable solution with the information you need to complete your self-study for 1Z0-047. The study guides in the Oracle Certification Prep series were developed to provide Oracle certification candidates a means to rapidly polish their skills for the exam. The information presented is clear and to the point.The 1Z0-047 guide covers all of the key exam topics:
- 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