Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

    Start ReadingShareBuy Print Version
    Oracle Discoverer 10g: Create Queries & Reports (Windows)

    • Oracle Discoverer 10g: Create Queries & Reports (Windows)

    • By:

    • Publisher: Sideris Courseware Corp.

    • Pub. Date:

    • Print ISBN: ora10g502-ver2-win

    • Pages in Print Edition: 438

    • Subscriber Rating: 0 out of 5 rating0 [0 Ratings]

    2ebooken
    Subscriber Reviews • Browse Similar Topics

    Overview

    This Oracle 10g courseware training guide book 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.

    Subscriber Reviews

    Average Rating: 0 out of 5 rating Based on 0 Ratings

    No Subscribers have provided a review for this book.

    Table of Contents

     

    View Sample
    Oracle Discoverer 10g: Create Queries & Reports (Windows)
    View Sample

    Acknowledgements

    View Sample

    Table Of Contents

    View Sample
    Introduction
    View Sample

    Topics

    View Sample

    How To Use This Course

    View Sample
    Data Analysis Review
    View Sample

    What is Data Analysis

    View Sample

    Discoverer Components

    View Sample

    Important Terminology

    View Sample

    The Training Environment

    View Sample
    Lesson 1: Creating Queries
    View Sample

    Topics

    View Sample

    Command Line Options

    View Sample

    Online Help

    View Sample

    The Workbook Wizard

    View Sample

    The Results Window

    View Sample

    Summary

    View Sample

    Practice Exercise 1

    View Sample

    Practice Solutions 1

    View Sample
    Lesson 2: Query Management
    View Sample

    Topics

    View Sample

    Managing Workbooks

    View Sample

    Saving Workbooks

    View Sample

    Opening Workbooks

    View Sample

    Deleting Workbooks

    View Sample

    Sharing Workbooks

    View Sample

    Managing Worksheets

    View Sample

    Adding And Duplicating Worksheets

    View Sample

    Moving/Copying Worksheets

    View Sample

    Editing Worksheets

    View Sample

    Renaming And Deleting Worksheets

    View Sample

    Managing Items

    View Sample

    Summary

    View Sample

    Practice Exercise 2

    View Sample

    Practice Solutions 2

    View Sample
    Lesson 3: Modifying The Display
    View Sample

    Topics

    View Sample

    Adding A Report Title

    View Sample

    Page Setup Options

    View Sample

    Formatting Headings

    View Sample

    Changing Heading Text

    View Sample

    Modifying Heading Properties

    View Sample

    Formatting Data

    View Sample

    Changing Default Column Size

    View Sample

    Displaying Images In Background

    View Sample

    Modifying Data Display Properties

    View Sample

    Printing The Report

    View Sample

    Summary

    View Sample

    Practice Exercise 3

    View Sample

    Practice Solutions 3

    View Sample
    Lesson 4: Working With Conditions And Parameters
    View Sample

    Topics

    View Sample

    Working With Conditions

    View Sample

    Viewing, Applying, Disabling Conditions

    View Sample

    Creating New Conditions

    View Sample

    Using The New Condition Dialog

    View Sample

    Multiple And Nested Formula Conditions

    View Sample

    Subqueries

    View Sample

    Create Conditions Using The Analysis Bar

    View Sample

    Editing Conditions

    View Sample

    Working With Parameters

    View Sample

    Viewing, Applying, And Disabling Parameters

    View Sample

    Creating New Parameters

    View Sample

    Executing The Query With The Parameter Wizard

    View Sample

    Editing Parameters

    View Sample

    Summary

    View Sample

    Practice Exercise 4

    View Sample

    Practice Solutions 4

    View Sample
    Lesson 5: Working With Exceptions And Calculations
    View Sample

    Topics

    View Sample

    Working With Exceptions

    View Sample

    How Exceptions Are Used

    View Sample

    Viewing, Applying, Disabling Exceptions

    View Sample

    Creating And Editing Exceptions

    View Sample

    Working With Calculations

    View Sample

    Viewing, Displaying, Hiding Calculations

    View Sample

    Creating Calculations Using The Edit Calculation Dialog

    View Sample

    Creating Calculations Using The Analysis Bar

    View Sample

    Editing Calculations

    View Sample

    Summary

    View Sample

    Practice Exercise 5

    View Sample

    Practice Solutions 5

    View Sample
    LESSON 6: WORKING WITH SORTS, TOTALS, AND PERCENTAGES
    View Sample

    Topics

    View Sample

    Working With Sorts

    View Sample

    Creating Column Sorts

    View Sample

    Creating Group Sorts

    View Sample

    The Sort Table Dialog

    View Sample

    Working With Totals

    View Sample

    Viewing, Displaying, Hiding Totals

    View Sample

    Creating/Editing Totals Using The Total Dialog

    View Sample

    Creating Totals Using The Analysis Bar

    View Sample

    Working With Percentages

    View Sample

    Viewing, Displaying, Hiding Percentages

    View Sample

    Creating/Editing Percentages

    View Sample

    Using The Percentage Dialog

    View Sample

    Using The Analysis Bar To Create Percentages

    View Sample

    Summary

    View Sample

    Practice Exercise 6

    View Sample

    Practice Solutions 6

    View Sample
    Lesson 7: Drilling The Data
    View Sample

    Topics

    View Sample

    Using Drills In Discoverer

    View Sample

    Drilling Up And Down

    View Sample

    Drilling From The Workbook Window

    View Sample

    Using The Drill Dialog

    View Sample

    Specifying Drill Options

    View Sample

    Drilling To A Related Item

    View Sample

    Drilling To Details In Another Sheet

    View Sample

    Drilling To External Applications

    View Sample

    Summary

    View Sample

    Practice Exercise 7

    View Sample

    Practice Solutions 7

    View Sample
    Lesson 8: Graphing Data
    View Sample

    Topics

    View Sample

    Creating A Graph

    View Sample

    Selecting A Graph Type

    View Sample

    The Graph Window

    View Sample

    Customizing The Graph

    View Sample

    3D View Properties

    View Sample

    Scale And Numbers

    View Sample

    Editing The Graph

    View Sample

    Summary

    View Sample

    Practice Exercise 8

    View Sample

    Practice Solutions 8

    View Sample
    Lesson 9: Workbook Maintenance
    View Sample

    Topics

    View Sample

    Scheduling Workbooks

    View Sample

    Schedule Workbook Dialog

    View Sample

    Scheduling Manager

    View Sample

    Opening Scheduled Workbooks

    View Sample

    Exporting Discoverer Output

    View Sample

    Using The Export Dialog

    View Sample

    Sending Workbooks Via Email

    View Sample

    Summary

    View Sample

    Practice Exercise 9

    View Sample

    Practice Solutions 9

    View Sample
    Lesson 10: Working With SQL And Setting Options
    View Sample

    Topics

    View Sample

    Viewing, Exporting, And Importing SQL

    View Sample

    The SQL Inspector/Plan Display

    View Sample

    Setting Discoverer Options

    View Sample

    General Options

    View Sample

    Query Governor Options

    View Sample

    Table/Crosstab Options

    View Sample

    Crosstab Options

    View Sample

    Aggregation Options

    View Sample

    Format Options

    View Sample

    Cache Options

    View Sample

    Connection Options

    View Sample

    Advanced Options

    View Sample

    EUL Options

    View Sample

    Summary

    View Sample

    Practice Exercise 10

    View Sample

    Practice Solutions 10

    View Sample
    Lesson 11: Using SQL Functions In Discoverer
    View Sample

    Using Functions In Discoverer

    View Sample

    Function Categories

    View Sample

    Types Of Functions

    View Sample

    String Functions

    View Sample

    Character String Formatting Functions

    View Sample

    Character String Manipulation Functions

    View Sample

    Numeric Functions

    View Sample

    Numeric Comparison And Presentation Functions

    View Sample

    Date Functions

    View Sample

    Date Recalculation Functions

    View Sample

    Nesting A Function

    View Sample

    Using Analytic Functions

    View Sample

    Summary

    View Sample

    Practice Exercise 11

    View Sample

    Practice Solutions 11

    View Sample
    Lesson 12: Introduction To Discoverer Web Interfaces (Optional)
    View Sample

    Topics

    View Sample

    Summary

    View Sample
    Appendix A ­ Course Workshop Setup
    View Sample

    Preparing For Practice Exercises

    View Sample

    Workshop System Requirements

    View Sample

    Extracting The Student Files

    View Sample

    Preparing To Run The SQL Scripts

    View Sample

    Creating Student Accounts

    View Sample

    Creating The CAMP_SRC Schema

    View Sample

    Building The End User Layer And Business Area

    View Sample

    Setting Security And Privileges

    View Sample

    Registering The SALES_TAX() Function

    View Sample

    Testing The Setup

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    Windows version files

    • extras.zip