Discoverer Plus 10g R2 UK Classes & Lessons (Oracle)

Talk to a Training Advisor

Tel. 0800 652 0202

Availability (sort by: location | date)

Request availability by clicking a date.

26/11/08 Yorkshire (West) (LS1) £ 340

01/12/08 London (Central) (EC1) £ 340

10/12/08 Yorkshire (West) (LS1) £ 340

15/12/08 Edinburgh (EH2) £ 340

Prices exc. VAT. Courses are vendor approved.

Need help? Contact us now.

About this class

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

Who will the lesson benefit?

Data Administrators
Support Technicians
Data Analysis Technicians
Data Retrievers
Report Writers

What prerequisites are required

PC Fundamentals

Contents of this class

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