Oracle 9i Online Training Institute in Hyderabad India

Oracle 9i Online Training Institute in Hyderabad India

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 nakshatraonlinetraining@gmail.com  or Whatsapp to us on : 9290971883

Oracle 9i Course Content

Course Duration : 35 Hrs

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