Oracle AS Discoverer 10g Create Queries and Reports (Windows) Study Guide

1-4188-6259-2 © 2006 Publish date: July 26, 2005 442 pages

Buy Now: $99.99

Course ID: oracle-as-disc-10g-createqr-win-sg

Learn the ins and outs of Oracle AS Discoverer by choosing the Oracle AS Discoverer 10g Create Queries and Reports (Windows) study guide from our Oracle computer training books selection. You will examine the capabilities of Oracle's Discoverer 10g AS tool and learn its purpose. After following the training, you will be able to use this knowledge and transfer it to your company's internal data model.

The Oracle AS Discoverer 10g Create Queries and Reports (Windows) courseware sets you up for success by giving you detailed information in an easy-to-use format. You'll get a complete overview of the product as well as an overview of data analysis. You'll learn about working with queries and managing your workbooks, making modifications to the display, using parameters and conditions, working with calculations and conditional formats, using sort functions, totals, and percentages, and how to graph your data. Other topics include maintaining your workbooks, working with SQL and an overview of Discoverer Viewer and Discoverer Desktop Interfaces.

Use the Oracle AS Discoverer 10g Create Queries and Reports (Windows) courseware as a standalone training tool or as a supplement to your existing Oracle classes. No matter how you use it, you are in charge of your learning with this self-directed course.

Course Contents

Data analysis

• Data analysis overview
• A look at Oracle10g Discoverer
• Components and terminology
• Training environments

Queries

• Learning to start Discoverer AS
• Getting help online
• Exploring the workbook wizard
• Results window

Managing your queries

• A look at workbook management
• How to save, open, delete, share, and manage your workbooks
• How to move, copy, edit, rename, and delete your worksheets

Making modifications to your display

• How to add report titles and footers
• Working with print preview
• Working with page setup options
• How to format headings and data
• Working with heading properties
• Adjusting default column size
• Adjusting data display properties
• Adjusting heading and data format defaults

An overview of conditions and parameters

• How to create, view, apply, edit, and disable conditions
• A look at the new condition dialog
• Discussing multiple and nested formula conditions
• Using the analysis bar create conditions
• A look at parameters
• How to create, view, apply, edit, and disable parameters
• Using the parameter wizard

Conditional formats and calculations

• How conditional formats are used
• How to create, view, apply, edit, and disable exceptions
• Calculations
• How to view, display, edit, and hide calculations
• Using the edit calculation dialog
• How to use the tool bar for creating calculations

Working with sorts, totals, and percentages

• Column sorts
• Group sorts
• Sort table dialog
• How to display and hide totals
• How to use the total dialog to create and edit totals
• How to display and hide percentages
• Creating and editing percentages
• Percentage dialog
• Creating percentages with the tool bar

Drilling the data

• Drilling
• Using the drill dialogs
• Drill options
• Using drilling to external applications

Graphs

• Building graphs
• Types of graphs

Maintenance

• Scheduling
• Discoverer output options
• Export dialog

SQL and options

• Importing and exporting SQL
• SQL inspector
• The plan display
• Adjusting Discoverer options
• General options, query governor options, sheet options, format options, advanced options, and EUL options

SQL functions

• Function categories and types
• String functions and formatting
• Character string manipulations
• Numeric functions, numeric comparisons, and presentation functions
• Date functions and date recalculation functions
• Nesting functions and analytic functions

Discoverer Viewer

• Using Discoverer Viewer
• Discoverer Plus compared to Discoverer Viewer

A look at Discoverer Desktop Interfaces

• Differences between Discoverer Plus and Discoverer Desktop
• Practice exercises preparation
• System requirements
• Accessing student files
• Using SQL scripts
• student accounts
• The "camp_src schema"
• Building end user layer and business area
• Security and privileges
• The "sales_tax()" functions
• Sample Word documents
• Setup tests