PROGRAMMING AND APPLICATION DEVELOPMENT IN SQL/PLSQL

Oracle SQL*PLUS : Programming in SQL and PL/SQL
Back to Main Page

Course Description

This course covers SQL and PL/SQL development using SQL*PLUS for Oracle database. In addition to designing SQL*PLUS reports, create Oracle procedures, functions and packages using PL/SQL program logic, trainees would learn to create and interact with database objects as well as create programs using Oracle Procedure Builder.

Course Objectives

Create and deploy SQL*PLUS reports and PL/SQL programs using Oracle Procedure Builder

Write program logic in PL/SQL and distinguish it with database level logic

Create and integrate reports to Forms based applications

Master Oracle8i/9i New Features

Intended Audience

Beginners to the Oracle RDBMS technology and front-end application development

Prerequisites

Windows and notpad/wordpad

Course Contents

Oracle SQL/PLSQL

A. Introduction

Client/Server Technology and GUI programming Fundamentals

B. Database Fundamentals

How to design a good database (a real industrial case study)
Tools for application development
Application components

C. SQL basic

Creating Databases
Creating Tables& Creating Indexes
Deleting Databases and Database Objects
Adding, Changing, and Removing Data
Changing Existing Data: UPDATE
Removing Data: Delete
Load data from flat file into Tables
Retrieve data from the database

D. Write Complex Queries

Subqueries
Single-row Subqueries and Multiple-value Subqueries
Write Correlated Subqueries

E. Develop SQL*PLUS Report and Formatted Data Files

Hierarchical Structure Report
Dynamic Reports
Create SQL Script Files
Create Formatted Data Files

F. Stored-Programs and Database Triggers

PL/SQL Basic
Stored-Functions and Stored-Procedures
Commit and Rollback Logic
PL/SQL Packages

G. Menus

Analyze and edit the default menu
Creating custom menus
Integrate menus with multiple forms

H. Libraries & Debugger

Create and use libraries with forms’ applications
Use the debugger to aid application development

Oracle Reports 2.5

A. Introduction

Scope of Oracle Reports

B. Getting Started with Oracle Reports

A sample report application
Reports environment and components
Reports development tools

C. Developing Reports

Data models, queries and groups
Layouts and modifications(data/visual)
Creating master-detail reports
Incorporating external data & objects
Using triggers, summary and formula columns
Creating a break report
Form, matrix, mailing label and other reports

D. Integrating Oracle Reports &Forms

Issues in integrating Oracle forms and reports

Oracle8i New Features

Multple Columns PL/SQL Table
User Define Type and Objects
Cost Base Performance Tuning