NEO ΕΠΙΔΟΤΟΥΜΕΝΟ ΠΡΟΓΡΑΜΜΑ ΑΝΕΡΓΩΝ 18-24 ΕΤΩΝ
8. ORACLE 9i REPORTS DEVELOPER : BUILD REPORTS

ΣΚΟΠΟΣ ΣΕΜΙΝΑΡΙΟΥ  

Στο σεμινάριο αυτό οι συμμετέχοντες δημιουργούν μια ποικιλία εκτυπωτικών και τα εκτελούν σε περιβάλλον client-server και περιβάλλον Διαδικτύου. Δουλεύοντας σε γραφικό περιβάλλον, οι συμμετέχοντες μαθαίνουν να ανακτούν, να παρουσιάζουν και να διαμορφώνουν δεδομένα σε διάφορα εκτυπωτικά στύλ. Μαθαίνουν επίσης να παραμετροποιούν πιο πολύπλοκα εκτυπωτικά, να εισάγουν γραφήματα και να χρησιμοποιούν τα Reports Services.

ΣΕ ΠΟΙΟΥΣ ΑΠΕΥΘΥΝΕΤΑΙ  

Αναλυτές εφαρμογών και Αναλυτές διαδικτυακών εφαρμογών

ΣΤΟΧΟΙ ΤΟΥ ΠΡΟΓΡΑΜΜΑΤΟΣ

  • Δημιουργία και μορφοποίηση αναφορών χρησιμοποιώντας διάφορα εκτυπωτικά στύλ
  • Διαχείριση προτύπων αναφορών
  • Δημιουργία και ενσωμάτωση διαγράμματος σε μια αναφορά
  • Εκτέλεση ενός εκτυπωτικού σε Web

ΘΕΜΑΤΑ ΣΕΜΙΝΑΡΙΟΥ  

Introduction to Oracle9i Reports Developer
What is Business Intelligence
Enterprise Reporting: Issues and Challenges
Web Publishing and Paper Publishing
What is Oracle9i Reports Developer
Key Features
Benefits
Oracle9iAS Reports Services

Designing and Running Reports
Designing Reports: Recognizing User Requirements
Selecting Report Styles
Retrieving and Sharing Data
Running a Report
Viewing Report Output

Working in Oracle9i Reports Developer
Reports Executables
Types of Report Builder Modules
Report Builder Components
Object Hierarchy

Creating a Paper Report
Invoking Reports Builder
Creating a Paper Report using the Report Wizard
Modifying a Report Using the Report Wizard
Adding Summaries
Choosing Templates
Generating Output

Enhancing a Basic Paper Report
Enhancing a Paper Report Using the Paper Design View
Aligning Columns
Setting Format Masks
Manipulating Objects
Changing Text
Modifying Visual Attributes
Creating Format Exceptions
Inserting Page Numbers, Current Date, and Time

Managing Report Templates
Using a Report Template for Paper Reports
Modifying a Predefined Template
Registering a Customized Template

Creating a Web Report
Using JavaServer Page Technology to Build Web Reports
Creating a Web Report Using the Report Wizard
Examining the Source Code Using the Web Source View
Previewing a Report on the Web

Enhancing Reports Using the Data Model: Queries and Groups
The Data Model Objects
Creating Groups Manually
Ordering Data in a Group Using the Break Order Property
Eliminating Data from a Group Using a Group Filter

Enhancing Reports Using the Data Model: Data Sources
Using Pluggable Data Sources
Creating a Query Using the Data Wizard
Creating a REF Cursor Query
Linking Data from Multiple Queries Using a Data Link

Enhancing Reports Using the Data Model: Creating Columns
Creating a File Column
Creating a Summary Column
Creating a Formula Column
Creating a Placeholder Column

Enhancing Reports Using the Paper Layout
Identifying Paper Report Sections
Distributing a Report to Various Destinations
Bursting on a Repeating Group
Designing Multipanel Reports
The Layout Model Objects
Creating a Tabular Report with Variable-Length Vertical Lines

Controlling the Paper Layout: Common Properties
Modifying Common Layout Properties
Using Format Triggers
Modifying Web Setting Properties

Controlling the Paper Layout: Specific Properties
Controlling the Print Direction of a Repeating Frame
Controlling Pagination of a Repeating Frame
Controlling Spacing Between Records
Creating New Fields in the Layout and Modifying Properties
Creating a File Link to Display File Contents

Web Reporting
High Quality Web Publishing
Building Reports for the Web
Adding Dynamic Content to a Web Page
Using a Report Block
Customizing Reports for the Web

Extending Functionality Using XML
Using XML as a Data Source
Why Use XML Report Definitions
Building Reports Using XML
Applying Runtime Customizations
Applying Batch Updates

Creating and Using Reports Parameters
Creating User Parameters
Referencing User Parameters
Creating Lists of Values for Parameters
Creating a Parameter Form Layout
Customizing the Parameter Form Layout
Creating Parameter HTML Extensions

Embedding a Graph in a Report
Creating and Embedding a Graph Using the Graph Wizard
Restricting Graph Data with a User Parameter
Customizing a Graph in a Web Report
Using Graph Hyperlinks

Enhancing Matrix Reports
The Matrix Data Model
The Matrix Paper Layout
Creating Matrix Summaries
Creating a Nested Matrix Report Using the Wizards
Displaying Zeros in Cells with No Value

Coding PL/SQL Triggers
Trigger Types
Creating Report Triggers
Creating Data Model Triggers
Creating Layout Triggers
Writing Common Code
Server-Side Code
Event-Based Reporting

Extending Functionality Using the SRW Package
Contents of the Report Builder Built-in Package
Outputting Runtime Messages
Managing Temporary Tables
Modifying Visual Attributes

Maximizing Performance Using Oracle9iAS Reports Services
Why Use Oracle9iAS Reports Services?
Report Request Methods
Oracle9iAS Reports Services Architecture
JSP Runtime Architecture
Servlet Runtime Architecture
Viewing and Scheduling Reports
Managing and Monitoring Oracle9iAS Reports Services

Building Reports: Efficiency Guidelines
Investigating Performance Issues
Tuning Oracle Reports
Building for Other Languages

ΕΚΠΑΙΔΕΥΤΙΚΕΣ ΜΕΘΟΔΟΙ

  • Πλήρως εξοπλισμένο εργαστήριο Η/Υ με εγκατεστημένο το περιβάλλον της Oracle
  • Εκπαιδευτική Μεθοδολογία και πρότυπα της Oracle
  • Επίσημο εκπαιδευτικό υλικό της Oracle (βιβλία, οπτικοακουστικό υλικό, εργαστηριακές ασκήσεις)
  • Έμπειροι εισηγητές με πολυετή εργασιακή και διδακτική εμπειρία

ΔΙΑΡΚΕΙΑ

40 ώρες