Institute Address :

B1, 3rd Floor, Eureka Court,
Near Image Hospital, Ameerpet,
Hyderabad, India

Contact Details:

Phone No : 91+7207070872 / 9700446467
Email ID : onlinetrainingfromindia@gmail.com
onlinetraining@onlinetrainingfromindia.com

Online Training Enquiry Form

Security-Code reload security code

D2K (Developer 2000) Forms and Reports

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

racle 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
Online Training