Oracle Database 19c: PL/SQL Workshop

This 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.

Course Objectives

• Declare Variables
• Write Executable Statements
• Write Control Structures
• Create Procedures and Functions
• Create Packages
• Create Triggers

Who Should Attend?

• Database Administrators
• Developers

Course Prerequisites

Oracle Database 19c: SQL Workshop

Agenda

• Introduction
• Introduction to PL/SQL
• 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
• Introducing Stored Procedures and Functions
• Creating Procedures
• Creating Functions
• Debugging Subprograms
• Creating Packages
• Working With Packages
• Using Oracle Supplied Packages in Application Development
• Using Dynamic SQL
• Creating Triggers
• Creating Compound, DDL and Event Database Triggers
• Design Considerations for the PL/SQL Code
• Tuning the PL/SQL Compiler
• Managing Dependencies

IPLearning.net is your best choice for Oracle Database 19c PL/SQL, Oracle Database 19c PL/SQL training, Oracle Database 19c PL/SQL certification, Oracle Database 19c PL/SQL certification boot camp, Oracle Database 19c PL/SQL boot camp, Oracle Database 19c PL/SQL certification training, Oracle Database 19c PL/SQL boot camp training, Oracle Database 19c PL/SQL boot camp certification, Oracle Database 19c PL/SQL certification course, Oracle Database 19c PL/SQL course, training Oracle Database 19c PL/SQL, certification Oracle Database 19c PL/SQL, boot camp Oracle Database 19c PL/SQL, certification Oracle Database 19c PL/SQL boot camp, certification Oracle Database 19c PL/SQL training, boot camp Oracle Database 19c PL/SQL training, certification Oracle Database 19c PL/SQL course.