ATA-/MA

American Technical Academy- Middle-East Affiliate

Computer Training and Education Division.

Course Title: Oracle 8.0 & Developer 2000

Course Summary: This course prepares the participants to design & develop Client/ Server Database applications. Itr also mnakes you capable of developing web based application on Intertnet/Interanet Environment.

The course covers general database concepts, in partifular the Relational and Object Oriented concepts of Oracle 8.0, the Internal Architecture & Proxcesses involved in the working of OraCLE 8.0, Sql &PL/SQL in SQL *Plus environment. Finally, the GUI front end Developer 2000 tools are used to come up with applications with native lookk & feel of windows.

Oracle 8.0 and Developer /2000

ORACLE 8.0

Section A: Introduction to Database Management System.

1. Introduction to File Processing System & Evolution of Database Management System.
   • File Processing systems (Traditional Data Management)
   • Problems associated with the above mentioned system
   • The centralised Database approach
   • Data Abstraction

2. Data Models
   • Object-Based Logical Models (Entity-Relationship Model)
   • Record-Based Logical Models (Relational, Network & Hierarchical Model)
   • Physical Data Models

3. Data base System Structure
   • DDL,DML
   • Data Dictionary
   • Database Manager
   • Database Administrator
   • Database Users
   • Overall system Structure

4. Relational Databases
   Structure of Relational Databases
   • Problems faced in Relational Database Design
   • Normalization (A Database Design Technique)
   • CODD's rule for a fully functional System

5. Object Relational Database
   • OOPs Concept
   • Use of Objects
   • Objects & Methods