➢ 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
Course Contents:
➢ 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
