Institute Address :

B1, 3rd Floor, Eureka Court,
Near Image Hospital, Ameerpet,
Hyderabad, India

Contact Details:

Phone No : 91+7207070872 / 9700446467
Email ID : onlinetrainingfromindia@gmail.com
onlinetraining@onlinetrainingfromindia.com

Online Training Enquiry Form

Security-Code reload security code

Oracle 9i Online Training
Course Duration - 35hrs

DBMS
  • Concepts of DBMS
  • Introduction
  • Importance and Need
  • Database Models and Normalization
  • Relational
  • Object
  • Normalization Techniques
Introduction to RDBMS
  • Concepts of RDBMS
  • Introduction
  • Comparision with DBMS
  • COOD Rules
  • Normalization Revisited
  • Concepts of ORDBMS & OODBMS
  • Introduction to ORDBMS
  • Introduction to OODBMS
  • Comparision and analysis
Structured Query Language(SQL)
  • Introduction to SQL
  • Predefined Data Types
  • Introduction to database objects
  • Table,View
Commands in SQL
  • Data Defination Language(DDL)
  • Data Manipulation Language(DML)
  • Data Control Language(DCL)
  • Transaction Control Language(TCL)
  • Database Security and Privileges(DCL)
Working with DDL,DML,TCL Commands
  • Operators
  • Conditional,Logical,Comparison,SET
  • Functions
  • Date,Number,Character,String,Group,Group by,Having clause
  • Transformation Functions
  • DECODE,TRANSLATE
  • NVL,NVL2(9i)
  • Aggregate Functions
Integrity Constraints
  • Different Types of Integrity Constraint
  • Use of Integrity Constraint in table
Joins
  • Usage of Joins
  • Different Types of Joins
  • Equi Join
  • Cartesian join
  • Self Join
  • Outer join
Sub Queries
  • Need of Sub Queries
  • Nested Sub queries
  • Co-related Sub Quries
  • Flash Back Queries (9i)
View
  • Importance of views
  • Creating,Manipulating Views
  • Materialized views(9i)
Working with database objects
  • Sequences and synonyms
  • Index,Cluster,Creating cluster table
Using External Tables(9i)
  • System Privileges
  • Table Privileges
Locks and SQL Plus editor commands
PL/SQL
  • Introduction to PL/SQL
  • Advantage of PL/SQL
  • Data Types in PL/SQL
  • Variables and Constants
  • Referencing NON-PL/SQL Variable
  • Using built in Functions
  • Conditional and iterative Statements
  • SQL in PL/SQL
  • Composite Data Types
  • Cursors
  • Exceptions:-Predefined ,User Defined
  • Records and PL/SQl table types
Advanced PL/SQL
  • Introduction to Triggers
  • Types of Triggers : - Row level,Statement Level
  • Before and After ,Instead of Triggers
  • Procedures,Functions in PL/SQL
  • User Defined Packages
  • Dropping triggers,Procedures,Functions
Online Training