Oracle Training : Oracle9i Discoverer For Power Users

Oracle9i Discoverer For Power Users

Oracle Training Overview

Experienced Oracle Discoverer users are interested in knowing how the advanced features of the Oracle SQL language can be incorporated into Discoverer queries. Within this course users will learn how to enhance their queries through the use of correlated subqueries, functions, processing of hierarchies and other advanced SQL techniques. When these advanced techniques are combined with the ease-of-use features of Oracle Discoverer then users are fully empowered to extract crucial information from their databases and data warehouses.

This course can only be sold in conjunction with Oracle9i Discoverer For Administrators since it is a prerequisite.

Oracle Training Prerequisites

The course Oracle9i Discoverer For Administrators

Oracle Training Audience

All Oracle professionals including developers, database administrators, designers and analysts.

Suggested Next Courses

The course Oracle 9i Data Warehouse Administration

Oracle Training Course duration

1 Day(s)

Oracle Training Course outline

ADVANCED QUERIES IN DISCOVERER
FAN TRAPS
MULTIPLE PATH QUERIES
RECURSIVE QUERIES
ANALYTIC FUNCTIONS
THE ANALYTIC FUNCTION TEMPLATE
TYPES OF ANALYTIC FUNCTIONS
RANKING, BANDING
EQUI-WIDTH BANDS, EQUI-HEIGHT BANDS
BANDS USING GREATEST, CASE, NTILE
WINDOWING
REPORTING AGGREGATES
LAGGING/LEADING
LAG()
LEAD()
OTHER ANALYTIC FUNCTIONS
CUME_DIST()
PERCENT_RANK()
DENSE_RANK()
RATIO_TO_REPORT()
ROW_NUMBER()
STDDEV_POP()
FIRST_VALUE()
LAST_VALUE()
STATISTICAL FUNCTIONS
REGR_SLOPE()
REGR_INTERCEPT()
ANALYTIC FUNCTIONS AND CONDITIONS
HIERARCHICAL QUERIES (CONNECT BY PRIOR)

USING HIERARCHICAL RELATIONSHIPS
ONE TO MANY (1:N) HIERARCHY
MANY TO MANY (M:N) HIERARCHY
BILL-OF-MATERIALS EXPLOSION
BILL-OF-MATERIALS IMPLOSION
ADVANCED HIERARCHICAL QUERIES

EXPANDING DISPLAYS FOR HIERARCHICAL QUERIES
ONE TO MANY HIERARCHY - ANY LEVEL DISPLAY
MANY TO MANY HIERARCHY - ANY LEVEL DISPLAY
CREATING THE HIERARCHY QUERIES IN DISCOVERER DESKTOP
WRITING AND REGISTERING A PL/SQL FUNCTION

THE NEED FOR PL/SQL FUNCTIONS
WRITING THE FUNCTION
REGISTERING THE FUNCTION
USING THE FUNCTION
ALTERNATE DATE SORTS
CHANGING A DATE FORMAT
DATE LOVS
DEFINING AN ALTERNATE SORT FOR DATES
DISCOVERER DEBUG TRACE
REASONS FOR CREATING A DEBUG TRACE
SETTING UP THE DEBUG TRACE
GENERATING THE DEBUG TRACE
ABOUT THE DEBUG TRACE LOG FILE
USING METALINK