HOME / ORACLE FORMS

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 Database 12c: Admin, Install and Upgrade Accelerated

Corse Objectives

  • Install Oracle Database 12c software
  • Upgrade database to Oracle Database 12c
  • Create an Oracle Database
  • Monitor the Database
  • Manage Database Performance
  • Implement Database Auditing
  • Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks
  • Schedule Jobs to Run Inside or Outside of the Database
  • Configure your Database for Backup and Recovery Operations
  • Describe Oracle Database Architecture
  • Manage the Oracle Database Instance
  • Manage Oracle Database Storage structures
Quick Inquiry
Data Item 2