Scrolling MySpace Image Generator                                     Scrolling MySpace Image Generator                                     Scrolling MySpace Image Generator                                     Scrolling MySpace Image Generator                                     Scrolling MySpace Image Generator                                     Scrolling MySpace Image Generator                                     Scrolling MySpace Image Generator                                     Scrolling MySpace Image Generator                                     Scrolling MySpace Image Generator                                     Scrolling MySpace Image Generator                                     Scrolling MySpace Image Generator                                     Scrolling MySpace Image Generator

IT DEPARTMENT - Oracle application development (OCA,OCP) PDF Print E-mail
Article Index
IT DEPARTMENT
Oracle application development (OCA,OCP)
Microsoft Certification Course
Cambridge International Diploma in IT Skills
All Pages

 

 

 

 

 

 

 

 

Oracle application developmen

 

 

 Course Contents : -

 

 · Introduction

· Defining a Relational Database

· Writing a Basic SQL statement

· Restricting and sorting data

· Single row functions

· Displaying data from multiple tables

· Aggregation Data by using group function

· Writing subqueries

· Producing readable output with iSQL * plus

· Manipulating data

· Creating and managing tables

· Including constraints

· Creating views

· Other database objects

· Controlling user access

 

 Oracle 10g –program PL/SQL

 

 

Course contents:-

 

· Introduction

· Describing PL/SQL

· Describing the use of PL/SQL for the developer and the database administrator

· Declaring variables

· Writing executable statements

· Interacting with the oracle server

· Writing control structures

· Working with composite data types

· Writing explicit cursor concepts

· Advanced explicit cursor concepts

· Handling exceptions

· Creating procedures

· Creating functions

· Managing subprograms

· Creating packages

· More package concepts

· Using oracle –supplied packages

· Creating database triggers

· More trigger concepts

 

 Oracle forms developer Internet application

 

Course contents :- 

· Running a forms developer applications

· Working in the forms developer environment

· Creating a basic form module

· Working with data block and frames

· Working with text items

· Creating LOVs and Editors

· Creating Noninput items

· Introduction to triggers

· Producing triggers

· Adding functionality to items

· Runtime messages and alerts

· Query triggers

· Validation

· Navigation

· Writing flexible code

· Creating a menu document

· Managing menu document

· Working with master detail forms

· Creating and attaching library to modules

 

 

 Oracle reports developer

 

Course contents:-

 

· Installing reports tools

· Creating reports using reports builder

· Defining data module for reports

· Specifying the layout of a reports

· Using oracle reports interface

· Creating reports through wizard

· Creating master / detail reports

· Creating parameterized report

 

CLICK HERE



Last Updated ( Wednesday, 03 November 2010 15:02 )