Oracle 10g & D2K

Forms 6i / 10g

Introduction

Advantages, Features and roles in ERP

Pre-requisites

Tools used in D2K

Fundamentals

How to install and work with D2K

Interface of forms

Types of Data Blocks

Manipulating Properties

Creation of Object Groups

Form Triggers

Alerts

Editors

Using image Items

Graphics

Canvases

Windows

Menus

(Developer 2000) Forms and Reports

Program Units

PL/SQL Libraries

Database Objects

Working with Object Technology

Record Groups

LOV's

Advanced Topics of Forms

Error Handling

Reports 6i / 10g

Introduction

Advantages, features and roles of Reports in D2K

Fundamentals of Reports

Interfaces of Reports

Creation of Reports using Wizards

Creation of Reports Manually

Manual Reports

Report Triggers

Creation of Templates

Communication / Interlinking of Forms & Reports

Oracle SQL & PL/SQL

Oracle 10g / 11g

Introduction

Introduction to DBMS

Approach to Data Management

Introduction to Pre-requisites

File and Filesystem

Disadvantages of file

Introduction to Database

Database Models

Hierarchal Model

Network Model

Relational Model

Introduction to RDBMS

SQL

Sub Language Commands

Introduction to SQL Database Objects

Working with DML, DRL commands, Operator support

Built-in Functions

Grouping the result of a query

Querying multiple tables

Working with Sub-Queries

Oracle SQL & PL/SQL

Integrity Constraints

Working with DCL, TCL commands

Maintaining Database Objects

PL / SQL

Introduction to PL/SQL

The Advantages of PL/SQL

PL/SQL Architechture, PL/SQL Data Types

Advanced PL/SQL

Advanced Version Features

Implementing Object Technology

Using LOB's

Using Collections

Oracle Database Architechture