|
| Oracle Developer Tools – PL/SQL, Forms, Reports (10g) |
| |
| Software Version |
10g (10.1.2) |
| Course Duration |
5 Days |
| Course Type |
Class Room and Instructor-Led On-Line (E-Learning) Hands-On Training |
|
| Course Overview |
This course is designed for developing Web-based applications using Forms, Reports and PL/SQ and utilize the web architecture of 10g components, Forms Servlet, Forms Listener, Runtime Engine and the Forms Client and also migrating of existing Reports 6i reports to Oracle Reports 10g. This intensive hands-on Oracle Forms, Reports and PL/SQL training class designed to teach the advanced features for Oracle systems development using Oracle 10g and covers advanced productivity features of Oracle Developer forms and reports including control blocks, functions, stored procedures and triggers, and development of stored procedures, functions and packages using PL/SQL and Oracle AIM methodology and using development standards. This course also gives overview of Oracle Applications. |
| Intended Audience for this course |
This course is designed for those who have technical background, knowledge with any computer language, Java, J2EE, XML, .NET Developers, ERP Developers, Business Intelligence Developers, DBAs, IT management and Staff, Business Analysts, Technical Consultants, Students and also those who want to become Oracle Applications Technical Consultants. |
|
| Course Topics |
|
|
| Introduction to Oracle Applications |
|
- Overview of Oracle E-Business Suite
- Architecture
- Components
- Roles and Responsibilities of a Technical Consultant
- Oracle Application Implementation Methodology (AIM)
|
|
| PL/SQL |
- Overview
- Components and Syntax
- Cursors
- Stored Procedures, Functions and Packages
- Built-in Packages and Functions
- Control Structures
- Database Triggers
- Tips and Techniques
|
|
| Forms |
- Forms Overview
- Forms Designer
- Basics and Terminology
- Layout Editor, Canvases, Windows and Views
- Forms Compiler
- Events and Triggers
- List of Values
- Built-in, Forms Objects and Triggers
- Templates
- Libraries
- Validations, Alerts
- Developing and testing forms
- Exception Handling
|
|
| Reports |
|
- Reports Overview
- Reports Developer
- Reports Wizard
- Parameter form
- Reports Layout Model
- Report Triggers
- Reports Output
- Developing and testing reports
|
|
| PL/SQL Advanced Topics |
|
- Transaction Processing
- Cursor Variables
- Advanced SQL Techniques
- Object-Relational Model
- Tuning
- Control Structures
- PL/SQL Tables and Records
- Overloading features of PL/SQL
- Dynamic SQL
- Database Triggers and server features
- Events and levels
- Objects Dependencies
- Understanding LOBs
- Performance Tips and Techniques
|
|
| Forms 10g Topics |
|
- Benefits of Deploying Forms Applications to the Web
- Streamlining of Oracle Forms – Client-Server Runtime
- Migrating Forms Applications
- Utilizing Forms Services – Servlet, Listener, Runtime engine
- Adapting Features – Key Mapping, Graphics and Images
- Adapting Features – Tabbed Canvases, Mouse Event Triggers
- Client-Server Features – Control Palette, Get_File, VEX, ActiveX
- JavaBeans, PJCs, Web Page, Integrating with Server Portal
|
|
| Reports 10g Topics |
- Building Web Report
- JSP Overview
- Adding dynamic content
- Web Layout Template
- Creating Parameter form
- Using a Key Map File
|
|
| Oracle Forms Advanced Topics |
- Deploying Forms on the Web
- Populating List Items Dynamically
- Master-Detail Relationships
- Populating a List Item with Date and Number Values
- Working with Global Variables
- Changing the Base Table of a Block Dynamically
- Creating Customized Sign-on Form
- Forms 10g new features
|
|
| Oracle Reports Advanced Topics |
|
- Generate HTML/Web Reports
- XML Output
- Using Images
- Reports 10g new features
|
|
|
