Oracle Forms PL/SQL Developer

Course details

By becoming an Oracle Database PL/SQL Certified Professional, you will be ready to fully exploit the most advanced features of PL/SQL. You will gain thorough knowledge of PL/SQL language, its architecture, features, interactions with the SQL engine, programming constructs and datatypes. Enhance the appearance and functionality of the basic form by using PL/SQL trigger, JavaBeans, and Pluggable Java Components.

Diploma courses :
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

  Updated on 09 August, 2020