Course Overview
Oracle PL/SQL Training Details
-
Duration25-30 hours
-
TypeOnline Training
-
IncludesCourse Meterial
The PL/SQL programming training is an intense course that is designed to give the student hands-on exposure to Oracle PL/SQL. The student learns by coding, and this class has dozens of in-class exercises and the student will be guided from very simple PL/SQL programs to increasingly complex PL/SQL coding techniques.
- Training by Realtime Expert trainer
- Live Online Classes
- Free study material
- Online virtual Classes available in morning, evening and weekend
Prerequisties
- Attendees must be familiar with Web-based applications and have basic Microsoft Windows navigation skills and basic file-management skills.
Duration
Online- The format is 40% theory, 60% Hands-on.
- It is a 20 days program and extends up to 2hrs each.
- The format is 40% theory, 60% Hands-on.
- It is a 5 days program and extends up to 8hrs each.
- Private Classroom arrenged on request and minimum attendies for batch is 4.
Course Content
- Introduction to PL/SQL
- Understanding the benefits and structure of PL/SQL
- Examining PL/SQL Blocks
- Generating output messages in PL/SQL
- Declaring PL/SQL Variables
- Identify valid and invalid identifiers
- Declare and initialize variables
- List and describe various data types
- Identify the benefits of using the %TYPE attribute
- Declare, use, and print bind variables
- Writing Executable Statements
- List Lexical Units in a PL/SQL Block
- Use SQL Functions in PL/SQL
- Use Data Type Conversion
- Use Nested Blocks as Statements
- Reference an Identifier Value in a Nested Block
- Qualify an Identifier with a Label
- Use Operators in PL/SQL
- Using Sequences in PL/SQL Expressions
- Using SQL Statements within a PL/SQL Block
- Identify and use the SQL Statements in PL/SQL
- Retrieve Data in PL/SQL with the SELECT statement
- Avoid Errors by Using Naming Conventions When Using Retrieval and DML Statements
- Manipulate Data in the Server Using PL/SQL
- The SQL Cursor concept
- Use SQL Cursor Attributes to Obtain Feedback on DML
- Save and Discard Transactions
- Writing Control Structures
- Control PL/SQL Flow of Execution
- Conditional processing Using IF and CASE Statements
- Handle Nulls to Avoid Common Mistakes
- Build Boolean Conditions with Logical Operators
- Use Iterative Control with Looping Statements
- Working with Composite Data Types
- Learn the Composite Data Types of PL/SQL Records and Tables
- Use PL/SQL Records to Hold Multiple Values of Different Type
- Inserting and Updating with PL/SQL Records
- Use INDEX BY Tables to Hold Multiple Values of the Same Data Type
- Using Explicit Cursors
- Define Cursors
- Explain Explicit Cursor Operations
- Controlling Explicit Cursors
- Use Explicit Cursors to Process Rows
- Cursors and Records
- Cursor FOR Loops Using Subqueries
- Explicit Cursor Attributes
- The %NOTFOUND and %ROWCOUNT Attributes
- Handling Exceptions
- Define Exception
- Handling Exceptions with PL/SQL
- Predefined Exceptions
- Trapping Predefined and Non-predefined Oracle Server Errors
- Functions that Return Information on Encountered Exceptions
- Trapping User-Defined Exceptions
- Propagate Exceptions
- Basic RAISE Statement
- Creating Stored Procedures and Functions
- Overview of Stored Procedures and Functions
- Differentiate between anonymous blocks and subprograms
- Show the CREATE OR REPLACE PROCEDURE | FUNCTION
- Understand the Header Area of a Stored Procedure and Function
- Create Simple Procedures and Functions
- Create a Simple Procedure with an IN Parameter
- Execute a Procedure and a Function
Course Calender

18th November
Monday
7:00 AM IST
Enroll Now

22nd November
Friday
7:00 AM IST
Enroll Now
Review
Score Breakdown
4.6 / 5.0
90% recommend this course
Score Breakdown
-
(58)
-
(132)
-
(89)
-
(58)
-
(9)
Average Rating For
- Content 4.5
- Knowledge 4.5
- Assignment 4.2
- Institute 4.3
- Instructor 4.4
-
Antony Robert
18/03/2016
Great experience! Thanks Ecorptrainings for providing an online learning platform where courses can be taken from anywhere and anytime as per convenience. I attended Workday training and Workday HCM training and both the courses were really good. I would definitely recommend Ecorptrainings Thanks Ecorp
-
Rajesh
18/03/2016
Ecorptrainings is an interactive and innovative way of evangelizing us toward various courses. The best stars for Ecorptrainings lies on the ticket solving and their tailored courses. Instructors are knowledgeable and interactive in teaching. Workday training sessions are well structured with a proper content in helping us to dive. Good course material and structured modules in each course..