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