GSAtrain

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

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

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

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

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

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

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

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

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

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

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

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

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