Name of the Course

Database Application Development using Oracle
 

Duration

126 hours (5:00 pm  - 8:00 pm)
 

No. of Participants

20 for each
 

Course Fee

9000/- (Nine thousand only)
 

Designed for

Anyone who is interested to build-up his or her career as Application Developer using state-of the-art database technology Oracle 9i.
 

Course Objective

The objective of the course is to develop expertise in Database Application Development using Object Relational Database Management System Oracle 9i and Oracle 9i Developer Suite as front-end tool. This course will help the participants in meeting various organizational/business/ industrial requirements as well as pursue a career in Oracle database technology.
 

Course Content

Description: The lab intensive course is designed to cover the following:

SQL basics & SQL*Plus including the concepts of both relational & object relational databases and develop the skills to effectively interact with Oracle 9i.

PL/SQL programming language which is able to control data sharing & locking, develop an understanding of multi-user and concurrent transactions, and develop triggers, procedures, functions & packages etc.

Form Builder, which will effectively direct the participants through Application Development from default form generation to custom, menu-driven applications using object-oriented technology.

Report Builder, which will, cover the concepts involved in using the GUI report writer to build reports in various format that include buttons, multimedia and OLE2 object.

Real life project to be developed by the participants with the assistance of Instructor.

The major course outlines are:

Introduction to Oracle 9i and SQL

Fundamentals of Relational Database Management Systems (RDMS)

SQL basics and SQL*Plus

Where and Order By clause

Joining Data from Multiple Tables in Queries

Group Functions and the Group By clause 

Sub queries and CASE clauses

Data Manipulation Language (DML) commands

Data Definition Language (DDL) commands

Data Control Language (DCL) commands

Create Users, Privilege, Roles & Changing passwords

PL/SQL Programming Language

Introduction to PL/SQL and its basics

Working with data files

Selecting multiple rows using Cursors

Exception Handling

Advanced Cursors

Procedures, Functions and Packages

Creating DML triggers

PL/SQL composites data types and collections

Oracle supplied packages

Form Builder

Basic component of Form Builder

Running Form Builder Application

Form Builder Design Interface

Building basic Form Module

Visual Attributes and property classes

Editors and Alert

LOVS and Record Groups

Working with Triggers

Basic Menus

Report Builder

Basic component of Report Builder

Creating Tabular Report

Using the Object Navigator

Data Model Editor, Layout Editor

User -Defined columns

Use of Parameters

Using PL/SQL in Reports

Project Work

A real life project will be developed by participants with the assistance of the Instructor at the end of the course.
 

Training Methodology

Lecture and Practical exercise
 

Evaluation System

* Written test
* Assignment
* Attendance & practice on Computer
 

Facilities

* One person on computer
* Acoustic & air condition class room
* Multimedia Presentation System
* Network based computer lab