Oracle Developer Training in Chennai | India

1. Introduction to 11g SQL
• Writing a Basic SQL Statement
• Restricting and Sorting Data
• Displaying Data from Multiple Tables
• Aggregating Data by Using Group Functions
• Writing Subqueries
• Producing Readable Output with iSQL*Plus
• Manipulating Data
• Creating and Managing Tables
• Including Constraints
• Creating Views
• Controlling User Access
• Using Set Operators
• Hierarchical Retrieval
And many more

2. Oracle 11g: Program with PL/SQL
This course is a foundation of basic knowledge, which they can build upon as they work toward a career as an Oracle Application
• Overview of PL/SQL Programs
• Creating Procedures
• Creating Packages
• More Package Concepts
• Creating Database Triggers
• More Trigger Concepts
• Creating Functions
• Managing Subprograms
• Oracle Supplied Packages
• Manipulating Large Objects
• Managing Dependencies
• And many more….

3. Oracle 11g Forms Developer: Builds Internet Application
This course teaches you to develop and deploy Internet applications using Oracle9i Forms. Working in a rapid development environment, participants learn how to customize forms through user input items and how to control data access by creating event-related triggers
• Introduction to Oracle Forms Developer and Oracle Forms Services
• Running a Forms Developer Application
• Working in the Forms Developer Environment
• Creating a Basic Form Module
• Working with Data Blocks and Frames
• Working with Text Items
• Creating LOVs and Editors
• Creating Additional Input Items
• Creating Noninput Items
• Working with Other Canvas Types
• Introduction to Triggers – Producing, Debugging & Adding Function
• Runtime Messages and Alerts
• Query Triggers
• Writing Flexible Code
And many more …