Oracle PL SQL Training

In this module, you will learn about the select statements, data manipulation, conditional processing using IF and CASE statements, using simple loop, for and while statements, etc.

In this module, you will learn about the Use PL/SQL Records, The %ROWTYPE Attribute, 

Insert and Update with PL/SQL Records, Associative Arrays (INDEX BY Tables), 

Examine INDEX BY Table Methods, Use INDEX BY Table of Records, explicit Cursors,

Declare the Cursor,,Open the Cursor, Fetch data from the Cursor, Close the Cursor, Cursor FOR loop, Explicit Cursor Attributes, FOR UPDATE Clause and WHERE CURRENT Clause, etc.

In this module, you will learn about the Understand Exceptions, Handle Exceptions with PL/SQL, Trap Predefined Oracle Server Errors, Trap Non-Predefined Oracle Server Errors, Trap User-Defined Exceptions, Propagate Exceptions, RAISE_APPLICATION_ERROR Procedure, creating simple procedures and functions, etc.

In this module, you will learn about the Oracle PL SQL packages, creating packages, invoking packages using construct, implementing package functions in SQL, dynamic SQL, declare cursor variables, executing PL/SQL block, Invoking DBMS SQL packages, Implementing DBMS-SQL packages with DML statements, triggers, identifying and creating triggers, creating database events, system event triggers, etc.

In this module you will learn about the schema object dependencies, displaying the direct and indirect dependencies, understanding remote dependencies, recompile a PL/SQL program unit, etc.

In this module, you will learn about the EXECUTE IMMEDIATE, DBMS_SQL package, UTL-FILE, DBMS_OUTPUT, Varrays, associated variables, nested tables, etc.

Summarize all the points discussed.

At HKR, we provide practice tests at the end of each and every concept and also Oracle PL SQL interview questions and Sample Resumes to crack the interview.

We at HKR trainings provide the learners with practice Mock Interview Sessions and excellent Job Support at the end of the course.