Make your own free website on Tripod.com

Course Outline
Back Home Up Next

 

  Theory

Projects

Articles

 Written Books

Report

Technical Report

Survey Reports

Workshop

Presentations

Tutorials

Algorithms

Contact Me

Yourself

wpe15.jpg (4442 bytes)

INTRODUCTION

Database Concepts
Database Industry
Data Modeling
Dr.F.Codd’sRule
Oracle Products
Job Opportunity
Introduction to Erwin
OCPGuidelines

SQL & PL/SQL

Introduction & Features
Query Instruction
SQL Operation
Operators
Function
Nested Function
Data Manipulation
Creating &Deleting records
Joining Table
Equi Join & Non-Equi Join
Sub Queries
DDL Operation
DML Operation
DCLOperation
Data Constraint
Exceptions, Cursors, Procedure

 ORACLE FORM

Introduction & Features
Navigating developer 2000 Tool Designer
Layout Editor
Canvas Items, Windows, Alerts
Creating simple GUI application
Creating Master –Detail Forms
Running & Compiling Form application
Fill Color, Text Color, Patterns
Introduction to Triggers
Interface Events
Mouse Events
Property Class
LOVs, Visual Attribute
POP-Lists, T-List, Combo Box
Menu Module
Toolbars
Toolbox
OLE Objects
OCX Objects

REPORTS

Introduction & Features
Design Report using Wizard
Working with Layouts Queries
Creating Mailing Label Report
Creating Form Report
Creating Matrix Report

  GRAPHICS

Introduction & Feature of Graphics
Creating Charts
Using Graphics Item