Oracle 10g & D2K Online Training
Course Duration : 60 Hrs
Oracle 10g & D2K Course Content
D2K (Developer 2000) Forms and Reports
Forms 6i / 10g Course Contents :
D2K (Developer 2000) Forms and Reports Course Content :-
- 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