Oracle 18c PL/SQL

PT20408
Summary
This course provides a complete, hands-on, comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL*Plus. This coverage is appropriate for both Oracle11g and higher.
Prerequisites
Before taking this course, Oracle12c SQL or higher or equivalent experience is required.
Duration
5 Days/Lecture & Lab
Audience
This course is appropriate for anyone needing to understand Oracle’s proprietary programming language. That would include end users, business analysts, application developers, and database administrators.
Topics
  • PL/SQL Program Structure
  • PL/SQL Flow Control
  • SQL Developer and PL/SQL
  • SELECT INTO
  • The PL/SQL Cursor
  • Optimization
  • PL/SQL Exception Handling
  • Stored Procedures
  • Creating Functions in PL/SQL
  • Packages
  • Creating DML Triggers
  • Advanced Concepts
  • File Operations
  • Communications
  • Security
  • Scheduling
  • Miscellaneous Packages
  • Database Triggers
  • Collections
  • Bulk Operations
  • Cursor Variables
  • Dynamic SQL
  • Large Objects
  • Object-Oriented Programming
  • Java and Other Languages

Related Scheduled Courses