Oracle 10G Reports Developer Training Course
 Netwind Lewarning Center Oracle 10G Reports training will
teach you about Oracle's award-winning, high-fidelity enterprise reporting tool.You will learn to provide immediate access to information to all levels within and outside of the organization in
an unrivaled scalable and secure environment. Oracle 10G Reports consists of Reports Developer (a component of the Oracle Developer Suite) and Application Server Reports
Services (a component of the Oracle Application Server).
RAPID AND POWERFUL DEVELOPMENT
Using a declarative, document-centric development model, Reports Developer focuses a new user on the tasks required in the design of a report, while still allowing experienced
developers to have total control of their report development. Seemingly daunting tasks such as designing complex data
models and layouts become simple drag and drop actions. Some of the wizards and tools available in the Reports Builder are:
- The Query Wizard visually represents and constructs complex SQL queries.
- The Data Wizard organizes data according to the report's requirements.
- The Report Wizard creates the report in a few steps.
- The Graph Wizard allows you to choose from more than 50 graph types and create a business chart using a few simple steps.
- The Conditional Formatting Wizard formats data according to defined exceptions or conditions.
- The Distribution dialog box sends your report to multiple destinations.
- The Java Importer allows you to use Java business logic in your report.
- The Stored PL/SQL Editor edits program units stored in the database.
Included with this training program:
- Interactive Multi-Media Training with Audio Track
- Practice simulated lab exercises
- Training Time: Over 25 hours of training
- Interactive Review questions
- Available in CD-ROM or Online formats
- Co-developed training with Oracle. Guarantees that your training will cover 100% of the certification's exam objectives.
- Audience
The target audience for this course includes database administrators (DBAs), technical consultants, sales consultants, support engineers, and report developers.
|
CD-ROM Oracle 10G Reports Developer Course
|
N67451DC
|
$399.00
|
|
|
Online Oracle 10G Reports Developer Course One Year Access
|
N67451DO
|
$399.00
|
|
Oracle Reports Developer Training Course includes the following
Working with Oracle Reports Developer
 Course Overview
