Course Outline
Introduction to PL/SQL
- Overview of PL/SQL.
- Key benefits of utilizing PL/SQL.
Fundamentals of PL/SQL Block Structure
- Working with anonymous blocks.
- Utilizing named blocks.
Variables and Data Types
- Declaring variables effectively.
- Syntax rules and conventions.
- Exploring PL/SQL data types.
- Integrating variables into PL/SQL blocks.
Control Structures
- Implementing IF-THEN-ELSE logic.
- Using CASE statements.
- Applying FOR loops.
- Utilizing WHILE loops.
Stored Procedures and Functions
- Creating and executing stored procedures.
- Reviewing syntax and practical examples.
- Managing input and output parameters.
- Developing and running PL/SQL functions.
- Examining syntax and illustrative examples.
- Incorporating functions into SQL statements.
Cursors
- Working with explicit cursors.
- Understanding implicit cursors.
- Fetching data from cursors.
- Using cursor attributes.
Exception Handling
- Managing predefined exceptions.
- Creating user-defined exceptions.
- Applying TRY-CATCH block structures.
Transaction Control
- Managing transactions within PL/SQL.
- Using nested blocks and transactions.
- Controlling nested transactions.
- Creating and leveraging savepoints.
Advanced Cursor Techniques
- Distinguishing between strong and weak REF CURSORS.
- Identifying appropriate usage scenarios.
Triggers
- Developing database triggers.
- Exploring different trigger types.
- Leveraging triggers for auditing purposes.
PL/SQL Packages
- Package creation process.
- Writing specifications.
- Defining implementations.
- Executing package components.
- Invoking package elements.
- Real-world application examples.
- Detailed code walkthrough.
Summary and Next Steps
Requirements
- Fundamental knowledge of SQL.
- Comprehension of database schemas, tables, and their interrelationships.
Target Audience
- Database administrators.
- Database developers.
- Software developers.
- Data analysts.
Testimonials (5)
The PL/SQL session basics. I used PL/SQL but never got the basics of it and this course helped me a lot understand PL/SQL queries.
Stefan-Andrei
Course - PL/SQL in Oracle 19c
Very balanced training and practice oriented, very glad that I had the virtual machine and was able to work in parallel with trainer the exercises
Robert
Course - PL/SQL in Oracle 19c
Trainer was patient with us and he made sure we understood each section before moving forward.
RONIKA - Igaye Projects (PTY) LTD
Course - PL/SQL in Oracle 19c
The way he explained everything
Alexandra G - DB Global Technology
Course - PL/SQL in Oracle 19c
The exercises were explained very good.
