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 programs in Oracle, build stored procedures, design and execute modular applications, and increase the efficiency of data movement — essential skills for any Oracle developer.
Oracle PL/SQL Programming Training Delivery Methods
In-Person
Online
Oracle PL/SQL Programming Training Course Information
This Oracle PL/SQL Programming training will prepare you to:
Develop efficient PL/SQL programs 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
Oracle PL/SQL Programming Training Course Prerequisites
Students taking this course should have knowledge and experience at the level of:
4thdacad course 2226, Introduction to Oracle Database 12c Training
4thdacad course 925, Introduction to SQL Training
PL/SQL Course Outline
Module 1: Introduction and Overview
PL/SQL fundamentals
Declaring and anchoring variables to database definitions
Flow control constructs
Oracle 11g and 12c PL/SQL features
PL/Scope in Oracle 11g
Returning implicit cursor results from stored procedures in Oracle 12c
Declaring local functions within SELECT statements in Oracle 12c
Module 2: Data Manipulation Techniques
Module 3: Developing Well-Structured and Error-Free Code
Module 4: Achieving Maximum Reusability
Module 5: Exploiting Complex Datatypes
Module 6: Invoking Native Dynamic SQL
Module 7: Package Tips and Techniques
العربية