Oracle PL SQL Real-Time Online Training, Support By SQL Experts

Oracle PL SQL Training: Learn building the applications by leveraging capabilities of Transaction Control Language, Database Security, Error Handling, Oracle Supplied Packages and etc. You will also learn Collection Datatypes and how to Use Declarative Constraints and Non-Character Function. This Course also includes Creating Subqueries, Aggregating Data Using Group Functions, Working With Character Functions. You will get Hands-On exposure to Oracle PL SQL.



FOR FREE DEMO contact :

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107

USA Number : 214-628-3894

Gtalk : raavi.sriraja@gmail.com

Blog: http://apex-it-online-trainings.blogspot.in


Oracle PL SQL Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided

ORACLE PL SQL COURSE CURRICULUM

(the course content can be modified as per your requirements):


Introduction to PL/SQL

=======================

Advantages of PL/SQL

PL/SQL architecture

Datatypes in PL/SQL

PL/SQL program structure

Simple PL/SQL programs

Embedding SQL statements in PL/SQL

Conditional statements

Loops

Cursors :

========

About cursors in PL/SQL

Explicit cursors

For loop cursor

Cursor paramenters

For update clause

Where current of clause

Ref cursors

Implicit cursors

Exception Handling :

System defined exceptions

User defined exceptions

Sqlcode & sqlerrm

Pragma exception_init

Subprograms :

=============

Introduction to subprograms

Difference between anonymous & named blocks

Stored procedures :-

Creatng procedures

Working with IN , OUT ,INOUT parameters

Procedures with cursors

Procedures returning records

Pragma autotnomous transaction

Functions :

Difference b/w procedures and functions

Inline functions

Packages :

==========

Introduction to packages

Package specification and package body

Overloading package members

Triggers :

==========

Introduction to triggers

DML triggers

DDL triggers

Db auditing using triggers

DB level triggers

Collections in PL/SQL

Built-in packages in PL/SQL

Oracle 10g features

Oracle 11g features

DBA concepts