Oracle® PL/SQL Programming

€2,800.00

Oracle® PL/SQL Training

Course Description:

This Oracle® PL/SQL training course will teach you to increase the productivity, performance, scalability, portability, and security of your Oracle database. With this training, you will learn how to execute PL/SQL programmes in Oracle, build stored procedures, design and execute modular applications, and increase the efficiency of data movement — essential skills for any Oracle developer.

Course Outline:

Introduction and Overview
Data Manipulation Techniques
Developing Well-Structured and Error-Free Code
Achieving Maximum Reusability
Exploiting Complex Datatypes
Invoking Native Dynamic SQL
Package Tips and Techniques

For a detailed course outline, kindly click here.

Learning Outcomes:

Develop efficient PL/SQL programmes to access Oracle databases
Create stored procedures and functions for reuse and maintenance
Design modular applications using packages
Manage data retrieval for front-end applications
Invoke native dynamic SQL to develop high-level abstract code

Key Features of this Oracle® PL/SQL Training:

After-course instructor coaching benefit
End of course examination included

Prerequisites:

Students taking this course should have basic knowledge of SQL as taught in Introduction to SQL Course.

Dates:

This course runs for 5 days and, in order to provide you with more flexibility, you may opt for the morning to afternoon option or the afternoon to evening option. Contact us by email on kla@kpmg.com.mt or by telephone on 2563 6363 for further information on the upcoming dates.