Facebook Pixel
Microsoft Certification Training
Search classes by keyword:
Search classes by category:
Microsoft Certification and Microsoft Training, Cisco Certification and MCSE Certification
Oracle Database 19c PL/SQL space


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

Oracle Database 19c: PL/SQL Workshop

Course Number: #CED-1742
Course Length: 5 days

Grants (discounts) are available for multiple students for the same or different courses.

Upcoming Dates Class Times Class Format Quote
7/28 - 8/1, 2025 9:00 AM - 5:00 PM ET
8:00 AM - 4:00 PM CT
6:00 AM - 2:00 PM PT
3:00 AM - 11:00 AM HT
Instructor-Led Instant Quote
10/6 - 10/10, 2025 9:00 AM - 5:00 PM ET
8:00 AM - 4:00 PM CT
6:00 AM - 2:00 PM PT
3:00 AM - 11:00 AM HT
Instructor-Led Instant Quote

Watch a Live Class in Progress and save $250 on your next 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

    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.



    Oracle Database 19c PL/SQL space
    Search classes by keyword:
    Search classes by category:


    Copyright © 2025 CED Solutions. CED Solutions Refund Policy. All Rights Reserved.