Oracle PLSQL Certification Course - Overview

PL SQL stands for Programming Language for SQL
It provides C Language Like Programming Capabilitys to SQL using Blocks, Cursors, Procedures, Functions, Packages, Triggers etc to Program Real World Complex Scenario into Reality.
Syllabus Covers Both Oracle PLSQL Certifcation & Job Oriented Topics + You Can easily work on any other Database like MYSQL, SQL Server, DB2 etc by just googling it since more or less syntax & concepts are same.
Since Oracle is No. 1 Database in World, Learning PLSQL Opens up High Pay Database Developer Jobs
Prerequise - SQL

PL SQL Syllabus

PL SQL Basics
Anonymous Blocks
Data types, Variable, Composite Variables etc
Control Structures
- if-else-elsif
- while
- loop...endloop
- for loop
- nested loop
Basic Programs
Logic Building Sessions
Using SQL Queries in PLSQL
Transactions in PLSQL
Exception Handling
- Working with Exception Block
- Handling Oracle Defined Exceptions
- Creating User Defined Exceptions

Cursors
- Implicit Cursors
- Explicit Cursors
- Cursor For Loops
- Cursor with parameters
- Reference Cursors
Procedures
- Creating Procedures
- Overloading Procedures
- Exception handling and propagation
Nested Procedures
Functions
- Creating Functions
- Nested Functions
- Overloading Functions
- Nesting Functions and Procedures
- Functions in Select and DML Queries
Nested Functions
Integrating Prodedures & Functions

Packages
- Package Basics
- Package Specification
- Package Body
- Global constants
- Writing Procedures and Functions in Pacakges
- Procedure Overloading
- Function Overloading
- Exception Handling
Oracle Supplied Packages
- Execute Immediate

Triggers
- Create, Replace, Drop
- Trigger Types:
- Statement Level Triggers
- Row Level Triggers
- INSTEAD OF Triggers Overview
Bulk Collect Overview
Global Temorary Table
- Creation and use in Procedures
Interview Prepare Sessions
Project