Overview

Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features. Learn how to leverage enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.

This OD-19c-PW: Oracle Database 19c: PL/SQL Workshop course introduces students to PL/SQL, Procedural Language for SQL. Explore the differences between SQL and PL/SQL. Examine the characteristics of PL/SQL and how it is used to extend and automate SQL.

Skills Covered

  • PLSQL programming structure
  • Using Explicit and Implicit Cursors in PLSQL
  • For, while and basic Loop Processing in PLSQL
  • Programmer Defined Procedures and Functions
  • Using UTL_FILE and Directories for I/O
  • Exception Handling

Who Should Attend

  • End users
  • Business analysts
  • Application developers
  • Database administrators

Course Curriculum

Prerequisites

Basic computer skills.

Download Syllabus

Course Modules

Request More Information

Training Options