Oracle 10g Reports Developer: Build Reports – Institute of Software Technologies

Oracle 10g Reports Developer: Build Reports

Oracle 10g Reports Developer: Build Reports

This course introduces the student on how to build complex and sophisticated reports from any data source, in any format, using Oracle Reports Developer. You will learn to deploy the reports using OracleAS Reports Services.

Working in the declarative environment of Reports Builder, you will 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, you will learn how to add dynamic content to a static Web page and publish reports to the Web and how to customize more complex reports, embed graphical charts, and use OracleAS Reports Services to deploy the reports.

Suggested Prerequisite

  • XML: Introduction or equivalent familiarity with basic XML

What you will learn:

  • Use report parameters and customize a runtime parameter form
  • Enhance reports using graphs and PL/SQL trigger code
  • Maximize report performance using OracleAS Reports Services and tune reports
  • Publish a report on the Web and build reports to run in various languages
  • Manage report templates, create mailing labels and letters
  • Identify the main components in a report document and how they are related
  • Identify the differences between Web and paper reports
  • Identify standard report design styles and run existing reports to various output destinations
  • Create and modify basic tabular reports and high quality Web reports
  • Create other report styles such as break reports and matrix reports
  • Create reports by accessing data from various data sources
  • Add dynamic data to an existing HTML page

This course covers the following;

  • Introduction to Oracle Reports Developer
  • Designing and Running Reports
  • Exploring Oracle Reports Developer
  • Creating a Paper Report
  • Enhancing a Basic Paper Report
  • Managing Report Templates
  • Creating a Web Report
  • Enhancing Reports Using the Data Model: Queries and Groups
  • Enhancing Reports Using the Data Model: Data Sources
  • Enhancing Reports Using the Data Model: Creating Columns
  • Enhancing Reports Using the Paper Layout
  • Controlling the Paper Layout: Common Properties
  • Controlling the Paper Layout: Specific Properties
  • Web Reporting
  • Extending Functionality Using XML
  • Creating and Using Report Parameters
  • Embedding a Graph in a Report
  • Enhancing Matrix Reports
  • Coding PL/SQL Triggers
  • Extending Functionality Using the SRW Package
  • Maximizing Performance Using OracleAS Reports Services
  • Building Reports: Efficiency Guidelines

This course prepares you for the following certifications:

  • Oracle PL/SQL Developer Certified Associate Certification

How you will be assessed?

Theory
50%
Practical
50%
Exam
50%

Deadline

7th Feb 2020

Deadline

7th March 2020

Deadline

7th Sept 2020