best oracle sql plsql training in bangalore

ORACLE 11G SQL AND PL/SQL COURSE
Introduction

Introduction to DBMS
Introduction to Data Management
File system concepts
Database Models
Hierarchal Model
Network Model
Relational Model
Introduction to Oracle
History of Oracle
Oracle products and features
Oracle versions and releases
About SQL & SQL*PLUS
SQL*NET
Introduction to SQL
Sub-language Commands
Data Retrieval Language (DRL)
Data Definition Language (DDL)
Data Manipulation Language (DML)
Transaction Control Language (TCL)
Database security and Privileges
Working with DRL
Select statement
Distinct Selection
Where Clause
Order by Clauses
Working with DDL and DML
DDL commands
Database objects and object types
Working with Tables
Data Types
Table partitions Create, Alter,
Add, Modify, Drop Insert, Update,
Delete
Commit, Rollback
Oracle Built-in Functions
Arithmetic Functions Character
Functions Date Functions Queries
with Single Row Functions
Misc Functions
Working with Regular Expressions
Constraints
Data Integrity Concepts
Different types of Constraints
Table Level and Column Level
Composite Constraints
Check Constraint and
Restrictions Referential Integrity
Sub Queries
Normal Sub Queries.
Co-related Sub Queries.
Updating Using Co-Related.
Deleting Co-Related
Using Exists and Not Exists
Inline Queries
Miscellaneous Sub-queries.
Joins
Joining Tables
Simple Joins
Outer Joins
Self Joins
Joins with Inline Queries
ANSI Join Syntax
Select Statement with Misc Options
Set Operators
Pseudo Columns
Views, Synonyms & Indexes
Simple & Complex Views
Modifying the View Query
Synonyms
Indexes
Sequences
PL/SQL COURSE CONTENT
Introduction to PL/SQL
Role of PL/SQL in Applications
Programming Fundamentals
Restriction of SQL in PL/SQL
PL/SQL Engine
Working with PL/SQL
Blocks Conditional Structure
Anonymous Blocks
Declare
Begin
End
Conditional Structure
Loop Structure
Exception Handling
System Defined Exceptions
User Defined Exceptions
Defining Own Error Messages
Program Exception Int
SQLCODE, SQLERRM
Cursors
Introduction to
Types of Cursors
For Cursor
Cursor Attributes
Working with Implicit
Cursors
Dynamic Cursors
Stored Subprograms
Introduction of Stored
Subprograms Working with
Stored Procedures Overloading of
Subprogram Limitations of
Functions Understanding of
Packages Type Spec & Body
Package Instantiation
Calling Packages &
Procedures & Functions
Database Triggers
Introduction to Triggers
Statement Level
Triggers Row Level
Triggers When Clause
Co-relations Trigger
Predicates
Instead of Triggers Compound
Triggers Mutation of Triggers
Advanced Features
Autonomous Transactions
Dynamic SQL