Oracle PL-SQL Video Training

This impeccable PL SQL Training Course is exclusively designed for starters as well as for experienced professionals addressing Oracle Installation, Database Design, Queries, Joins, Stored Procedures, Triggers, Remote Queries, Transactions and Tuning options with BLOB Data and JSON. Practice Material, Certification, Resume & Interview Guidance are included in this PLSQL Course

Oracle PL-SQL Video Training

Real-time, Practical Training Videos, accessible 24x7. Study, Practice Material and Lab Work for every video. Trainer available for doubts clarifications and support. Theory Material to be provided in Advance. 

Type: 100% Practical & Example Based, Real-time
No Of Videos: 22 Videos (Duration: 80 mins per video)
Course Fee: INR 6000/- (USD 100) payable in 2 installments

Complete Practical Training with Real-time Databases. Every Course includes a Real-time Case Studies.

Trainer : Mr Shekar (13+ Yrs Exp)


Daily Tasks Weekly Interviews
Real-time Project Resume Guidance
Certification Guidance Placement Services

All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 Support.


Oracle PL/SQL Training Course Contents:

Module : 1
Database Concepts, Basic SQL

Module : 2
Oracle Concepts, PL/SQL


  • What is Data and Information?
  • Purpose of Data Management
  • File and File System For Data Storage
  • Disadvantages of File Data Management
  • Database : Purpose, Basic Terminology
  • Advantages of Database for Data Storage
  • Possible Operations on the Database
  • Database Models – Hierarchal Model
  • Network Model and Relational Model

CHAPTER 2 : Introduction to RDBMS

  • Features of RDBMS
  • Advantages of RDBMS over FMS & DBMS
  • E.F Codd Rules for RDBMS
  • Normalization Process
  • Client server Technology
  • Oracle Corporation Products
  • Oracle Versions about SQL & SQL*PLUS
  • Difference between OLTP & OLAP

CHAPTER 3 : Sub Language Commands

  • Data Definition Language(DDL)
  • Data Retrieval Language (DRL)
  • Data Manipulation Language (DML)
  • Transaction Control Language (TCL)
  • Database Security and Privileges (DCL)

CHAPTER 4 : Introduction to SQL

  • Schema & Schema Objects
  • Oracle Data Types
  • DDL Commands
  • DML Command DRL Commands Operators
  • Arithmetic and Logical Operators
  • Special Operators – IN (NOT IN), BETWEEN (NOT BETWEEN),

CHAPTER 5 : Built-in Functions

  • Arithmetic Functions
  • Character Functions
  • Date functions
  • Conversion Functions
  • Aggregate Functions
  • OLAP Functions & General Functions

CHAPTER 6 : Grouping the result of a query

  • Using Group by and Having Clause of DRL Statement
  • Using Order by clause
  • Working with, Sequences, Working with Synonyms,
  • Working with Index and Clusters, Creating Cluster Tables,
  • implementing Locks, Working with roles

CHAPTER 7 : Pseudo Columns in Oracle

  • Understanding Pseudo Columns in Oracle
  • Type of Pseudo Columns in Oracle

CHAPTER 8 : Working with Integrity Constraints

  • Importance of Data integrity
  • Working with different types of integrity constraints
  • NOT NULL constraint, UNIQUE constraint,
  • PRIMARY KEY constraint, REF constraint
  • Understanding ON DELETE clause in referential integrity constraint
  • Working with multiple constraints upon a column
  • Adding constraints to a table
  • Dropping of constraints, Enabling /
  • disable constraints
  • Querying for constraints information

CHAPTER 9 : Working with Sub Queries

  • Understanding the practical approach
  • to Sub Queries/Nested Select/Sub Select/Inner Select/Outer Select
  • Usage of Sub Queries.
  • The Impact of Having Clause in Sub Queries,
  • IN, ANY SOME, ALL Operators in Sub Queries
  • PAIR WISE and NON PAIR WISE Comparison in Sub Queries, Be…
  • Aware of NULL’S, Correlated Sub Queries,
  • Handling Date Retrieval with EXISTS and NOT EXISTS Operators

CHAPTER 10 : Locks

  • Row level Locks
  • Table level Locks
  • Shared Lock
  • Dead Lock
  • Implicit Locking

CHAPTER 11 : Querying Multiple Tables (Joins)

  • Equi Join/Inner Join/Simple Join,
  • Cartesian Join, Non-Equi Join, Self Join

CHAPTER 12 : Data Partitions & Parallel Process

  • Range Partitions, Hash Partition
  • List Partition, Composite Partition, Parallel
  • Query Process

CHAPTER 13 : Working with DCL, TCL Commands

  • Grant, Revoke,
  • Commit, Rollback, Savepoint
  • Read Consistency

