iBase Training

Official Website

Oracle PL SQL Online Training Course Content by corporate trainers

 

Oracle PL/SQL Training includes creating applications by using 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.

 

 

FOR FREE DEMO contact :

Email : info@ibasetraining.com

Phone/WhatsApp : +91-8106721223

USA Number : +1-650-993-1007

Gtalk : ibasetraining@gmail.com

WebSite: http://www.ibasetraining.com

 

 

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):

 

PL/SQL Course Content 

Blocks
Structure, Writing Anoyomous Blocks

Variables
Oracle Datatypes, TYPE and ROWTYPE declarations, Value assignments

Control structures
IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END , LOOP statement, WHILE condition, FOR condition

Cursors
Implicit and Explicit Cursors, Cursor Manipulation statements, OPEN FETCH CLOSE EXIT WHEN

Error Handling
Predefined Exceptions, Non-Predefined Excecptions, User Defined Exceptions

Printing Values to Screen

Procedures
Creating and Calling Procedures

Functions
Creating and Calling Functions

Packages
Package Header, Package Body

Design Tips and Techniques
Format of standard packages in an application, Spec and Body, NOCOPY hint

Triggers
Database triggers, CALLing procedures from triggers

Dynamic SQL
EXECUTE IMMEDIATE, DBMS_SQL package

Oracle Supplied packages
DBMS_OUTPUT, UTL_FILE

Collection datatypes
Associative Arrays, Nested tables, VARRAYs

 

Student Registration

Name

Email Id

Country Code

Mobile No

Course Name

City