Our Courses

Oracle Forms Certified Professional


Oracle Database 12c: Introduction to SQL Ed 1.1


Audience

  • Data Warehouse Administrator
  • Application Developers
  • Forms Developer
  • Business Analysts
  • Developer
  • PL/SQL Developer
  • System Analysts

Required Prerequisites
Familiarity with data processing concepts and techniques, Data processing


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: Program with PL/SQL


Audience:

  • PL/SQL Developer
  • Application Developers
  • Technical Consultant
  • System Analysts
  • Forms Developer
  • Database Administrators
  • Portal Developer
  • Developer

Required Prerequisites:

  • Oracle Database: Introduction to SQL (combination of Oracle Database: SQL Fundamentals I and Oracle Database: SQL Fundamentals II listed)
  • Suggested Prerequisites
  • Previous programming experience

Course Topics:

  • 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
  • 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
  • PL/SQL Compiler
  • Manage Dependencies


Oracle Forms Developer 10g: Build Internet Applications


Required Prerequisites:
A good familiarity with Graphical User Interface (GUI) Working experience with the Web browser


Audience:

  • Application Developers
  • Forms Developer
  • Support Engineer
  • Developer
  • PL/SQL Developer
  • Technical Consultant

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
  • Validation
  • Navigation
  • Transaction Processing
  • Writing Flexible Code
  • Sharing Objects and Code
  • Using WebUtil to Interact with the Client
  • Introducing Multiple Form Applications


Oracle Reports Developer 10g: Build Reports


Audience:

  • Technical Consultant
  • Business Intelligence Developer
  • Reports Developer

Suggested Prerequisites:
XML: Introduction or equivalent familiarity with basic XML

Course Topics:

  • Introduction to Oracle Reports Developer
  • Designing and Running Reports
  • Exploring Oracle Reports Developer
  • Creating a Paper Report
  • Enhancing a Basic Paper Report
  • Managing Report Templates
  • Creating a Web Report
  • Enhancing Reports Using the Data Model: Queries and Groups
  • Enhancing Reports Using the Data Model: Data Sources
  • Enhancing Reports Using the Data Model: Creating Columns
  • Enhancing Reports Using the Paper Layout
  • Controlling the Paper Layout: Common Properties
  • Controlling the Paper Layout: Specific Properties
  • Web Reporting
  • Extending Functionality Using XML
  • Creating and Using Report Parameters
  • Embedding a Graph in a Report
  • Enhancing Matrix Reports
  • Coding PL/SQL Triggers
  • Extending Functionality Using the SRW Package
  • Maximizing Performance Using OracleAS Reports Services
  • Building Reports: Efficiency Guidelines

REQUEST A CALL BACK Please fill all the texts in the fields.