CHAPTER 14 : PL/SQL (Procedure Language – SQL)

  • introduction to Programming Languages
  • Introduction PL/SQL, The Advantages of
  • PL/SQL
  • PL/SQL Architecture, PL/SQL Data types
  • Variable and Constants, Using Built-in
  • Functions
  • Conditional and Unconditional Statement
  • Simple if, if..else. Nested if..else, if.. else
  •  Ladder, Selection Case, Simple Case, GOTO Label and EXIT
  • Iterations in PL/SQL, Simple LOOP, WHILE LOOP,
  • SQL within PL/SQL, Composite Data types
  • (complete), Cursor Management in PL/SQL
  • Implicit Cursors, Explicit Cursors, Cursor
  • Attributes
  • Cursor with Parameters, Cursors with LOOPs Nested Cursors,
  • Cursors with Sub Queries, Ref. Cursors, Record and PL/SQL Table Types.

CHAPTER 15 : Advanced PL/SQL

  • Procedures in PL/SQL: STORES PROCEDURE,
  • PROCEDURE with Parameters (IN, OUT and IN OUT
  • POSITIONAL Notation and NAMED Notation,
  • Procedure with Cursors, Dropping a Procedure
  • Functions in PL/SQL: Differences between
  • Procedures and Functions,
  • User Defined Functions, Nested Functions,
  • using stored function in SQL statements
  • Pragma_Autonomous_Transaction(),
  • Returning into clause, Bulk Collect,
  • For All, Definer/Invoker Rights
  • About flash Back Queries, Dynamic SQL,
  • Flash back command, Purge Command, Recycle bin, Regular expressions,
  • DML Error Logging, Virtual Columns, Read only tables,
  • Cross tab Views using, Pivot/Unpivot Operators Follows Clause,
  • Compound Triggers, New data types
  • Working with LARGE Objects

CHAPTER 16 : Maintaining Database Objects

  • Understanding the Standards of VIEWS
  • in Oracle
  • Types of VIEWS: Relational Views,
  • Practical approach of SIMPLE VIEWS and COMPLEX VIEWS,
  • Column definitions in VIEWS, Using VIEWS for DML Operations,
  • forced Views, Putting CHECK Constraint upon
  • VIEWS, Creation of READ ONLY VIEWS
  • TOP-N Analysis, About Materialized
  • Understanding the IN LINE VIEWS
  • Views, View Triggers
  • Outer Joins – Types, Advantages and Usage
  • Cross Joins – Advantages and Limitations
  • Self Joins, Merge Joins and Sub Queries
  • Purity Levels, User _Source Dictionary table Packages in PL/SQL:
  • Creating PACKAGE Specification
  • PACKAGE Body, Private and Public Objects in PACKAGE
  • XCEPTIONS in PL/SQL: Types of Exceptions: User Defined Exceptions
  • SQL Error Code Values

CHAPTER 17 : Database Triggers in PL/SQL

  • Types of Triggers, Row Level Triggers,
  • Statement Level Triggers, DML Triggers, DDL Triggers, Schema Triggers
  • Using OLD and NEW References, Trigger Auditing,
  • Enabling / Disabling Triggers, Dropping Triggers

CHAPTER 18 : Implementing Object Technology

  • What is Object Technology?
  • OOPS-Object instances, Creation of objects
  • Creating user Defined Date Types
  • Creating Object Tables
  • Inserting rows in a table using object
  • Retrieving date from Object based
  • Tables
  • Calling a Method, Indexing Abstract
  • Data type Attributes

CHAPTER 19 : Using Collections

  • Advantages of collection
  • Ref Cursor (Dynamic Cursor), Weak Ref Cursor,
  • Strong Ref Cursor, Nested Tables
  • Associative Arrays, VARRAYS or
  • VARYING arrays
  • Creating tables using nested tables
  • Inserting, Updating & Deleting
  • Nested, Table Records

CHAPTER 20 : Advanced Features

  • New Date function, Rename column,
  • Inner Join/Natural Join,
  • Left Outer Join/Right Outer Join, Full Outer Join
  • Multiple inserts, Insert All Command,
  • Merge statement, NVL2(), NULLIF(), COALESCE(),
  • CASE expression of Select Command, Temporary Tables/Global Tables
  • New Function EXTRACT (), Autonomous Transaction

CHAPTER 21 : Oracle Built-in Packages

  • DBMS_OUTPUT Package
  • DBMS_DDL Package
  • DBMS_JOB Package
  • UTL_FILE Package
  • UTL_MAIL Package
  • Architecture
  • Physical Structures Logical structures
  • DB Memory Structures

CHAPTER 22 : Oracle Utilities

  • Oracle Data Pump
  • SQL * Loader
  • External Tables

*Above course curriculum applicable for registrations from Oct 6th, 2017

24x7 Support & Course includes ONE Real-time Project. Register Today

PLSQL Training - Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • Certification & Interview Guidance
  • Detailed SQL Server Architecture, DB Design
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, DAC and Contained Databases
  • Routine DBA Activities, Emergency DBA Activities
  • SQL Profiler, SQLDIAG, DTA and Litespeed Tools
  • High Availability, Disaster Recovery, Always-On
Register Today  Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T