This course introduces students to concepts related to Reports Developer 10g, Reports Builder, and OracleAS Reports Services. Students will learn to build and customize reports
using Reports Builder and deploy them using Reports Services. They will also learn about the various reports styles and layouts and understand concepts related to Report Module objects. In
addition, they will learn about the features of Reports environment variables.
Participants will learn
Identify features of Reports Builder components.
Identify Reports Builder navigation options.
Identify key aspects of Reports Builder.
Identify key aspects of previewing reports.
Identify considerations for running reports.
Match standard report styles with their descriptions.
Identify features of Oracle 10g products.
Identify benefits of enterprise reporting.
Match BI tools with their functions.
Paper, Web Reports, and Templates
Training Overview
In this course, students will learn how to design and build standard and custom Web and paper
reports using Oracle Reports Developer. Working in the declarative environment of Reports Builder, students learn how to retrieve, display, and format data from any data source in numerous reporting
styles and publish the output to any destination. In addition, students learn how to add dynamic content to a static Web page and publish reports to the Web. Students also learn how to customize
more complex reports, embed graphical charts, and use OracleAS Reports Services to deploy reports.
Participants will learn
- Match JSP tags with their definitions.
- Key concepts related to building Web reports.
- Identify the advantages of JSP Technology.
- Sequence the steps to add Web links to a template.
- Aspects of customizing the template margin and body.
- Aspects of using and modifying a template.
- Options used to modify objects and visual attributes.
- Identify key aspects of aligning columns and setting format masks.
- Identify features of the Paper Design view.
- Match the other report styles with their features.
- Sequence the steps to build a query using Query Builder.
- Sequence the steps to create a tabular report using the Report Wizard.
Working with the Data Model
Course Overview
This course covers fundamentals of the Oracle DB architectural framework. In this course, students
will learn about Oracle DB 10g grid computing and administration. They will also go through key aspects of migration to Oracle DB and Oracle DB 10g installation. Further, they will learn about
management of Oracle instances and database storage structures.
Participants Will Learn
- Features of data source columns.
- Sequence the steps to create a column.
- Identify features of Data Model columns.
- XML as a data source.
- Pluggable data sources.
- Features of data sources to produce Oracle Reports.
- Identify key aspects of modifying query properties.
- Methods of applying changes to Web and paper reports.
- Identify features of Data Model objects
Working with Layout Objects
Course Overview
This training course covers concepts related to Oracle Reports Developer 10g. In this course,
students will learn about common layout object properties and specific properties for reports, repeating frames, fields, and boilerplate. Further, they will learn to reference the contents of a file at
run time. Finally, they will learn to specify the format order for the report sections and taxonomy properties for PDF documents.
Participants Will Learn
- Match Web Setting properties of layout objects with their features.
- Features of repeating frame properties.
- Identify guidelines for controlling records per page and interspacing.
- Match the values of print direction with their descriptions.
- Characteristics of a field.
- Match key system variables with their descriptions.
- Identify the Page Numbering properties.
- Guidelines for using valid source columns.
- Sequence the steps to create a file link object.
- Match the file link and file column with their features.
- Identify the features of specifying the format order and the PDF document taxonomy properties.
- Match object elasticity types with their descriptions.
- Identify the impact of anchors on object layout.
- Match pagination properties in the Paper Layout view with their descriptions.
- Aspects related to using the Page Break Before property.
- Aspects related to using the Page Break After property.
- IPage Protect and format triggers.
- Identify features of controlling print frequency.
- Identify ways to access the Property Inspector.
- Identify common properties of layout objects.
- Identify key aspects of creating variable length lines.
- Sequence the steps to trace the distribution of a report.
- Sequence the steps to create additional report layouts.
- Sequence the steps to set up a report to burst on a repeating group.
- Key features of report bursting.
- Identify key features of report processing.
- Match paper report layout objects with their descriptions.
- Paper Layout layers and modes with their features.
- Paper Layout objects and tools with their features.
- Sequence the steps to design multipanel reports.
- Identify key aspects of viewing the Paper Layout and section areas.
Web and XML Report, Report Parameters
Course Overview
This course covers concepts related to Oracle Reports Developer 10g. The course aims to give
students an understanding of Web reporting, reports parameters, and graphs. Students will learn about common attributes and considerations applicable to Web reports and XML reports. Further,
they will learn to add and work with graphs in reports.
Participants Will Learn
- Match rw:graph tag attributes with their definitions.
- Sequence the steps to add a graph to Web reports.
- Identify the steps to invoke the Graph Wizard.
- Identify conditions under which bind references can be used.
- Distinguish between features of a bind reference and a lexical reference.
- Match parameter properties with their descriptions.
- Identify features of partial and full report definitions.
- Identify the steps involved in the process to create and use XML report definitions.
- Identify benefits of using XML report definitions.
- Sequence the steps to define a Data Model for a Web page.
- Key aspects of static and dynamic reporting.
- Key aspects of Oracle Reports as a high-quality Web publishing tool.
Matrix Reports, Triggers, SRW Package
Course Overview
This training course covers concepts related to matrix reports, triggers, and SRW packages. In this
course, students will learn about the various matrix reports, including simple, group, and nested matrix reports, and concepts related to them, including the Data Model, Paper Layout, and
Summaries. Next, they will learn about the various triggers, including report, Data Model, and Paper Layout triggers, and concepts related to using them. They will also learn about format triggers and
requirements for using them. They will also learn about guidelines for writing common code, concepts related to event-based reporting and publishing, and database objects and their
parameters. Finally, they will learn about concepts related to SRW packages, including outputting messages, executing a nested report, restricting data and initialization fields, and working with them
to create a table of contents (TOC), to perform DDL statements, and to set and use format attributes.
Participants Will Learn
- Key concepts related to execution of a nested report.
- Key concepts related to outputting messages using the SRW package.
- Identify uses of the SRW package.
- Guidelines for using the PL/SQL group filter.
- Match types of report triggers with their uses.
- Identify features of triggers in reports.
- Sequence the steps to create a matrix report.
- Features of the product order property.
- Identify key concepts of a matrix report.
OracleAS Reports Services, Guidelines
Course Overview
This course covers concepts related to Oracle Reports Developer 10g. Students will learn about the
architecture of relevant Oracle Application Server components in combination with its reports publishing component, OracleAS Reports Services. The course focuses on helping students to
maximize performance in the run-time environment. In addition, students will learn how to build reports to run on various platforms, and in different environments and languages. Finally, they will
also learn to create a Web Layout template.
Participants Will Learn
Sequence the steps to create a template file and an HTML file.
- Key features of investigating the Data Model.
- Identify features of non-SQL data sources.
- Guidelines for tuning reports.
- Match Oracle Application Server components with their features.
- Match methods of requesting reports with their features.
- Identify benefits of running reports using OracleAS Reports Services.
|
