Oracle Discover 4.1 Desktop User Edition

This 2-day course will teach students the purpose and capabilities of the Discoverer 4.1 Desktop User Edition tool. Users learn to create fully customized ad-hoc queries. They will also learn how to modify the display, drill to data at several levels, analyze the data graphically, and perform other various tasks such as scheduling, importing and exporting workbooks. This course will present a thorough knowledge of the Discoverer Desktop Edition tool. Thereafter each user can learn to apply this knowledge to the company's internal data model.

Target audience

This course has been developed for end users and administrators using Discoverer on the Desktop

Course content

Creating queries Starting Discoverer 4.1 Desktop User edition • Command line options • Online help • The workbook wizard • The results window

Query management Managing workbooks • Managing worksheets • Editing worksheets • Managing items

Modifying the display Adding a report title • Page setup options • Formatting headings • Changing heading text • Modifying heading properties • Formatting data • Changing default column size • Displaying images in background • Modifying data display properties • Printing the report

Working with conditions and parameters Viewing, applying, disabling conditions • Creating new conditions • Multiple and nested formula conditions • Subqueries • Create conditions using the Analysis Bar • Editing conditions • Viewing, applying and disabling parameters • Creating new parameters • Executing the query • Editing parameters

Working with exceptions and calculations Viewing, applying, disabling exceptions • Creating and editing exceptions • Creating calculations using the edit calculations dialog • Creating calculations using the analysis bar • Editing calculations

Working with sorts, totals, percentages Creating column sorts • Creating/editing group sorts • Viewing, displaying, hiding totals • Creating totals using the totals dialog • Creating totals using the analysis bar • Viewing, displaying, hiding percentages • Creating and editing percentages

Drilling the data Drilling up and down • Drilling from the workbook window • Using the drill dialog • Specifying drill options • Drilling to a related item • Drilling to details in another sheet • Drilling to external applications

Graphing data Creating a graph • Selecting a graph type • The graph window • Customizing the colours and patterns • Customizing the graph • 3D view properties • Scale and numbers • Editing the graph

Workbook maintenance Scheduling workbooks • Schedule workbook dialog • Scheduling manager • Opening scheduled workbooks • Exporting Discoverer output • Using the export dialog • Sending workbooks via e-mail

Working with SQL and setting options Viewing, exporting and importing SQL • The SQL Inspector and plan display • Setting Discoverer options • General options • Query Governor options • Table/crosstab options • Format options • Cache options • Advanced options • EUL options • Connection options

Using SQL functions in Discoverer Function categories • Types of functions • String functions • Numeric functions • Numeric comparison and presentation functions • Date functions • Nesting a function

Introduction to analytic functions (optional)

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today