Live Oracle Database 19c: PL/SQL Workshop Training Course

Watch a Live Class in Progress and save $250 on your next course.

See what makes CED Solutions the best choice for your IT Training.

This is a live class in progress - please mute your microphone and be respectful of the students attending.

Instructor-Led

Certified Instructor

Includes all course materials

Instant Quote

Can't travel or you want to stay with your family or business. No problem!

Stay in your own city and save the additional expenses of roundtrip airfare, lodging, transportation, and meals and receive the same great instruction live from our instructors in our Live Instructor-Led Remote Classroom Training.

Remote Classroom Training

Our Remote Classroom Training is a live class with students observing the instructor and listening through your computer speakers.

You will see the instructor's computer, slides, notes, etc., just like in the classroom. You will be following along, doing work, labs, and individual assignments.

CED Solutions Rewards Points Program

"Great instructor! Instructor was very knowledgeable about Oracle and prepared properly for the test. He answered every question thoroughly. Also, he kept the mood light and humorous."

-K McGovern

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

CED Solutions 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 boot camp, Oracle Database 19c PL/SQL certification training, Oracle Database 19c PL/SQL certification course, Oracle Database 19c PL/SQL course, Oracle Database 19c PL/SQL class.