Welcome to Nakshatra Software Training

Oracle 11g Online Training

Course Duration : 35 Hrs

Oracle 11g 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 11g Online Training in Ameerpet Hyderabad. We are one of best Institute to provide Best High Quality Oracle 11g online training all over India. If you are staying in Hyderabad, Bangalore, Chennai, Pune, Delhi, USA, UK, Australia, Singapore etc. and unable to attend regular class room training programs then contact our training institute for information on online training. For more details on Oracle 11g Online Training please call to 9290971883 / 9247461324 or drop a mail to nakshatraonlinetraining@gmail.com

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