ORACLE
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
Client-Server Technology.
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
Set commands.
Locks and synonyms
Creation of user , system privileges and table
privileges with grant and revoke command.
Sql star plus commands and functions.
Pl/Sql
Introduction to prgramming language environment,
programm writing and execution
Datatype and general programs in PL/SQL
Cursor concept, advantages and usage,
reference cursor
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
Abstract Datatype
Implement abstract datatype in table
Performing General operation on table having
Abstract types
Object view Creation
Performing Select,insert,delete and update on
object views
Varray creation and insertion and display
Nested Table
Performing operation on table having nested table
Object tables
Object views with refs
Test Your Knowledge with our OnLine Exam