RKG Logo training-ITBiz
RKG Logo
Home Courses Fees Schedule REGISTER NOW Corporate Training Locations
Microsoft Office Tools
Adobe Acrobat Courses
SharePoint Training
Microsoft Dynamics
Social Media Courses
Project Management
Application Devp Tools
Oracle Developer Tools
Data Warehouse & BI
Data Base & System Admin
Programming Languages
Reporting Tools
Networking & Security
Web Technologies
Medical Records
Business Skills
ERP Training
Corporate Training On-Site
Oracle Developer Tools – 10g
Oracle Dev Tools 10g
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)
  • Overview
  • Components and Syntax
  • Cursors
  • Stored Procedures, Functions and Packages
  • Built-in Packages and Functions
  • Control Structures
  • Database Triggers
  • Tips and Techniques
  • 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 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

Enroll Online   

Live Chat
Enroll Online
Enroll By Fax
Fee & Schedule
Send Message
Follow us on .....
For further information call 949-387-3772 or FAX 949-681-8247 or email to info@SONUtraining.com
SONU Training is the training wing of RKG Technologies Inc
Disclaimer: RKG Technologies is not linked with Microsoft, Oracle, Adobe, IBM or any other software company we provide training
Copyright © 2004 RKG Technologies Inc. All rights reserved.