Course Search:
Request more details:


Print Page

Oracle Discoverer 3.1 End User Edition

Description:
This course introduces participants to the querying and analytical capabilities of Oracle Discoverer.

View other Oracle Courses available
  • Cost: Price on application
  • Duration:
  • This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
Familiarity with Windows applications.
Introduction:
Benefits of Discoverer
Understanding Discoverer
Opening and Using Workbooks:
Opening a workbook
Working with Workbooks:
The workbook window
Seclecting sections in worksheets
Formatting worksheets
Creating Workbooks:
Creating tabular worksheet
Creating crosstab worksheets
Managing Queries, Worksheets and Workbooks:
Copy a query sheet as a table
Copy a worksheet as a crosstab
Monitor query execution
Customising the Display:
Customising item headings
Customising data displays
Conditions and Parameters:
Creating a condition
Parameters in conditions
Multiple Conditions
Queries and Subqueries:
Creating subqueries
Group Sorts and Summaries:
Creating group sorted outputs
Including totals and subtotals
Calculated Items:
Creating calculated items
Drills in Worksheets:
Identify the drill types
Using the find facility as a drill feature
Scheduling and Managing Queries:
Scheduling periodical queries
Analyze Data Graphically:
Graphically analyze table output
Advanced Options:
Support for MS Excel
Other Supported File Formats


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2012
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.