Oracle PL SQL hands-on Online Training, Job Support, Interview Support & Corporate Training


Oracle PL SQL Training makes you building the applications by leveraging capabilities of transaction control Language, database Security, Error Handling, Oracle supplied Packages and etc. you may additionally learn collection Datatypes and the way to Use Declarative Constraints and Non-Character function. This Course additionally includes making Subqueries, Aggregating data using group Functions, operating With Character Functions. you may get active 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: https://apex-online-it-trainings..com
Website: www.apex-online-it-trainings.com


Oracle PL SQL Interview queries and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments are going to be provided
ORACLE PL SQL COURSE program
(the course content may be changed as per your requirements):


Intro 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