Certificate in PL/SQL

How It Works

  1. 1. Select Certification & Register
  2. 2. Receive Online e-Learning Access (LMS)
  3. 3. Take exam online anywhere, anytime
  4. 4. Get certified & Increase Employability

Test Details

  • Duration: 60 minutes
  • No. of questions: 50
  • Maximum marks: 50, Passing marks: 25 (50%).
  • There is NO negative marking in this module.
  • Online exam.

Benefits of Certification

$49.00 /-
Download Brochure

Why should I take this certification?

PL/SQL is Procedural Language extension of SQL. A PL/SQL program can have both SQL & procedural statements. In the PL/SQL program the SQL statements are used to access sets of data stored in a database, while the procedural statements are used to process individual piece of data & control the program flow.

This certification will teach you programming in Oracle PL/SQL.

How will I benefit from this certification?

Mastering PL/SQL gives you a very lucrative skill. Oracle and SQL It is the only language used to build business logic within an oracle database. Jobs in PL/SQL are many and highly paid. Knowing PL/SQL could double your income if you are already an SQL developer.

PL/SQL Table of Contents


PL/SQL Practice Questions


PL/SQL Practice Questions


Companies that hire PL/SQL Developers

PL/SQL Developer professionals are in great demand and companies in India looking for oracle database application development are hiring them. Vskills certified professionals will find job opportunities in top tier companies like HCL, Tech Mahindra, Sify Ltd, TCS, Cognizant, Infosys, Wipro, IBM, Dell, Capgemini, Mindtree etc.

PL/SQL Blogs

Checkout the latest online blogs on PL/SQL.


Checkout the various job openings for PL/SQL Developer, click here..

PL/SQL Internships

Vskills runs its flagship internship programme where bright interns work with academic council, click to know more details..

Apply for PL/SQL Developer Certification

By Net banking / Credit Card/Debit Card

We accept Visa/Master/Amex cards and all Indian Banks Debit Cards. There is no need to fill application form in case you are paying online.

Please click buy now to proceed for online payments.

  • Visa Card
  • Master Card
  • American Express


Buy Now

PL/SQL Introduction
  • Relational database, oracle and PL/SQL
  • PL/SQL need and benefits
  • Hardware and software pre-requisites
  • Oracle environment configure and test
PL/SQL programming constructs
  • Lexical elements and basic data types
  • Constants, variables, operators and expressions
  • Conditional and loop construct
  • Overloading and recursion
Code Block
  • Procedure and functions
  • Packages, INSTEAD OF and triggers
  • Compilation errors
  • Exception handling and custom exception
  • Declaration and defining
  • Implicit cursors
  • Cursor variables, using PL/SQL functions, record updates and shortcuts
Code Management
  • Packaging and placement of code and triggers in database
  • Code placement in application server
  • Naming standard basics, need and norms
Advanced Datatypes
  • Clob, blob and bfile
  • Custom data types
  • Varray and bulk collect
Transaction Processing
  • Commit and rollback
  • Autonomous transactions


PL/SQL Introduction
  • Understanding basics and terminologies of relational database, oracle and PL/SQL
  • Explaining the usage of PL/SQL in oracle DBMS
  • Describing the need and benefits of PL/SQL for triggers and server-side code
  • Detailing the hardware and software requirements for Oracle and PL/SQL
  • Describing the steps for configuring and testing oracle environment and connectivity
PL/SQL programming constructs
  • Illustrating the various lexical elements and basic data types in PL/SQL
  • Describing the concepts of constants, variables, operators and expressions
  • Explaining the various conditional and loop constructs offered by PL/SQL
  • Understanding the usage of overloading and recursion
Code Block
  • Detailing concepts of procedure, functions, packages, instead of and triggers
  • Explaining techniques for handling compilation errors and exception with adding custom exception
  • Describing the steps for declaration and definition of cursors
  • Detailing usage of implicit cursors
  • Understanding the usage of cursor variables, PL/SQL functions, record updates and Shortcuts in PL/SQL
Code Management
  • Explaining the steps for packaging and placement of code and triggers in database
  • Illustrating the process, advantages and disadvantages of code placement in application server
  • Detailing the basics of naming standard, it’s need and norms to follow
Advanced Datatypes
  • Understanding usage of clob, blob and bfile data types
  • Detailing the implementation of custom data types
  • Explaining varray and bulk collect for bulk data operations
Transaction Processing
  • Describing the concepts and usage of commit and rollback of transactions in PL/SQL
  • Explaining the autonomous transactions

Write a review

Please login or register to review

 For Support