Skip to main content

Oracle® SQL Training

Code: 493 Category: Tag:

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



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

Request Quotes

Register now

Please type the characters This helps us prevent spam, thank you.

CISSP® Training and Certification Prep Course

Chef Foundations Training

FPM 233 Training: Applications in Business, Cost & Financial Management

VMware Horizon 8: Deploy and Manage

Azure Stack HCI Training (WS-013)

Citrix Virtual Apps and Desktops 7, App Layering and WEM Administration (Fast Track) (CMB-318)

Cisco Optical Technology Advanced (OPT300)

Influencing Collaborative Solutions: Duke CE Certificate Course

Planning & Designing Databases on AWS

Securing Networks with Cisco Firepower Next-Generation IPS (SSFIPS v3.0) Training