Oracle 10g D2k Online Training Hyderabad India

Forms 6i / 10g Course Contents:

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

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