651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

Oracle Database 19c: PL/SQL Workshop

5 Days

Description

This is a complete course on PL/SQL including an introduction to Programming and Managing the PL/SQL code. 

Skills Gained

  • Get an overview of PL/SQL
  • Learn how to declare variables
  • Write executable statements
  • Learn how to use SQL statements in PL/SQL Programming

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Oracle Database 19c: PL/SQL Workshop class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

Course Outline

  • Declaring PL/SQL Variables
  • Writing Executable Statements
  • Using SQL Statements Within a PL/SQL Block
  • Writing Control Structures
  • Working with Composite Data Types
  • Using Explicit Cursors
  • Handling Exceptions
  • Creating Procedures and Functions
  • Debugging Subprograms
  • Creating and working with Packages
  • Using Oracle-Supplied Packages in Application Development
  • Using Dynamic SQL
  • Creating Compound, DDL, and Event Database Triggers
  • Design Considerations for the PL/SQL Code
  • Tuning the PL/SQL Compiler
  • Managing Dependencies
  • Using SQL Developer and SQL*Plus
  • Commonly Used SQL Commands
  • REF Cursors
  • Managing PL/SQL Code
  • Implementing Triggers
  • Using the DBMS_SCHEDULER and HTP Packages

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Oracle Database 19c: PL/SQL Workshop class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date


About us

Knowledge Transfer Consulting Services Inc. is a single-source solution provider offering a full range of Training Delivery and Training Management solutions from concept to delivery. Learn more

Find a Course

Corporate Services

Contact us

follow us on social media: