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.

Leveraging Cisco Intent-Based Networking DNA Assurance (DNAAS)

Implementing Cisco Enterprise Advanced Routing and Services (ENARSI)

Finance and Accounting Training for Nonfinancial Managers

Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack Hub (AZ-600)

SAP SCM500 – Processes in Procurement Training

Enterprise Product Owner Training (ICP-EPO Certification)

ITIL® 4 Specialist: High-Velocity IT Training

ITIL® 4 Specialist: Drive Stakeholder Value Training

Securing Networks with Cisco Firepower Next-Generation IPS (SSFIPS)

Time Management Training