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.
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.
|
Follow CED