Oracle Database

Introduction to Oracle

• Introduction
• Data
• Database
• DBMS & RDBMS

DB Installation

Oracle DB Structure

Schema, Other Objects

SQL Intro

SQL Developer

SQL Query

• Retrieving Data Using SQL Statement
• Restricting and Sorting Data
• Using Single Row Functions to Customized Output
• Using Conventional Functions
• Conditional Expressions
• Reporting Aggregate Data Using Group Functions
• Displaying Data from Multiple Tables Using Joins
• Using Sub Query
• Set Operators
• Manipulating Data
• Using DDL Statements
• Creating Other Schema Objects

Oracle Fusion 11g Forms

• Developer Forms Intro
• Introduction to Oracle Form Builder
• Forms Environment
• Running Oracle Forms
• Create Basic Form
• Create Master Detail Form

Working with Data Blocks

Working with Text Items

Create LOVs and Editors

Create Additional Input Items

Creating Non Input Items

Canvas

• Creating Windows and Content Canvases
• Working with Other Canvas Types

Triggers

• Introduction to Triggers
• Producing Triggers
• Debugging Triggers
• Adding Functionality to Items
• Run Time Messages and Alerts
• Query Trigger

Validation

Navigation

Transaction Processing

Writing Flexible Code

Sharing Objects and Code

Multiple Form Application

Reports

• Introduction to Reports Builder
• Creating Simple Report”
• Reporting Control with Parameters
• Creating Master Detail Report
• Creating Group Wise Report
• Creating Matrix Report