Oracle 10g Discoverer Desktop For End Users培训
Oracle 10g Discoverer Desktop For End Users培训
培训大纲：
1. Introduction to Workbooks
Benefits of Discoverer
Understanding Discoverer components
Starting Discoverer Desktop
Opening a workbook
2. Working with Workbooks
The Workbook window
Selecting sections in worksheets
Formatting worksheets
3. Creating Workbooks
Types Of worksheets
Creating tabular worksheets
Creating crosstab worksheets
4. Customizing the Display
Customizing item headings
Customizing data displays
Customizing report headings
5. Conditions and Parameters
Creating a condition
Parameters in conditions
Multiple conditions
6. Group Sorts and Summaries
Creating group-sorted output
Including totals and subtotals
7. Calculated Items
Creating calculated items
Calculating percentage of the whole
Applying functions
Key SQL functions
Key conversion functions
Key date functions
Key numeric functions
Key string functions
Other key functions
8. Managing Queries, Worksheets, and Workbooks
Copy a query sheet as a table
Copy a worksheet as a crosstab
Monitoring query execution
9. Conditions and Subqueries
Creating subqueries in conditions
10. Drills in Worksheets
Identifying drill types
11. Analyze Data Graphically
Graphically analyze table output
12. Scheduling and Managing Queries
Scheduling periodical queries
Scheduling a report
Viewing scheduled notebooks
13. Advanced Options
Support for MS Excel and other file formats
Other advanced features
"What Your Discoverer Manager Can Do for You"