OBJECT ORIENTED RELATIONAL DATABASE MANAGEMENT SYSTEM THROUGH ORACLE
FMS [ File Management System ]
Introduction to FMS Concept
Languages using FMS?
Advantage of File Management?
Disadvantages of FMS in current environment
Database Management System Software
Effectiveness of DBMS over File management system,
environment , applications based on it, Disadvantages
of it in the current environment.
Relational DataBase Management System Software
Advantages over FMS & DBMS
Codd Rules by Dr. E.F.Codd
Normalization and de-normalization process
Entity Relationship Diagrams
Object oriented relational database Management system
Structure Query Language
Data definition language, Data manipulation language,
Transaction control language, Data control language
ORACLE : Powerful OORDBMS SOFTWARE
Environment of GUI and CUI for oracle
Database , user authentication , login process.
Basic commands to adjust screen & view contents in login.
Different types of datatypes available in oracle, their limitations.
Table creation, Insertion operation, viewing
Modifying and removal process
Displaying by analyzing and ordering the contents.
Alteration of table
Joins and sub queries
View and index usage
Locks and synonyms
Creation of user , system privileges and table
privileges with grant and revoke command.
Sql star plus commands and functions.
Introduction to prgramming language environment,
programm writing and execution
Datatype and general programs in PL/SQL
Cursor concept, advantages and usage,
Procedures and operators used like in, out , in out and
calling programs for procedures
Exceptional handling in programs.
Functions creation and usage
Packages and Triggers
Advance oracle concept
Implement abstract datatype in table
Performing General operation on table having
Object view Creation
Performing Select,insert,delete and update on
Varray creation and insertion and display
Performing operation on table having nested table
Object views with refs
Test Your Knowledge with our OnLine Exam