Course Batch Starts, Timing, Price & Enroll

Program Duration Batch Starts Time Price Enroll
30 Hrs Weekend Evening-Batch USD 500 400

Enroll Now
30 Hrs Weekend Morning-Batch USD 500 400

Enroll Now
30 Hrs Weekdays Morning-Batch USD 500 400

Enroll Now
30 Hrs Weekdays Evening-Batch USD 500 400

Enroll Now

About Course

The best suited audience to attend this course can be -

Application Developers
System Analysts
Business Analysts
Database Administrators
Data Warehouse Administrator
Business / Project Heads
Technical Consultant
Portal Developer
This course is designed to introduce you about the fundamentals of PL/SQL. This course will help you to understand how to use PL/SQL with real-world scenarios. The key points which will be in focus during the PL/SQL Fundamental training can be-
To describe and introduce various features of PL/SQL with syntax.
To design anonymous block using PL/SQL.
To write PL/SQL code and control code flow like loops, control structures and explicit cursors.
To handle runtime errors and trapping exceptions
To work with stored procedures and functions.
After completing this course you will be able to handle a RDBMS using PL/SQL queries in an effective way by ensuring reliability, security and high performance. You will learn how to optimize workloads of a RDBMS and how to deliver a higher service quality. This course will help you to learn -
Features and Syntax of PL/SQL
Designing and executing anonymous block in PL/SQL
Write PL/SQL code to interface with the database
Handling runtime errors and trapping exception
Working with stored procedures and functions
A prior knowledge of SQL Fundamental, familiarity with programming languages and data processing concepts is required to start and understand the PL/SQL.



  • 1.1 Course Objectives, Course Agenda and Class Account Information
  • 1.2 Describe the Human Resources (HR) Schema
  • 1.3 Identify the Appendices Used in this Course
  • 1.4 Introduction to PL/SQL Development Environments
  • 1.5 Oracle Database 12c SQL Documentation and Additional Resources
  • 2.1 Understanding the benefits and structure of PL/SQL
  • 2.2 Examining PL/SQL Blocks
  • 2.3 Generating output messages in PL/SQL
  • 3.1 Identify valid and invalid identifiers
  • 3.2 Declare and initialize variables
  • 3.3 List and describe various data types
  • 3.4 Identify the benefits of using the %TYPE attribute
  • 3.5 Declare, use, and print bind variables
  • 4.1 List Lexical Units in a PL/SQL Block
  • 4.2 Use SQL Functions in PL/SQL
  • 4.3 Use Data Type Conversion
  • 4.4 Use Nested Blocks as Statements
  • 4.5 Reference an Identifier Value in a Nested Block
  • 4.6 Qualify an Identifier with a Label
  • 4.7 Use Operators in PL/SQL
  • 4.8 Using Sequences in PL/SQL Expressions
  • 5.1 Identify and use the SQL Statements in PL/SQL
  • 5.2 Retrieve Data in PL/SQL with the SELECT statement
  • 5.3 Avoid Errors by Using Naming Conventions When Using Retrieval and DML Statements
  • 5.4 Manipulate Data in the Server Using PL/SQL
  • 5.5 The SQL Cursor concept
  • 5.6 Use SQL Cursor Attributes to Obtain Feedback on DML
  • 5.7 Save and Discard Transactions
  • 6.1 Control PL/SQL Flow of Execution
  • 6.2 Conditional processing Using IF and CASE Statements
  • 6.3 Handle Nulls to Avoid Common Mistakes
  • 6.4 Build Boolean Conditions with Logical Operators
  • 6.5 Use Iterative Control with Looping Statements
  • 7.1 Learn the Composite Data Types of PL/SQL Records and Tables
  • 7.2 Use PL/SQL Records to Hold Multiple Values of Different Type
  • 7.3 Inserting and Updating with PL/SQL Records
  • 7.4 Use INDEX BY Tables to Hold Multiple Values of the Same Data Type
  • 8.1 Define Cursors
  • 8.2 Explain Explicit Cursor Operations
  • 8.3 Controlling Explicit Cursors
  • 8.4 Use Explicit Cursors to Process Rows
  • 8.5 Cursors and Records
  • 8.6 Cursor FOR Loops Using Subqueries
  • 8.7 Explicit Cursor Attributes
  • 8.8 The %NOTFOUND and %ROWCOUNT Attributes
  • 9.1 Define Exception
  • 9.2 Handling Exceptions with PL/SQL
  • 9.3 Predefined Exceptions
  • 9.4 Trapping Predefined and Non-predefined Oracle Server Errors
  • 9.5 Functions that Return Information on Encountered Exceptions
  • 9.6 Trapping User-Defined Exceptions
  • 9.7 Propagate Exceptions
  • 9.8 Basic RAISE Statement
  • 10.1 Overview of Stored Procedures and Functions
  • 10.2 Differentiate between anonymous blocks and subprograms
  • 10.4 Understand the Header Area of a Stored Procedure and Function
  • 10.5 Create Simple Procedures and Functions
  • 10.6 Create a Simple Procedure with an IN Parameter
  • 10.7 Execute a Procedure and a Function

Exam & Certification


** The above course information is taken from Oracle.

* Money Back Guarantee till demo and 1st class of the course.

Enhance your Skill

Drop us a Query

Copyright © 2015, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.