Oracle Forms Developer
(Total Course Duration: 120 hours)
Oracle
Forms is a software product for creating screens that
interact with an Oracle database. It has an IDE including an object navigator,
property sheet, and code editor that uses PL/SQL. It was originally developed
to run server-side in character mode terminal sessions
This
course contains the following sections:
- Oracle Database 12c: Introduction to SQL
- Oracle Database: Program with PL/ SQL
- Oracle Forms Developer: Build Internet Application
Oracle Forms Developer
Course Outline (Total Training Duration: 120 hours)
Oracle Database 12c: Introduction to SQL (40 Hours)
- Retrieve Data using the SQL SELECT Statement
- Restricting and Sorting Data
- Usage of Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Reporting Aggregate Data Using the Group Functions
- Displaying Data from Multiple Tables Using Joins
- Using Sub-queries to Solve Queries
- Using the SET Operators
- Managing Tables Using DML Statement
- Introduction to Data Definition Language
- Introduction to Data Dictionary Views
- Creating Sequence, 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: Program with PL/ SQL:(40Hours)
- Introduction to PL/SQL
- Declare PL/SQL Identifiers
- Write Executable Statements
- Interaction with the Oracle Serve
- Control Structures
- Composite Data Types
- Explicit Cursors
- Exception Handling
- Stored Procedures
- Stored Functions and Debugging Subprograms
- Packages
- Deploying Packages
- Implement Oracle-Supplied Packages in Application
Development
- Dynamic SQL
- Design Considerations for PL/SQL Code
- Triggers
- Creating Compound
- DDL And Event Database Triggers
- Creating Compound
- DDL and Event Database Triggers
- PL/SQL Compiler
- Manage PL/SQL Code
- Manage Dependencies
Oracle Forms Developer: Build Internet Application:(40Hours)
- 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
- Validation
- Navigation
- Retrieve Data using the SQL SELECT Statement
Upcoming Training Schedule on Oracle Forms Developer:
| Course Name | Duration | Class Days | Time Slot | Starting Date |
| Oracle Forms Developer | 120 Hours | Friday & Saturday | Fri (9.00 am to 1.00 pm) Sat (6 pm to 9 pm) | 03.05.2024 |
