Oracle Reports Developer 10g : Build Internet Applications
Day 1
- Introduction
- Lesson 1 : Introduction to Oracle Reports Developer
- Lesson 2 : Designing and Running Reports
- Lesson 3 : Working in Oracle Reports Developer
- Lesson 4 : Creating a Paper Report
- Lesson 5 : Enhancing a Basic Paper Report
Day 2
- Lesson 6 : Managing Report Templates
- Lesson 7 : Creating a Web Report
- Lesson 8 : Enhancing Reports Using the Data Model: Queries and Groups
- Lesson 9 : Enhancing Reports Using the Data Model: Data Sources
- Lesson 10 : Enhancing Reports Using the Data Model: Creating Columns
Day 3
- Lesson 11 : Enhancing Reports Using the Paper Layout
- Lesson 12 : Controlling the Paper Layout: Common Properties
- Lesson 13 : Controlling the Paper Layout: Specific Properties
- Lesson 14 : Web Reporting
- Lesson 15 : Extending Functionality Using XML
Day 4
- Lesson 16 : Creating and Using Report Parameters
- Lesson 17 : Embedding a Graph in a Report
- Lesson 18 : Enhancing Matrix Reports
- Lesson 19 : Coding PL/SQL Triggers
- Lesson 20 : Navigation
Day 5
- Lesson 20 : Extending Functionality Using the SRW Package
- Lesson 21 : Maximizing Performance Using OracleAS Reports Services
- Lesson 22 : Building Reports: Efficiency Guidelines
Lesson 1 : Introduction to Oracle Reports Developer
- Describe business intelligence
- List the benefits of enterprise reporting
- Describe the differences between Web publishing and paper publishing
- Describe the key features of Oracle Reports Developer
- Describe the architecture of Oracle Application Server
- Describe OracleAS Reports Services
Lesson 2 : Designing and Running Reports
- dentify user requirements
- Name the common report styles
- Describe the structure of each style
- Run prebuilt reports as an end user
- Identify supported report file types
Lesson 3 : Working in Oracle Reports Developer
- Describe the main Oracle Reports executables
- Describe the main components of Reports Builder
- Describe the main objects in a report
Lesson 4 : Creating a Paper Report
- Create a simple tabular paper report using the Report Wizard
- Describe the methods of building the report query
- Summarize report values
- Modify the style and content of a report
- Create other report styles available in the Report Wizard
- Preview a paper report on the Web
Lesson 5 : Enhancing a Basic Paper Report
- Describe the Paper Design view
- Modify the display of report data in the Paper Design view
- Modify the positioning of report data
- Highlight data using conditional formatting
- Add page numbering and the current date
Lesson 6 : Managing Report Templates
- Describe the template regions
- Describe the difference between default and override template sections
- Modify a predefined report template
- Register a customized template
- Add a Web link to a template
Lesson 7 : Creating a Web Report
- Identify the options for designing a Web page
- Create a simple Web report using the Report Wizard
- Invoke the Web Source view of the Report Editor
- Describe the elements of the Web source code
- Preview a Web report
- Identify supported image formats for Web reports
Lesson 8 : Enhancing Reports Using the Data Model: Queries and Groups
- Describe the Data Model objects
- Modify query properties
- Modify the report hierarchy
- Change the order of data in a group
- Eliminate data from a report
Lesson 9 : Enhancing Reports Using the Data Model: Data Sources
- IDescribe the various data source types
- Create reports using pluggable data sources
- Create supplemental rows of data by adding queries
- Reuse PL/SQL code to create a REF cursor
- Link data from multiple data sources using a data link
Lesson 10 : Enhancing Reports Using the Data Model: Creating Columns
- IDescribe various Data Model columns
- Display the contents of a file
- Identify characteristics of user-defined columns
- Create report summaries and subtotals
- Derive data using a formula column
- Create and populate a placeholder
Lesson 11 : Enhancing Reports Using the Paper Layout
- Identify the paper report sections
- Design multipanel reports
- Mail a report
- Distribute a report to various destinations
- Describe the layout objects and relationships
- Modify an existing paper report layout
- Create variable length lines
Lesson 12 : Controlling the Paper Layout: Common Properties
- Identify common paper layout properties
- Modify common paper layout properties
- Explain the use of format triggers
- Modify Web Settings properties
Lesson 13 : Controlling the Paper Layout: Specific Properties
- Identify specific layout properties
- Modify specific layout properties
- Explain the use of specific properties
- Create a file link
- Specify the format order for the report sections
- Enable cataloguing and searching of PDF output
Lesson 14 : Web Reporting
- Identify the attributes of a high quality Web report
- Describe the JavaServer Page run-time environment
- Describe static and dynamic Web reporting
- Add dynamic content to a Web page
- Identify Reports custom JSP tags
- Customize Web reports
Lesson 15 : Extending Functionality Using XML
- Describe the benefits of XML definitions
- Create XML report definitions
- Apply XML report definitions
- Debug XML report definitions
Lesson 16 : Creating and Using Report Parameters
- Create and reference a parameter
- Create a list of values for parameter input
- Use and modify a system parameter
- Build a Paper Parameter Form layout
- Customize a Paper Parameter Form layout
- Use HTML parameter form extensions
Lesson 17 : Embedding a Graph in a Report
- Create and display a simple graph
- Customize a graph in a Web report
- Modify graph data dynamically
- Specify additional graph attributes using Graph.XML
- Use graph hyperlinks
Lesson 18 : Enhancing Matrix Reports
- Design a matrix Data Model
- Design a matrix Paper Layout
- Modify a matrix structure
- Create and modify matrix summaries
- Create a matrix with group report
- Create a nested matrix report
Lesson 19 : Coding PL/SQL Triggers
- Describe the different types of triggers
- Describe sample uses of triggers
- Write and reference common code
- Create a PL/SQL library
- Publish a report as a result of a database event
Lesson 20 : Extending Functionality Using the SRW Package
- Describe the package contents
- Output messages at run time
- Execute a drill-down report
- Create a simple table of contents
- Create and populate temporary tables
- Modify visual attributes dynamically
Lesson 21 : Maximizing Performance Using OracleAS Reports Services
- Describe the OracleAS Reports Services architecture
- Distinguish between the JSP and Servlet run-time architectures
- Describe the various ways to run a report
- List the options for managing and monitoring OracleAS Reports Services
Lesson 22 : Building Reports: Efficiency Guidelines
- Describe performance areas
- Use performance measuring tools
- Build reports to run in other languages
In-house price for 5 days
- 85,000 baht(THB) : Small Class : 1 - 10 persons
- 115,000 baht(THB) : Medium Class : 11 - 20 persons
- 145,000 baht(THB) : Big Class : 21 - 30 persons
- All prices exclude VAT 7 %