Need some help ? Call us:+352 20 30 10 60

Oracle Database 12c R2: Program with PL/SQL - Live Virtual Classes

This Database Program with PL/SQL training shows you how to develop stored procedures, functions, packages and database triggers. You’ll learn to manage PL/SQL program units and dependencies, while using of some of the Oracle-supplied packages

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more.

Learn To:

  • Conditionally control code flow (loops, control structures).
  • Create stored procedures and functions.
  • Use PL/SQL packages to group and contain related constructs.
  • Create triggers to solve business challenges.
  • Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
  • Create custom packages for applications.
  • Write Dynamic SQL code for applications.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Use Oracle SQL Developer

You will use Oracle SQL Developer to develop these program units. SQL*Plus is introduced in this course as optional tools.

Course Bundle

Note: This course is a combination of Oracle Database: PL/SQL Fundamentals and Oracle Database: Develop PL/SQL Program Units courses.

  • Database Administrator
  • Developer
  • Implementer
  • Systems Administrator

You might also be interested in:


Oracle Database Security: Preventive Controls - Live Virtual Classes

In the Oracle Database Security: Preventive Controls course, students learn how they can
use Oracle Database Security products and technologies to meet the security, privacy and
compliance requirements of their organization. The current regulatory environment of
the Sarbanes-Oxley Act, HIPAA, the UK Data Protection Act, and others, requires better
security at the database level. Students learn how to secure the access to their databases
and how to use the Oracle Database Security products and technologies that enhance
data access and confidentiality. The course provides suggested Oracle solutions for
common problems.

MySQL Performance Tuning - Live Virtual Classes

This course provides experienced MySQL DBAs with knowledge of how and why server settings affect performance, and when and how to tune them. It teaches students how to monitor their MySQL server and identify areas that impact performance, such as slow queries and replication lag, and how to diagnose and fix these issues.


Oracle Database 12c R2: Clusterware Administration - Live Virtual Classes

This Oracle Database 12c: Clusterware Administration training will explore general cluster
concepts and Oracle Clusterware architecture. Work with expert Oracle University
instructors through interactive instruction and hands-on exercises to reinforce your
learning.In this course, you will be introduced to Oracle Database Exadata Cloud Service.