+91 937 791 6611 inquiry@iantindia.com

IANT The First & only Platinum partner In India.Is the No.1 Hardware & Networking institute Award Winner in India.

CompTIA | Miscrosoft | Red Hat | EC-Council | Oracle | Cloud Computing | Android


REQUEST A CALL BACK

Please fill all the texts in the fields.


Our Courses

Oracle Forms Certified Professional


Oracle Database 12c: Introduction to SQL Ed 1.1

Audience


  • Data Warehouse Administrator
  • Developer
  • Application Developers
  • PL/SQL Developer
  • Forms Developer
  • System Analysts
  • Business 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

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

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

Oracle Forms Developer 10g: Build Internet Applications

Required Prerequisites:

  • A good familiarity with Graphical User Interface (GUI) Working experience with the Web browser

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

Audience


  • Database Administrators
  • Technical Administrator
  • Support Engineer
  • Technical Consultant

Oracle Reports Developer 10g: Build Reports

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

Audience


  • Technical Consultant
  • Business Intelligence Developer
  • Reports Developer