Oracle Forms PL/SQL Developer

Oracle 12c Introduction to SQL ( 40 Hours )
Oracle 12c Program with PL/SQL ( 40 Hours )
Oracle Fusion Middleware Build Applications with Oracle Forms ( 40 Hours )
 

Oracle 12c Introduction to SQL:
Introduction
Retrieving Data using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables Using Joins
Using Subqueries to Solve Queries
Using the SET Operators
Managing Tables using DML statements
Introduction to Data Definition Language
Introduction to Data Dictionary Views
Creating Sequences, Synonyms, Indexes
Creating Views
Managing Schema Objects
Retrieving Data by Using Subqueries
Manipulating Data by Using Subqueries
Controlling User Access
Manipulating Data
Managing Data in Different Time Zones
Oracle 12c Program with PL/SQL:

Introduction
Introduction to PL/SQL
Declare PL/SQL Identifiers
Write Executable Statements
Interaction with the Oracle Server
Control Structures
Composite Data Types
Explicit Cursors
Exception Handling
Stored Procedures
Manage Dependencies
Oracle Fusion Middleware 11g Build Applications with Oracle Forms

Running a Forms Application
Working in the Forms Builder Environment
Creating a Basic Form Module
Creating a Master-Detail Form
Working Data Blocks and Frames
Working with Text Items
Creating LOVs and Editors
Creating Additional Input Items
Creating Noninput Items
Creating Windows and Content Canvases
Working with Other Canvas Types