Home > Oracle PLSQL Online Training

Oracle PLSQL Online Training

Oracle PL SQL is most demanding course in the market. Having basic knowledge on SQL helps o grab quickly plsql online training course but don't worry we will cover them as part of the course. There are very good jobs available with good billing both in India & USA for PL SQL skill set.

Cheyat is one of the best institute to provide PL SQL online training course with best price and best training institute in ameerpet, we are best quality training provider of plsql course in online you will also get pl sql tutorials and video recordings of classes. Register in our website for pl sql classes.

Oracle PLSQL Online Training Demo Video

ORACLE PLSQL Online Training Course content

Oracle 11g SQL Course Contents

Chapter 1 - Retrieving Data Using the SQL SELECT Statement

  • The SELECT Statement
  • The SELECT and FROM Clauses
  • Conditions and the WHERE Clause
  • Other Conditional Operators
  • Logical Operators

Chapter 2 - Restricting and Sorting Data

  • The ORDER BY Clause
  • Column Aliases
  • Arithmetic Expressions
  • Precedence of Operators

Chapter 3 - Using Single-Row Functions to Customize Output

  • Function Types
  • Using Table dual to try out Functions
  • Numeric Functions
  • Character Functions
  • String Concatenation
  • Date Arithmetic and Date Functions

Chapter 4 - Using Conversion Functions and Conditional Expressions

  • Conversion Functions
  • NVL and NVL2
  • CASE Expressions

Chapter 5 - Reporting Aggregated Data Using the Group Functions

  • SUM()
  • COUNT()
  • MIN()
  • MAX()
  • AVG()

Chapter 6 - Displaying Data from Multiple Tables

  • Overview of Table Joins
  • Inner Joins
  • Table Aliases
  • Outer Joins
  • Self Joins
  • ANSI Standard Joins

Chapter 7 - Using Sub queries to Solve Queries

  • Overview of Subqueries
  • Simple Subqueries
  • Complex Subqueries
  • Subquery Rules
  • Using the ANY, ALL and IN Operators

Chapter 8 - Using the Set Operators


Chapter 9 - Manipulating Data

  • Inserting Rows
  • Updating Rows
  • Deleting Rows
  • Verifying Updates
  • Transaction Control
  • Commit and Rollback
  • Save points
  • Commits and Constraints
  • Amending Data in SQL Developer

Chapter 10 - Using DDL Statements to Create and Manage Tables

  • Creating Tables
  • Specifying Constraints
  • Altering Tables, Columns and Constraints
  • Dropping Tables, Columns and Constraints
  • Copying Tables
  • Data dictionary

Chapter 11 - Creating Other Schema Objects

  • Creating Indexes
  • Dropping Indexes
  • Listing Indexes
  • Creating and Using Views
  • Dropping Views
  • Listing Views
  • Create a Sequence
  • View Sequence Details
  • Create a Synonym
  • List Synonyms

Oracle 11g PLSQL Online Training Course Content

Introduction to PLSQL

  • What is PLSQL
  • PL/SQL Environment
  • Benefits of PL/SQL
  • Overview of the Types of PLSQL blocks
  • Create and Execute a Simple Anonymous Block
  • Generate Output from a PLSQL Block

Declaring PLSQL Identifiers

  • Identify the Different Types of Identifiers in a PLSQL subprogram
  • Use the Declarative Section to Define Identifiers
  • List the Uses for Variables
  • Store Data in Variables
  • Declare PLSQL Variables

Writing Executable Statements

  • Describe Basic Block Syntax Guidelines
  • Use Literals in PLSQL
  • Customize Identifier Assignments with SQL Functions
  • Use Nested Blocks as Statements
  • Reference an Identifier Value in a Nested Block
  • Qualify an Identifier with a Label
  • Use Operators in PLSQL
  • Use Proper PLSQL Block Syntax and Guidelines

Interacting with the Oracle Server

  • Identify the SQL Statements You Can Use in PL/SQL
  • Include SELECT Statements in PLSQL
  • Retrieve Data in PLSQL with the SELECT Statement
  • Avoid Errors by Using Naming Conventions When Using Retrieval and DML Statements
  • Manipulate Data in the Server Using PLSQL
  • The SQL Cursor concept
  • Use SQL Cursor Attributes to Obtain Feedback on DML
  • Save and Discard Transactions

Writing Control Structures

  • Control PLSQL Flow of Execution
  • Conditional processing Using IF Statements
  • Conditional Processing CASE Statements
  • Handle Nulls to Avoid Common Mistakes
  • Build Boolean Conditions with Logical Operators
  • Use Iterative Control with Looping Statements

Working with Composite Data Types

  • Learn the Composite Data Types of PLSQL Records and Tables
  • Use PLSQL Records to Hold Multiple Values of Different Types
  • Inserting and Updating with PLSQL Records
  • Use INDEX BY Tables to Hold Multiple Values of the Same Data Type

Using Explicit Cursors

  • Cursor FOR Loops Using Sub-queries
  • Increase the Flexibility of Cursors By Using Parameters
  • Use the FOR UPDATE Clause to Lock Rows
  • Use the WHERE CURRENT Clause to Reference the Current Row
  • Use Explicit Cursors to Process Rows
  • Explicit Cursor Attributes
  • Cursors and Records

Handling Exceptions

  • Handling Exceptions with PLSQL
  • Predefined Exceptions
  • Trapping Non-predefined Oracle Server Errors
  • Functions that Return Information on Encountered Exceptions
  • Trapping User-Defined Exceptions
  • Propagate Exceptions
  • Use The RAISE_APPLICATION_ERROR Procedure To Report Errors To Applications

Creating Stored Procedures and Functions

  • Differences Between Anonymous Blocks and Subprograms
  • Creating and invoking Procedure
  • Creating and invoking Functions
  • Passing Parameter to the Function


  • What are packages
  • Advantages of packages
  • Examples on packages


  • What are triggers?
  • Types of triggers.
  • Advantages of triggers.

Oracle PLSQL Online Training - Frequently asked questions:

1) What is Oracle PLSQL?

PL standing for Programming Logic is used to retrieve the data from the relational data base such a way that it does not put any burden on the databases for each and every requirement of the end user.

2) Who Can Learn Oracle PLSQL?

Any one who either posses basics of RDBMS or no vice with any of Relation Data Base Management Principles and Concepts can pursue the course.
This Course is designed such a way that it drives the rdbms concept clearly into the mind.

3) What are the prerequisites to learn Oracle PLSQL?

This courses doesn't require any prerequisites but having RDBMS basics is appreciated.

4) How is the market for Oracle PLSQL?

Oracle taking 70 % of in the market strongly associates its participles on pl sql for communication between a database and internet like an environment. Once a person is clear with plsql concepts he can put his concentration on oracle applications technical and give boost to the career in the ERP Market.
PL Sql Job openings in the last month, This report is not an estimation of cheyat and we have received this from Job portal network:

Shop No 1, Kasturi Apartments,
Sindhubhavan Road, Brundavan Colony, Vijayawada - 520010
+1(224) 676-9882
24 x 7 Call Support
Email support