Loading...

Oracle 10g Discoverer Desktop

Course code: O1035

1 days £395.00
+ VAT

Oracle 10g Discoverer Desktop training 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.

Course content >

Who Should Attend?

  • End Users
  • Sales Consultants
  • Business Intelligence Developer
  • Business Analysts

Prerequisites

  • PC Fundamentals
  • Familiarity with SQL is beneficial

Course Reviews

Course Contents

This Oracle 10g Discoverer Desktop training 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. Oracle Discoverer Desktop Edition makes finding the data easier than it often is with other interfaces.

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.

This course has been specifically designed to provide appropriate training for Oracle Discoverer 10g & Oracle Discoverer 11g audiences alike.

 

Oracle 10g Discoverer Desktop 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

 

Contact us for more information