The course Oracle Database 10g: Introduction to SQL - Complete Library

Oracle Training Suggested Next Courses

The course: Oracle Discoverer 10g: Develop An EUL

Oracle Training Course duration

2 Days

Oracle Training Course outline

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