For Online Training :
Phone No : 9290971883, 9247461324
Email ID : revanthonlinetraining@gmail.com
For Class Room Training :
Phone No : 9394799566, 9290641808
Email ID : revanthclassroom@gmail.com
Institute Address:
B1, 3rd Floor, Eureka Court, Near Image Hospital, Ameerpet, Hyderabad, India.

Oracle 9i Online Training

Oracle 9i Online Training


Course Duration : 35 Hrs


Oracle 9i Course Content


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

We are providing Oracle 9i Online Training in Ameerpet Hyderabad. We are one of best Institute to provide Best High Quality Oracle 9i online training all over India. The IT Professionals and Students from India and abroad who are unable to attend regular classes can attend our Oracle 9i online training from their home in their convenient timings. For more details on Oracle 9i Online Training please call to 9290971883, / 9247461324, or drop a mail to revanthonlinetraining@gmail.com

Oracle 9i online training institute address : B1, 3rd Floor, Eureka Court, Near Image Hospital, Ameerpet, Hyderabad, India


Oracle 9i Online Training from India

Online Training Enquiry Form

Security-Code reload security code

Online Software Courses