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: 19 Videos (Duration: 70 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 (15+ Yrs Exp)


HIGHLIGHTS

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:

Video 1 : INTRODUCTION TO DBMS

  • 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, Hierarchical Model
  • Network Model and Relational Model
  • History, Real-time Database Examples (LIVE)

Video 2: INTRODUCTION TO RDBMS

  • Features of RDBMS
  • Advantages of RDBMS
  • E.F Coded Rules for RDBMS
  • Normalization Concepts & Process
  • Client Server Communication
  • Oracle Corporation Products
  • RDBMS from Other Vendors: Microsoft, IBM..
  • Oracle Versions about SQL & SQL*PLUS
  • Database Types: OLTP and OLAP Databases
  • Real-world Advantage of OLTP & OLAP
  • Applicative use of RDBMS Databases

Video 3 : SQL LANGUAGE COMMANDS

  • Structured Query Language (SQL) Basics
  • Possible Operations with SQL
  • Data Definition Language (DDL)
  • Data Retrieval Language (DRL)
  • Data Manipulation Language (DML)
  • Transaction Control Language (TCL)
  • Database Security and Privileges (DCL)
  • Rules of SQL Queries and Statements
  • Real-world applicative uses of SQ

Video 4 : SQL BASICS

  • Creating Users and Tables
  • Table Data Inserts and Validations
  • Oracle Data Types
  • DDL Commands with Examples
  • CREATE, ALTER, DELETE Statements
  • Learn the DESCRIBE command to display the table structure
  • DML Command DRL Commands Operators
  • INSERT, UPDATE, DELETE Statements
  • SELECT Statements with Multiplier
  • WHERE Keyword for Query Conditions

Video 5 : SQL SPECIAL OPERATORS

  • SET, AND, OR, NOT, IN
  • Special Operators IN (NOT IN)
  • BETWEEN (NOT BETWEEN),
  • Arithmetic and Logical Operators
  • Understand Operator Precedence
  • UNION, UNION ALL, INTERSECT, MINUS
  • LIKE (NOT LIKE), IS NULL (IS NOT NULL)
  • Understanding DCL and TCL Commands
  • Transaction Concepts in Databases with SQL
  • Transaction Types and Uses
  • Commit and Rollback Operations
  • Nested Transactions with Save points
  • Database Read Consistency with SQL
  • DDL and DML Operations with Transactions

Video 6 : GROUPING QUERY RESULTS

  • Identify Distinct Values in Tables
  • Group Function or Aggregate function
  • Group By Operations in Queries
  • Having Clause of DRL Statements
  • Aggregate Functions with Group By
  • Order By Clause and Group By
  • Query Execution Order with Group By

Video 7 : BUILT-IN FUNCTIONS in SQL

  • Arithmetic Functions
  • Character Functions
  • Date & Time Functions
  • Character, String Functions
  • Conversion Functions
  • General Functions
  • OLAP Functions
  • Other Functions
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Nest multiple functions

Video 8 : CONSTRAINTS & KEYS

  • Importance of Data Integrity
  • Working with Integrity constraints
  • NOT NULL Constraint, UNIQUE Constraint
  • PRIMARY KEY Constraint and Usage
  • FOREIGN KEY Constraints and Relations
  • Multiple Constraints on Columns
  • Adding Constraints to Tables
  • Enabling - Dropping Constraints
  • Disabling Constraints on Tables
  • Querying for Constraints Information
  • Data Validations using Constraints
  • Constraints Limitations and Usage

Video 9 : QUERIES & JOINS

  • Need for Joins and Table Comparisons
  • SET Operations on Tables and Joins
  • Join Types : Equal Join, Simple Join
  • Inner Join and Query Conditions
  • Cross Join (Cartesian Join), Conditions
  • Non-equal Join and Self Join
  • Outer Joins  Types, Advantages and Usage
  • Cross Joins  Advantages and Limitations
  • Self Joins, Merge Joins and Sub Queries
  • Using Aliases in Joins and Conditions
  • Using Inner Self Joins with HAVING
  • JOINS and GROUP BY Queries

Video 10 : SUB QUERIES, NESTED QUERIES

  • Sub Queries in Real-world
  • Dynamic Conditions with Sub Queries
  • Sub Queries and Nested Sub Queries
  • Inner Select and Outer Select Queries
  • Usage of Sub Queries with WHERE, HAVING
  • Impact of Having Clause in Sub Queries
  • IN, ANY SOME, ALL Operators in Sub Queries
  • PAIR WISE and NON PAIR WISE in Sub Queries
  • NULLs and Correlated Sub Queries in SQL
  • Data Retrieval with EXISTS, NOT EXISTS

Video 11 : VIEWS, SYNONYMS,SEQUENCES

  • VIEWS IN ORACLE, Understanding Views & Use
  • Relational Views and Standard Views
  • SIMPLE VIEWS and COMPLEX VIEWS in PLSQL
  • Column Definitions in VIEWS
  • Using VIEWS for DML Operations
  • Forced Views, CHECK Constraints in Views
  • Creation of READ ONLY VIEWS - Real-time Use
  • TOP-N Analysis, (Indexed) Materialized Views
  • Sequent Working ces, with Synonyms
  • Creating Index Tables & Purpose

Video 12 : PERFORMANCE (QUERY) TUNING

  • Indexes - Definition and Architecture
  • B Tree Concept in Indexes
  • Clustered and Non clustered Indexes
  • Primary Key and Clustered Index
  • Unique Key and Non Clustered Indexes
  • Materialized Views - Indexed Views
  • Partitioning Tables using PL/SQL
  • Working with Very Large Tables
  • Range Partitions and Hash Partition
  • List Partition and Composite Partition
  • Parallel Query Process with Partitions
  • Performance Tuning Advantages

Video 13: LOCKS in ORACLE TABLES

  • Open Transactions and Lock Concepts
  • Lock Types and Locking Mechanism
  • Row Level Locks for Table Data Access
  • Table Level Locks and Query Blocking
  • Shared Lock and Real-time Use
  • Deadlock : Detection, Prevention, Avoidance
  • Implicit Locking Concepts in Oracle with PLSQL
  • LOCK Hints and Query Blocking

Video 14 : PL/SQL (PROCEDURE LANGUAGE – SQL)

  • Introduction to Programming Languages
  • Introduction & Advantage of PL/SQL
  • PL/SQL Architecture, PL/SQL Data types
  • The %TYPE Attribute and %ROWTYPE Attribute
  • Variable and Constants, Using Built-in Functions
  • Conditional and Unconditional Statements

Video 15 : PL/SQL – (CONTROL STRUCTURE)

  • Simple If, If..Else. Nested If..Else Statements
  • Ladder, Selection, Simple Case Statements
  • GOTO Label and EXIT Statements in PL/SQL
  • Iterations in PL/SQL, Simple LOOP, WHILE
  • FOR LOOP and NESTED LOOPS in PLSQL
  • SQL within PL/SQL, Composite Data Types
  • Cursor Variables and Management in PL/SQL
  • Implicit & Explicit Cursors and Attributes
  • Cursor with Parameters and Nested LOOPs
  • Cursors with Sub Queries, Reference Cursors
  • Record and PL/SQL Table Types. Real-time Use
  • What are Oracle-Supplied Packages?
  • Examples of Some of the Oracle-Supplied Packages
  • How Does the DBMS_OUTPUT Package Work?

Video 16 : ADVANCED PL/SQL – 1

  • Procedures in PL/SQL: STORED PROCEDURE
  • PROCEDURES @ Parameters (IN, OUT, IN OUT)
  • POSITIONAL Notation and NAMED Notation
  • Procedure with Cursors and Sub Queries
  • ALTER and DROP of Stored Procedures
  • Functions in PL/SQL: Real-time Usage
  • User Defined Functions, Nested Functions
  • Using Functions in SQL Statements
  • Working with Procedures and Functions
  • Comparing Stored Procedures and Functions
  • Using SPs with Table Value Functions
  • Using SPs for Dynamic SQL Statements
  • Loops and Table Variables in SQL Programs
  • Merge, NVL2(), NULLIF(), COALESCE()
  • CASE & Temporary /Global Tables

Video 17 : ADVANCED PL/SQL – 2

  • Cross Tab Views using Pivot/Unpivot Operators
  • Follows Clause and READONLY Tables
  • IN-LINE VIEWS. Manipulations with Triggers
  • Purity Levels in Oracle - with Examples
  • User_Source Dictionary Table Packages
  • Creating PACKAGE Specifications with PLSQL
  • PACKAGE Body - Examples with Big Data Tables
  • Private and Public Objects in PACKAGE
  • Types of Exceptions: User Defined Exceptions
  • EXCEPTIONS in PL/SQL with Real-time
  • Event Handling and Error Handling Techniques
  • Important Error Code Values in PL/SQL
  • RAISE_APPLICATION_ERROR Procedure

Video 18 : ADVANCED PL/SQL – 3

  • Pragma_Autonomous_Transaction() with SPs
  • Returning into clause, Bulk Collect
  • For All, Definer/Invoker Rights & Usage
  • About Flash Back Queries, Dynamic SQL
  • Flash Back Command, Purge Command
  • Recycle Bin, Regular Expressions in PLSQL
  • DML Error Logging and Virtual Columns
  • Types of Triggers, Row Level Triggers
  • Statement Level Triggers, DML Triggers
  • DDL Triggers and Schema Level Triggers
  • Using OLD & NEW References, Trigger Auditing
  • Enabling / Disabling Triggers, Dropping Triggers
  • Triggers in PL/SQL and Data Manipulations
  • Using Memory Tables in Triggers
  • DML and DDL Events with Triggers
  • Compound Triggers, New data types
  • Working with LARGE Tables in PLSQL
  • New: EXTRACT(), Autonomous Transaction

Video 19 : IMPLEMENTING OBJECT TECHNOLOGY

  • Object Technology and Applicative Use
  • OOPS-Object Instances, Creation of Objects
  • Creating User Defined Data Types
  • Creating Object Tables in Oracle
  • Inserting rows in Table using Object
  • Retrieving data from Object Based Tables
  • Calling a Method, Indexing Abstract
  • Data type Attributes in PLSQL
  • Advantages of Collections
  • Ref Cursor (Dynamic Cursor), Weak Ref Cursor
  • Strong Ref Cursors and Nested Tables
  • Associative Arrays, VARRAYS/VARYING arrays
  • Creating tables using Nested Tables
  • Inserting, Updating & Deleting
  • Nested, Table Records

 Perform a Basic Search using the REGEXP_LIKE function

 Find patterns using the REGEXP_INSTR function

 Extract Substrings using the REGEXP_SUBSTR function

 Replace Patterns Using the REGEXP_REPLACE f

*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