Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle 10g > Oracle AS Discoverer 10g Create Queries and Reports Training

Oracle AS Discoverer 10g Create Queries and Reports Training

Course#: WA1379

This class will teach students the purpose and capabilities of the Discoverer 10g AS tool. Thereafter each user can learn to apply this knowledge to the company's internal data model.

Audience

End users and Administrators using Discoverer 10g AS.

Next Course 

The course: Oracle Discoverer Administration 10g: Develop An EUL

Duration

Two days.

 

Outline of WA1379 Oracle AS Discoverer 10g Create Queries and Reports Training

  1. DATA ANALYSIS REVIEW  

  • WHAT IS DATA ANALYSIS
  • INTRODUCTION TO ORACLE10G DISCOVERER
  • DISCOVERER COMPONENTS
  • IMPORTANT TERMINOLOGY
  • THE TRAINING ENVIRONMENT

  2. CREATING QUERIES  

  • STARTING DISCOVERER AS
  • ONLINE HELP
  • THE WORKBOOK WIZARD
  • THE RESULTS WINDOW

  3. QUERY MANAGEMENT  

  • MANAGING WORKBOOKS
  • SAVING WORKBOOKS
  • OPENING WORKBOOKS
  • DELETING WORKBOOKS
  • SHARING WORKBOOKS
  • MANAGING WORKSHEETS
  • MOVING/COPYING WORKSHEETS
  • EDITING WORKSHEETS
  • RENAMING AND DELETING WORKSHEETS

  4. MODIFYING THE DISPLAY  

  • ADDING A REPORT TITLE
  • ADDING A REPORT FOOTER
  • PRINT PREVIEW/PAGE SETUP OPTIONS
  • PAGE SETUP OPTIONS
  • FORMATTING HEADINGS
  • MODIFYING HEADING PROPERTIES
  • FORMATTING DATA
  • CHANGING DEFAULT COLUMN SIZE
  • MODIFYING DATA DISPLAY PROPERTIES
  • SETTING HEADING AND DATA FORMAT DEFAULTS

  5.WORKING WITH CONDITIONS AND PARAMETERS  

  • WORKING WITH CONDITIONS
  • VIEWING, APPLYING, DISABLING CONDITIONS
  • CREATING NEW CONDITIONS
  • USING THE NEW CONDITION DIALOG
  • MULTIPLE AND NESTED FORMULA CONDITIONS
  • CREATE CONDITIONS USING THE ANALYSIS BAR
  • EDITING CONDITIONS
  • WORKING WITH PARAMETERS
  • VIEWING, APPLYING, AND DISABLING PARAMETERS
  • CREATING NEW PARAMETERS
  • EXECUTING THE QUERY WITH THE PARAMETER WIZARD
  • EDITING PARAMETERS

  6. WORKING WITH CONDITIONAL FORMATS AND CALCULATIONS  

  • WORKING WITH CONDITIONAL FORMATS
  • HOW CONDITIONAL FORMATS ARE USED
  • VIEWING, APPLYING, DISABLING EXCEPTIONS
  • CREATING AND EDITING CONDITIONAL FORMATS
  • WORKING WITH CALCULATIONS
  • VIEWING, DISPLAYING, HIDING CALCULATIONS
  • CREATING CALCULATIONS USING THE EDIT CALCULATION DIALOG
  • CREATING CALCULATIONS USING THE TOOL BAR
  • EDITING CALCULATIONS

  7. WORKING WITH SORTS, TOTALS, AND PERCENTAGES

  • WORKING WITH SORTS
  • CREATING COLUMN SORTS
  • CREATING GROUP SORTS
  • THE SORT TABLE DIALOG
  • WORKING WITH TOTALS
  • VIEWING, DISPLAYING, HIDING TOTALS
  • CREATING/EDITING TOTALS USING THE TOTAL DIALOG
  • WORKING WITH PERCENTAGES
  • VIEWING, DISPLAYING, HIDING PERCENTAGES
  • CREATING/EDITING PERCENTAGES
  • USING THE PERCENTAGE DIALOG
  • USING THE TOOL BAR TO CREATE PERCENTAGES
  • DRILLING THE DATA
  • USING DRILLS IN DISCOVERER
  • DRILLING FROM THE WORKBOOK WINDOW
  • USING THE DRILL DIALOG
  • SPECIFYING DRILL OPTIONS
  • DRILLING TO EXTERNAL APPLICATIONS

  8. GRAPHING DATA  

  • CREATING A GRAPH
  • SELECTING A GRAPH TYPE
  • THE GRAPH WINDOW

  9. WORKBOOK MAINTENANCE

  • SCHEDULING WORKBOOKS
  • SCHEDULE WORKBOOK DIALOG
  • SCHEDULING MANAGER
  • OPENING SCHEDULED WORKBOOKS
  • EXPORTING DISCOVERER OUTPUT
  • USING THE EXPORT DIALOG

  10. WORKING WITH SQL AND SETTING OPTIONS  

  • VIEWING, EXPORTING, AND IMPORTING SQL
  • THE SQL INSPECTOR/PLAN DISPLAY
  • SETTING DISCOVERER OPTIONS
  • GENERAL OPTIONS
  • QUERY GOVERNOR OPTIONS
  • SHEET OPTIONS
  • FORMAT OPTIONS
  • ADVANCED OPTIONS
  • EUL OPTIONS

  11. USING SQL FUNCTIONS IN DISCOVERER  

  • USING FUNCTIONS IN DISCOVERER
  • FUNCTION CATEGORIES
  • TYPES OF FUNCTIONS
  • STRING FUNCTIONS
  • CHARACTER STRING FORMATTING FUNCTIONS
  • CHARACTER STRING MANIPULATION FUNCTIONS
  • NUMERIC FUNCTIONS
  • NUMERIC COMPARISON AND PRESENTATION FUNCTIONS
  • DATE FUNCTIONS
  • DATE RECALCULATION FUNCTIONS
  • NESTING FUNCTIONS
  • USING ANALYTIC FUNCTIONS

  12. INTRODUCTION TO DISCOVERER VIEWER

  • WHAT IS DISCOVERER VIEWER
  • STARTING DISCOVERER VIEWER
  • USING DISCOVERER VIEWER
  • DIFFERENCES BETWEEN DISCOVERER PLUS AND DISCOVERER VIEWER

  13. INTRODUCTION TO DISCOVERER DESKTOP INTERFACES (OPTIONAL)  

  • DISCOVERER DESKTOP
  • USING DISCOVERER DESKTOP
  • COMPARE/CONTRAST PLUS AND DESKTOP
  • PREPARING FOR PRACTICE EXERCISES
  • WORKSHOP SYSTEM REQUIREMENTS
  • EXTRACTING THE STUDENT FILES
  • PREPARING TO RUN THE SQL SCRIPTS
  • CREATING STUDENT ACCOUNTS
  • CREATING THE CAMP_SRC SCHEMA
  • BUILDING THE END USER LAYER AND BUSINESS AREA
  • SETTING SECURITY AND PRIVILEGES
  • REGISTERING THE SALES_TAX() FUNCTION
  • COPYING THE SAMPLE WORD DOCUMENT
  • TESTING THE SETUP
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.