CLS Learn Oracle Forms Developer 12C Certified Professional CLS Learn
Price: AED 1,227
  • Timings: Part Time, Weekends

Course details

  Oracle Database 12c: Introduction to SQL

Course Topics :
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 Database 12c: Program with PL/SQL

Course Topics :

Working with Oracle Cloud Exadata Express Cloud Service
Introduction to PL/SQL
Declare PL/SQL Variables
Write Anonymous PL/SQL Blocks
SQL Statements in a PL/SQL block
Control Structures
Composite Data Types
Explicit Cursors
Exception Handling
Stored Procedures
Stored Functions
Debugging Subprograms
Deploying Packages
Implement Oracle-Supplied Packages in Application Development
Dynamic SQL
Design Considerations for PL/SQL Code
Creating Compound
DDL and Event Database Triggers
PL/SQL Compiler
Manage Dependencies

Oracle Forms developer: Build Internet Applications  

 Course Topics :
Introducing Oracle Forms Developer and Forms Services
Creating Forms Modules
Working with Data Blocks and Frames
Working with Input Items
Working with Non Input Items
Working with Windows and Canvases
Producing Triggers
Debugging Triggers
Adding Functionality to Items
Run-Time Messages and Alerts
Query Triggers
Transaction Processing
Sharing Objects and Code
Using WebUtil to Interact with the Client
Introducing Multiple Form Applications

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms​​​​​​​

Course Topics :

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
Producing and Debugging Triggers
Adding Functionality to Items
Displaying Run-Time Messages and Alerts
Using Query Triggers
Validating User Input
Controlling Navigation
Overriding or Supplementing Transaction Processing
Writing Flexible Code
Sharing Objects and Code
Using WebUtil to Interact with the Client
Introducing Multiple Form Applications Updated on 01 April, 2019

Eligibility / Requirements

Suggested Prerequisites
Familiarity with data processing concepts and techniques
Data processing

Job roles this course is suitable for:

Data base developer , Trainer for Programming , developer

About CLS Learn

CLS help and support the Egyptian market , cooperate, individuals and universities to Learn various technology products and acquire new potentials and advance in their career.
CLS is an Authorized training center of :
• Microsoft Certified Gold Learning Solution GOLD CPLS
• Oracle Training Partner WDP
• EC Council Accredited Training Center
• Cisco Certified learning Partner
• Adobe Authorized Training Center
• Autodesk Authorized Training Center and Certification center
• Exin ITIL Authorized training Provider and certification provider
• Authorized Pearson VUE testing centers
• Authorized Prometric testing centers

CLS is a Microsoft Gold Learning Solutions Learning Solution.
CL is An award winning Training center from EC-Council : Circle of Excellence award.
CLS is an Accredited Learning Solution from Microsoft , Oracle , Cisco , EC-Council , Adobe , Autodesk , Pearson VUE and Prometric.
CLS Founders and Managers Team has over 21 Years of Experiencein the Training industry since 1995.
CLS Team has trained over 1,000,000 trainess and 1500 Company.
CLS instructors are the best certified professional instructors in Egypt with reliable working experience.

See all CLS Learn courses

Enquire about this course

You may add more courses here,
your list will be saved.

Rate this page