Oracle 10g D2K Course

D2K (Developer 2000) Forms and Reports

Forms 6i / 10g

• Introduction

• Pre-requisites

• Advantages, Features and roles in ERP

• How to install and work with D2K

• Tools used in D2K

• Fundamentals

• Interface of forms

• Types of Data Blocks

• Manipulating Properties

• Creation of Object Groups

• Form Triggers

• Menus

• Windows

• Alerts

• Using image Items

• Editors

• Graphics

• Canvases

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 supports

• 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 Architecture, PL/SQL Data Types

• Advanced PL/SQL

• Advanced Version Features

• Implementing Object Technology

• Using LOB

• Using Collections

• Oracle Database Architecture