DBMS

Entities and attributes
Relationships
ER Model
Normalization

SQL

Introduction to SQL
Basic SQL statement
Single Row Functions
Restricting data
Sorting data
Displaying data from multiple tables
Aggregating data using group functions
Sub –Queries
Producing Readable output with SQL Plus
Creating and managing tables
Creating database objects
Manipulating data
Controling user access
Set operators
Date and time functions in Oracle 9i
BY Clause.
Advance Sub-query

PL/SQL

Introduction
Declaring variables
Executable Statements
Interecting with Oracle Server
Control structure
Working with Composite data types
Explicit cursors and advance explicit cursor
Handling exceptions, Creating procedures
Creating functions
Managing sub programs
Package creations
Oracle supplied package
Manipulation large objects
Database Triggers
Managing dependencies

Form 9i

Oracle Forms developer and Form services
Running a form developer application
Working in the form developer environment
Creating a basic form module
Working with data blocks
Working with Frames and text items
Creating LOVs, Editors, input and non input items
Producing and debugging form Triggers
Adding functionality to items
Runtime message and alert
Query triggers, validation, navigation
Transaction processing
Writing flexible code
Sharing codes and objects

Report 9i

Introduction to Oracle 9i reports developer
Designing and running reports
Creating paper report
Managing report templates
Web report
Enhancing reports using data model
Queries ang groups
Data sources
Creating columns
Enhancing report using paper layout