back to Course Categories | back | print
Oracle Discoverer for End Users          

Duration: 2 days

Description 
This course introduces students to the querying and analytical capabilities of Oracle Discoverer. Students will learn to create, modify, run, and refine ad hoc queries. They will learn to view, chart, and analyze multidimensional data. They will also learn to produce individual ad hoc reports.

Topics

  • What is Discoverer?
  • Discoverer Concepts and Components
  • Benefits of Using Discoverer
  • Discoverer Terminology
  • Working with Discoverer
  • Workbook and Report Creation Overview
  • The Workbook Wizard
  • Working with Workbooks and Worksheets
  • Customizing the Output
  • Creating a Query and Viewing Output
  • Building and Managing Basic Queries
  • Building and Executing Queries
  • Controlling Query Execution
  • Customizing Display Properties
  • Understanding Datatypes
  • Formatting Data
  • Customizing Heading, Page, and Data Properties
  • Formatting Numbers and Setting Background
  • Using Conditions to Select Information
  • Viewing, Applying and Disabling Conditions
  • Single Conditions
  • Multiple Conditions
  • Using Functions
  • Grouping
  • Creating Calculated Items
  • Creating, Editing, Viewing, Applying and Disabling Calculations
  • Identifying types of calculations
  • Creating simple and complex calculated items
  • Modifying a calculation
  • Applying simple and complex functions
  • Including totals and subtotals
  • Working with Percentages
  • Wildcards and Parameters with Conditions
  • Creating, Editing, Viewing, Applying and Disabling Parameters
  • Legal Wildcards
  • Wildcard Usage in Conditions
  • Conditions with Parameters
  • Parameters with Wildcards
  • Multiple Parameters
  • Passing Parameters to Calculations
  • Sorting Information in Tabular Reports
  • Sorting Singular columns, options
  • Sorting Multiple columns, options
  • Sorting Hiding / Revealing columns
  • Sorting Group Sorts
  • Joining Multiple Tables in a Report
  • Join Theory, Issues
  • Using Predefined Joins
  • Creating Subqueries (Nested Conditions)
  • Creating a SubQuery Condition
  • Creating a CrossTab Report
  • What is a CrossTab Report?
  • Steps in Creating
  • Creating a Drill-Down Report
  • Drill Types
  • What is a Drill-Down Detail Report?
  • Using the Drill Dialog
  • Steps in Creating
  • Managing Worksheets and Workbooks
  • Copy a Query as a Table
  • Copy a Worksheet as a Crosstab
  • Copy a Worksheet to a New File
  • Scheduling and Managing Queries
  • Exporting Discoverer Output
  • Viewing, Importing and Exporting SQL
  • Analyzing Data Graphically
  • Overview
  • Graph Types
  • Charting Data
  • Positioning a Graph
  • Modifying Titles and Legends
  • The Role of the Administrator
  • Users vs. Super-Users
  • Responsibilities of the Administrator
  • Responsibilities of the End User

Prerequisites

  • Familiarity with Microsoft Windows


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design