Course Contents
This practical course covers Oracle Discoverer Plus and is applicable to all releases but, for the duration of the
course, Discoverer 10g Release 2 will be used.
Oracle Discoverer enables professionals and users without database skills to perform complex queries and in
depth data analysis.
This one-day course provides a comprehensive insight into the Discoverer tool and the techniques required to
use it to access and retrieve data.
Training Course Contents
Introduction
- Introduction to Discoverer
- An introduction to Databases
Getting Started
- Accessing Discoverer
- Workbooks
- Opening Existing Workbooks
- Worksheets
- Workbook Window
- Printing your Worksheets
- Page Set up
- Scheduling Workbooks
- Sharing Workbooks
Formatting Worksheets
- Introduction
- Renaming a Worksheet
- Rearranging Item Columns
- To Move Items in Table
- Worksheets
- Formatting the Item Header
- Formatting the Data
- Stoplight Formatting
- Conditional Formatting
- Creating links
Manipulating Worksheets
- Introduction
- Basic Table Sorting
- Group Sorting
- Sort Table Dialogue
- Copying Items between
- Worksheets
- Exporting Data to Other
- Applications
- Crosstab Reports
- Exporting Crosstabs as Pivot
- tables
Graphs
- Introduction
- Creating a Graph
- Editing the Graph
- Formatting the Graph
- Chart Types
Creating a New Workbook
- Introduction
- Editing a Worksheet
- Duplicating a Worksheet
- Drilling
- Drilling Up and Down
Manipulating Data
- Introduction
- Conditions
- Parameters
- Totals
- Percentages
- Calculations
Advanced Reporting Techniques
- Multiple conditions
- SQL Functions
- Using calculations within
- Conditions and Parameters
Introduction to Discoverer
- Opening reports
- Formatting reports