• Classroom
  • Online, Instructor-Led
Course Description

The Oracle PL/SQL language extends SQL by adding the constructs found in other procedural languages, such as variables and control structures, thus allowing for a flexible procedural extension to SQL. In this course students learn the basic syntax and statements used to create functioning PL/SQL blocks. Students write different types of PL/SQL blocks, including anonymous blocks, named blocks, procedures and functions. Packages will also be discussed.

Learning Objectives

Learn the basic syntax and statements used to create functioning PL/SQL blocks. Students write different types of PL/SQL blocks, including anonymous blocks, named blocks, procedures and functions

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.