Course Overview

Learn To:

• Create and manage ad-hoc queries.

 
• Apply conditions and use parameters.

 
• Create sorts, calculations, and summaries.

 
• Analyze data with graphs and drills.

 
• Use reports.

Skills-Based

Audience

End Users and Technical Support Professionals. Familiarity with Microsoft Windows applications.

Total Learning Time

6 - 8 Hour(s)

Course Contents

• Match each of the three Discoverer 3 components to the correct definition.
• Match the labels database and relational database to the correct definition.
• Identify the help options available when using Discoverer 3.
• Match key Discoverer 3 terms to the correct definition.
• Identify the primary function performed by the Discoverer Administrator.

• Create a 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 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.

• 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.
• Define display properties.
• Identify the elements of item headings and data that you can customize.
• Identify the datatypes supported by Discoverer 3.
• Define exception.
• Create an exception.

• Match the following labels to the correct definition: condition and parameter.
• 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 calculations.
• Create a calculation using the Tools menu.
• Create a calculation using the toolbar.
• Identify the elements of a complex calculation.

• Identify the definition of drilling.
• Identify the difference between drilling up and 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..
• Identify the options available for hyperdrilling.
• Drill out to an external application using a Hyperdrill plug-in.
• Enable a built-in viewer.
• Identify the options available to display the Drill dialog box.
• Change a drill item.
• Identify the options available to display the Drill dialog box.
• Change a drill item.
• Identify the options available for customizing drills in Discoverer 3.

• Identify the information available in a graph produced using Discoverer 3.
• Generate a graph of crosstab output using the Graph button.
• Generate a graph of table output using the Graph menu.
• Add a new legend to a graph.
• Drill down in a graph.
• Change the style of a graph from bar to line using the Graph menu.
• Identify the methods available to customize a graph in Discoverer 3.

• 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.
• Match command line interface commands to their function.

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

Get Train in Oracle
Oracle Training CBT

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