RKG Technologies Oracle Training SAP
SAP Call Call : 949-387-3772
SAP Mail E-mail : info@SONUtraining.com
SAP Training
SAp
SAp
  • State-of-the-art   training facilities
  • Class Room \ E-Learning training
  • Faculty with 10 years of average Apps exp.
  • Project and Hands-on Training
  • 24\7 Support and 90 Days free Access
  • Prepare for ORACLE Certification
  • Apps training - All Functional and Technical
  • Latest Versions of Oracle Applications
  • Placement guaranteed for deserved students
  • SAp
    SAp
    Technical Courses
    Oracle Developer Tools – PL/SQL, Forms, Reports (6i)
     
    Software Version Oracle Developer Tools 6i and 9i
    Course Duration 5 days or 40 Hours Approx.
    Course Type Class Room and On-Line (E-Learning) Instructor-Led Hands-On Training
    Course Overview

    This intensive hands-on Oracle Forms, Reports and PL/SQL training class designed to teach the advanced features for Oracle systems development using Oracle 6i or 9i.  This course also 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 overview.

    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, 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 6i 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 6i Overview
    • Reports Developer
    • Reports Wizard
    • Parameter form
    • Reports Layout Model
    • Report Triggers
    • Reports Output
    • Developing and testing reports
    Understanding Control Blocks
    • Forms Query Text 
    •         
    • Control Blocks       
    •     
    • Blocks based on views 
    •           
    • Block Based on a Procedure
    •            
    • Block Based on FROM Clause Query  
    •          
    • Blocks Based on Transactional Triggers        
    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  
    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             
    Oracle Reports Advanced Topics

     

     

    Oracle Training | Oracle Functional Technical Courses |LA OC Nationwide
    Live Chat
    SAp
    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 Inc is not linked with ORACLE. ORACLE is a trademark of Oracle Corporation.
    Copyright © 2004 RKG Technologies Inc. All rights reserved.