USA: +1-515-337-8778
India: +91-8008527566
info@sryitsolutions.com

Oracle PL SQL

What is Oracle PL/SQL ?

Oracle PL/SQL is a combination of SQL along with the procedural features of programming languages. Oracle PL/SQL includes procedural language elements such as conditions and loops. You can declare constants and variables, procedures and functions, types and variables of those types, and triggers.

Oracle PL/SQL Online Training Contents

Oracle PL /SQL Online Training Details

Blog

Basics of PL/SQL 

  • PL/SQL architecture
  • PL/SQL Basic Concepts
  • PL/SQL and SQL*Plus
  • PL/SQL Basics, Variables, Constants, data types & error handling
  • PL/SQL wrapper utility

PL/SQL Structures

  • Simple blocks
  • Control structures
  • PL/SQL records
  • Recognizing the Basic PL/SQL Block and Its Sections
  • Describing the Significance of Variables in PL/SQL
  • Distinguishing Between PL/SQL and Non-PL/SQL Variables
  • Declaring Variables and Constants
  • Executing a PL/SQL Block

Error Checking / Exception Handling

  • Defining exceptions
  • Using the when others clause
  • Ensuring complete error checking
  • Passing error messages to calling routine

Boolean Logic in PL/SQL

  • Identifying the Uses and Types of Control Structures
  • Constructing an IF Statement
  • Constructing and Identifying Different Loop Statements
  • Controlling Block Flow Using Nested Loops and Labels
  • Using Logic Tables
  • If-then-else structure
  • Testing for numbers characters and Booleans

Cursors in PL/SQL

  • Cursor basics
  • Using a cursor for a multi-row SQL query

Iteration in PL/SQL

  • For loop
  • While loop

PL/SQL Tables

  • Defining PL/SQL tables
  • Reasons to use PL/SQL tables
  • Populating a PL/SQL table
  • Retrieving from a PL/SQL table

Dynamic SQL In PL/SQL

  • Introduction to the dbms_sql package
  • Creating a dynamic SQL statement

Nested Blocks in PL/SQL

  • Introduction to the dbms_sql package
  • Creating a dynamic SQL statement

Triggers in PL/SQL

  • Triggers and database events
  • Defining a trigger
  • Timing a trigger
  • Enabling and disabling a trigger

Stored Procedures, Functions and Packages

  • Basics of stored procedures
  • Basics of functions
  • Basics of packages
  • Defining stored procedures & functions
  • Function and stored procedures prototypes
  • Passing arguments to functions and stored procedures
  • Recompiling functions and stored procedures
  • Pinning packages in the SGA with dbms_shared_pool.keep
  • Package forward declaration
  • Package dependency
  • Package overloading
  • Listing package information

Bulking in PL/SQL

  • Bulk queries
  • Bulk DML (forall statement)
  • Using cursor attributes
  • Analyzing impact of bulk operations

Course Details:

Duration : 40-45 hours (Daily 1 hr to 1 hr 30 minutes)
System Access: 60 days
Session Timings: As per participant convenience
Payment Options: Paypal

Why SRYIT:

We are having ample of experience in Oracle PL/SQL Online training. After every session recordings will be provided and soft copy of Oracle PL/SQL Online training material will be provided. After the sessions Oracle PL/SQL project support will be provided..CV preparation will be done with the ongoing clients. We are maintaining the Blogs for every course which will have the blogs related to new concepts Of Oracle PLSQL Online Training.

About the Trainer:

Oracle PLSQL Online Training will be provided by real time certified consultant. Overall experience of trainer is 8 years. Trainer is having good experience in corporate training. Trainer is an expert in implementation projects and Oracle PL/SQL support projects. In the training real time scenarios will be covered which helps the job seeker to handle the projects easily.

 Who is Eligible:

Any Graduates/Post Graduates are eligible.
Anyone having knowledge in Data Warehousing technologies.
Any technical background consultants are eligible to learn Oracle PL/SQL Online Training.

 

To know more details about Oracel PL/SQL visit our blog

Open Popup
  • Book Your Demo.