Best Oracle PL SQL 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

We are committed to provide high quality ORACLE  SQL and PL/SQL Training in Bangalore that helps the students and professionals in areas of ORACLE  SQL and PL/SQL through its innovative programs and outstanding faculty.

Post Successful completion of ORACLE  SQL and PL/SQL Training Program leads to placement assistance and participation in campus placements by SDLC Training.