O1035 - Oracle 10g Discoverer Desktop

Availability

DateDurationPriceLocationEnrolment
08/27/1210ReadingPlease phone 01275 859666

Training Course Objectives

This practical course covers the Oracle 10g Discoverer Desktop Edition. It 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 Discover tool and the techniques required to use it to access and retrieve data at the workgroup.

Training Course Contents

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

Formatting Worksheets

  • Introduction
  • Multiple Item Selection
  • Renaming a Worksheet
  • Resizing & Rearranging Item Columns
  • To Move Items in Table Worksheets
  • Editing Item Headings
  • Formatting the Item Header
  • Formatting the Data
  • Creating and formatting the Title

Manipulating Worksheets

  • Introduction
  • Basic Table Sorting
  • Group Sorting
  • Sort Table Dialogue
  • Copying Items between Worksheets
  • Exporting Data to Other Applications

Drilling

  • Introduction
  • Drilling Up and Down
  • Drilling To a Related Item
  • Drill to Detail in another Worksheet
  • Drilling Out
  • Additional Drill Options

Graphs

  • Introduction
  • Creating a Graph
  • Editing the Graph
  • Formatting the Graph
  • Chart Types

Creating a New Workbook

  • Introduction
  • Editing a Worksheet
  • Duplicating a Worksheet

Manipulating Data

  • Introduction
  • Format Exceptions
  • Conditions
  • Parameters
  • Totals
  • Percentages
  • Calculation

Who Should Attend

Pre Requisites