COURSE CONTENTS

INTRODUCTION 

• Different Types Of DBMS
• Advantages and Disadvantages Of RDBMS
• Codd;s rules
• Client/ Server Concepts

SQL

• Terminology
• Types of SQL statements
• Data Types
• Using Special Formats with the Data Type

SQL* PLUS

• Joining Tables
• Formatting Options

PL/SQL

• Terminology
• Usage
• Data Types
• Operators
• Variables
• Structure of PL/SQL
• Cursors 
• Error Handlings

ORACLE * FORMS 4.5

• Introduction to Oracle* 

Forms 4.5

• The Object Navigator
• Working with the Item
• The Layout Editor
• Working with Form Modules
• Block and Form Relations
• Property Sheet
• Windows and Canvas Views
• Additional Form Objects
• Windows Extensibility Features
• Events And Triggers
• Using PL/SQL in Forms 4.5
• System Variables
• Timers
• Property Class and Object
• Groups and Visual Attributes
• Creating a Library Module
• Creating a Menu Module

ORACLE * REPORTS

• ORACLE Reports Designer
• Object Navigator
• Settings Preferences
• Designer Components

DATABASE ARCHITECTURE 

• Database Process
• Log Files

SQL * DBA

• Functions of DBA
• Performance Tuning

SQL * Menu

• Usage
• Structure
• Application

BACK