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