Big Savings: Special offer Get FLAT 15% Instant Discount Get Details
Oracle® PL/SQL Online Training for Database Administrators

Oracle® PL/SQL Online Certification Training

Oracle® PL/SQL Online Training for Database Administrators

     3452 Learners       Add to wishlist

Play Video

Instructor-Led Online Training

  • 24 Hrs Training
  • Training Certificate
  • Experienced Trainer
  • 3 Mock Tests
$ 310
Training Schedule
Start Date End Date No. of Hrs Time (IST) Day  
30 Oct 2021 21 Nov 2021 24 06:00 PM - 09:00 PM Sat, Sun
13 Nov 2021 05 Dec 2021 24 06:00 PM - 09:00 PM Sat, Sun

Schedule does not suit you, contact us now!    |    Want to take one-on-one training, contact us now!

Course Overview

Every organization maintains a Database wherein it saves relevant data that can be used further to fetch the required information. To achieve this task, SQL commands are used in the database by applying specific statements. PL/SQL (Procedural Language/Structured Query Language) is a procedural extension of SQL which makes it easier to write the procedural code including SQL statements.

Oracle® Corporation extends the functionalities of PL/SQL with each launch of the Oracle® Database. PL/SQL is tightly integrated with SQL. It aids the users with advantages like high performance, high productivity, support to OOPS concepts, and full portability medium.

Students who attend the Oracle® 11g online course, learn the benefits of using PL/SQL, and identify the different types of PL/SQL blocks. Along with this, they get a deep understanding of using Explicit Cursors, Handling Exceptions, Constructing and identifying Loop Statements, Writing Control Structures, Creating Stored Procedures and Functions, Creating and Working with Packages and lot more.

After the successful completion of Oracle® PL/SQL online training, candidates can appear for the Fundamentals (1Z0-144) exam to aim for the Oracle® Advanced PL/SQL Developer Certified Professional and Oracle® PL/SQL Developer Certified Associate credentials. These certifications validate an individual’s expertise of handling databases and increase the professional abilities along with enhancing the career opportunities.

Course Contents

Course ContentDetailed Course Topics
  • Introduction to PL/SQL
  • Declaring PL/SQL Variables
  • Writing Executable Statements
  • Writing Control Structures
  • Using Explicit Cursors
  • Working with Composite Data Types (Collections)
  • Handling Exceptions
  • Creating Stored Procedures and Functions Introduction
  • Creating Stored Procedures
  • Creating Stored Functions
  • Creating Triggers
  • Creating Packages

Target Audience

  • Familiarity with data processing concepts and techniques
  • Ability to use a graphical user interface (GUI)


After completing the Oracle® PL/SQL 11g online training, individuals can go for (1Z0-144) exam and earn the Oracle® Database 11g Administrator Certified Associate (OCA) Certification.

Send us a Query


I agree to be contacted via e-mail.

Related Courses

Combo Offers

Get in Touch

Follow Us

We Accept Online Payments

Online Registration

Subscribe to our Newsletter

Contact Us


I agree to be contacted via e-mail.

  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP and SP are registered marks of the Project Management Institute, Inc.
  • PRINCE2® is a registered trade mark of AXELOS Limited
  • ITIL® is a registered trade mark of AXELOS Limited
  • MSP® is a registered trade mark of AXELOS Limited
  • The Swirl logoTM is a trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.

How can help you?