Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: Serebra Learning Corporation

Oracle Reports: Enhancing Reports

Click here for more information or to take this course
Serebra Learning Corporation


  home  : Computer  : Oracle  : Report Builder

Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by Serebra Learning Corporation

This course is the second in a three-part Oracle Reports series that is based on Oracle Reports Release 6. The goal of this course is to enable developers to construct complex reports and charts using Oracle Reports. This course introduces the learner to the key features of the Data Model editor Layout Model objects and their properties. The course also enables the learner to enhance matrix reports by modifying the objects in Data Model editor and the Layout Model editor. This course is based on Oracle's ILT course Oracle Developer: Build Reports.


Training Avaliability and Delivery

This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Schedule:8 hours
Training Presented in:English

Related Keywords:  oracle reports 

Training Program Details


Audience

Application Developers Database Administrators Designer/Developers and Technical Support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). In addition participants should have taken the first part in this series Oracle Reports: Reports Fundamentals (course 62221).

Objective

  • Enhance a report by modifying properties of a query changing group structure and filtering data in a group.
  • Build a report by creating queries.
  • Enhance a report by creating columns.
  • Identify the sections of the Layout Model.
  • Identify the components in the Data Model view.
  • Control the common layout properties.
  • Create a link file.
  • Identify the objects in the Data Model and the Layout Model to enhance matrix reports.
  • Create nested matrix reports.

Topics Include

Unit 1: Data Model

  • Match the Data Model objects with their characteristics.
  • Change the structure of a group using the Data Wizard.
  • Identify the methods of ordering data in a group.
  • Create a group filter by using the Property Palette dialog box.
  • Add new data to a report by creating a query using the Data Wizard.
  • Match Oracle8 object columns and ref columns with their representation in reports.
  • Create an external query by using the Object Navigator.
  • Create ref queries by using the ref cursor query tool.
  • Modify the properties of a query using Property Palette option in the Data Model.
  • Create a data link between objects by using the link tool in the Data Model.
  • Modify the database column to display the contents of a file by using the property palette.
  • Identify the properties of a summary column.
  • Create a formula column using the tool palette in the Data Model.
  • Identify the uses of placeholder column.

Unit 2: Layout Model

  • Identify the properties of the Layout Model sections.
  • Match the Layout Model views with their properties.
  • Create a default layout for a report by using the Report Wizard.
  • Sequence the steps to create a default layout for a section of the report by using the Report Wizard.
  • Display the layout view for a report section by using the section option.
  • Apply conditional formatting to a layout object by using the Format option.
  • Set properties for a report section by using the Property Palette.
  • Add a new layout section to a report without overriding existing layouts by using the Report Wizard.
  • Identify the situations in which layout mode buttons are used to facilitate layout modifications.
  • Move a child object outside its enclosing parent object by using the Confine Mode button.

Unit 3: Layout Object Properties

  • Create a link file to display file contents in the Layout Model by using the tool palette.
  • Create a chart using the Chart Wizard in the Layout Model.
  • Embed an existing chart in the Layout Model using the tool palette.
  • Display a multimedia file using a button.
  • Match the pagination properties with their functions.
  • Match the print properties with their functions.
  • Identify the uses of field properties.
  • Identify functions of the repeating frame properties.

Unit 4: Matrix Report Enhancements

  • Match the matrix structure with the relevant Data Model objects.
  • Match the matrix structure with the relevant the Layout Model objects.
  • Identify the product order values to be set for creating matrix summaries in a given situation.
  • Create a cross product group to build a nested matrix using the tool palette.
  • Create a nested matrix summary for a report by using the Report Wizard.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

  • At least a 486DX 33Mhz CPU.
  • Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
  • At least 8MB RAM.
  • At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
  • At least a double speed CDROM drive.
  • An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
The network version of this course requires:
  • At least a 486DX 33Mhz CPU.
  • Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
  • At least 8MB RAM and 22MB available hard disk space or file server space.
  • At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

Web Based Training


Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC    V3W 1K5 Canada

About Serebra Learning Corporation - Training Provider

Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...

More Oracle Reports Training from Serebra Learning Corporation

Click here for more information or to take this course

Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links


Connecting people who want to learn with people who love to teach
 Are you an Oracle reports training provider?
You could be on this page today - for FREE!