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

Contact us for help, additional info or assistance and we'll be with you in no time!

Enter your name
Enter your email
Enter your mobile no
Enter your City
Nearest Center
Your message
ArrowUp