Skype | Facebook | Google+ | Home | Sitemap | Contact us | +92 321 3499131

ICT Offers
Online Training


[Download Outline]

Oracle Course Outline

Oracle training curriculum is carefully designed to meet the requirements of most development jobs and build the strong understanding of Oracle.


Introduction to Oracle

  • Introduction
  • Data
  • Database

DB Installation

Oracle DB Structure

Schema, Other Objects

SQL Intro

SQL Developer

SQL Query

  • Retrieving Data Using SQL Statement
  • Restricting and Sorting Data
  • Using Single Row Functions to Customized Output
  • Using Conventional Functions
  • Conditional Expressions
  • Reporting Aggregate Data Using Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Using Sub Query
  • Set Operators
  • Manipulating Data
  • Using DDL Statements
  • Creating Other Schema Objects

Oracle Fusion 11g Forms

  • Developer Forms Intro
  • Introduction to Oracle Form Builder
  • Forms Environment
  • Running Oracle Forms
  • Create Basic Form
  • Create Master Detail Form

Working with Data Blocks

Working with Text Items

Create LOVs and Editors

Create Additional Input Items

Creating Non Input Items


  • Creating Windows and Content Canvases
  • Working with Other Canvas Types


  • Introduction to Triggers
  • Producing Triggers
  • Debugging Triggers
  • Adding Functionality to Items
  • Run Time Messages and Alerts
  • Query Trigger



Transaction Processing

Writing Flexible Code

Sharing Objects and Code

Multiple Form Application


  • Introduction to Reports Builder
  • Creating Simple Report"
  • Reporting Control with Parameters
  • Creating Master Detail Report
  • Creating Group Wise Report"
  • Creating Matrix Report


Practical Approach

  • A real-time examples will be given throughout the lectures, starting from design, analysis, implementation and maintenance of network.

Training Schedule
Download Full Calendar

23 Sep 2017

.NET Web Applications
Sat-Sun 03:00 PM-07:30 PM

C Sharp
Sat-Sun 03:00 PM-05:00 PM

Sat-Sun 03:00 PM-05:00 PM

25 Sep 2017

Digital Marketing
Mon-Wed 07:30 PM-09:00 PM

Spoken English
Mon-Tue-Wed-Thu 06:00 PM-07:00 PM

Web Development
Mon-Tue-Wed 06:00 PM-07:30 PM

Ms Office
Mon-Tue-Wed 10:00 AM-11:30 AM

Web Designing
Mon-Tue-Wed-Thu 06:00 PM-08:30 PM

Quick Links
Web Designing & Development Android Mobile App Development SEO Internet Marketing MCSE CCNA CCNP


Web Development

Java Android


Graphics Designing


MCSE 2012



SharePoint 2013

Spoken English

Ms Office

ICT Trainings facebook Icon ICT Trainings Twitter Icon ICT Google Plus Icon ICT Trainings Google Plus Icon ICT Trainings linkedin Icon
Coming Soon ICT Trainings App!
ICT Trainings - iTunes App ICT Trainings - Google Play App

© Copyright 2007-2017 - ICT Trainings - All rights reserved.
Designed by Creative.