Course Overview

Learn To:

• Create, manage, and format ad hoc queries.

 
• Manage worksheets and workbooks.

 
• Generate, customize, and export reports.

 
• Schedule batch reports.

 
• Customize queries by applying conditions and parameters.

 
• Create sorts, calculations, percentages, and summaries.

 
• Analyze date with graphs and drills.

Skills-Based

Audience

End users, data analysts, and technical support professionals.

Total Learning Time

6 - 8 Hour(s)

Course Contents

• Match the three main Discoverer components to the correct definition.
• Match the available database sources to the correct definition.
• Identify the help options available when using Discoverer 3.1.
• Match key Discoverer 3.1 terms to the correct definition.
• Identify primary functions performed by the Discoverer Administrator.

• Create a new workbook using the Workbook Wizard.
• Include items in a query using the Workbook Wizard.
• Convert a table layout to a page-detail layout using the Workbook Wizard.
• Add a predefined condition to a query using the Workbook Wizard.
• Identify the components of the Results window.
• Identify the available options for customizing information in the Results Window.
• Define pivoting an axis item in the Results window.
• Define display properties.
• Identify the elements of item heading and data that you can customize.
• Identify the datatypes supported by Discoverer 3.1.
• List the steps performed to create and run a query.
• Change the default directory used to store cached data.
• Identify the query actions that you can govern.

• Define worksheets and workbooks.
• Set a default title for worksheets.
• Rename a worksheet using the worksheet tab.
• Duplicate a worksheet as a table using the toolbar.
• Delete a worksheet.
• Save a workbook to the database.
• Open a workbook saved to the database.
• Create a new workbook using the toolbar.
• Delete a workbook from the database.
• Identify the four most common options available for customizing workbooks.
• Schedule a workbook.
• Edit a scheduled workbook using the Scheduling Manager.
• Share a workbook with another user.
• Access the Page Setup dialog box to select formatting options.
• Create and format the header for a printout.
• Format the margins of a printout using the Page Setup dialog box.
• Export a report.
• Review the SQL generated for a worksheet and export the worksheet as SQL.
• Import an SQL file.

• Define exception.
• Create and apply an exception.
• Identify conditional operators.
• Create a single condition.
• Differentiate between grouped conditions and nested conditions.
• Add a new condition to an existing condition.
• Change the logical operator for a grouped condition using the Group button in the Edit Condition dialog box.
• Create a nested condition.
• Identify the element of a parameterized query that is supplied by the user when the query is run.
• Create a parameterized query.
• Sort a column of output.
• Apply a group sort.
• Apply a total using the toolbar buttons.
• Apply a summary using the Tools menu.
• Identify the arithmetic operators available for use in Discoverer 3.1 calculations.
• Find a percentage using the tools menu.
• Find a percentage using the toolbar.
• Create a calculation using the Tools menu.
• Create a calculation using the toolbar buttons.
• Identify the elements of a complex calculation.

• Identify the definition of drilling.
• Identify the difference between drilling up an down and drilling to a related item.
• Identify the results from a filtered drill and the results from an unfiltered drill.
• Identify the options available for direct drilling in Discoverer 3.1.
• Identify the options available for hyperdrilling.
• Drill out to an external application using a Hyperdrill plug-in.
• Identify the options available to display the Drill dialog box.
• Change a drill item.
• Identify the options available for customizing drills in Discoverer 3.1.

• Identify the information available in a graph produced using Discoverer 3.1.
• Generate a graph of crosstab output with the Graph Wizard using the Graph button.
• Generate a graph of table output with the Graph Wizard using the Graph menu.
• Drill down in a graph.
• Identify the methods available to customize a graph in Discoverer 3.1.
• Change the type of graph with the Modify Graph dialog box using the Graph menu.
• Change the type of graph using the New Graph Type button on the Graph Window toolbar.
• Add a legend to a query.
• Change a graph color.
• Rotate the graph.
• Customize a graph title.
• Customize the Y-axis.

Click here for Secure Yahoo Order: Oracle Discoverer 3.1: Data Exploration

Get Train in Oracle
Oracle Training CBT

Best Regards,
Oracle Database, SQL, Application, Programming Tips