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 %

Printable Version ดาวน์โหลดหน้านี้ >>