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











 
ICT Offers
Partnership
Online Training

Oracle

[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
  • DBMS & RDBMS

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

Canvas

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

Triggers

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

Validation

Navigation

Transaction Processing

Writing Flexible Code

Sharing Objects and Code

Multiple Form Application

Reports

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

 

Practical Approach

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

 

www.ict-trainings.com/curriculum/oracle-leaflet.pdf


Training Schedule
Download Full Calendar


26 Jan 2017

MCSE-2012
Thu-Fri-Sat 07:00 PM-09:00 PM


28 Jan 2017

Linux
Sat-Sun 05:30 PM-08:30 PM


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

Contact

Web Development

Java Android

.NET

Graphics Designing

AutoCAD

MCSE 2012

CCNA

CCNP & CCIE

SharePoint 2013

Spoken English

Ms Office

IELTS
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
ict

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