Course Outline
Introduction to PL/SQL
- Definition and overview of PL/SQL.
- Key benefits of employing PL/SQL.
Foundational Structure of a PL/SQL Block
- Working with anonymous blocks.
- Utilizing named blocks.
Variables and Data Types
- Variable declaration processes.
- Adherence to syntax and coding rules.
- Overview of data types available in PL/SQL.
- Applying variables within PL/SQL blocks.
Control Structures
- IF-THEN-ELSE logic.
- Implementation of CASE statements.
- Usage of FOR loops.
- Usage of WHILE loops.
Stored Procedures and Functions
- Creating and executing stored procedures.
- Syntax guidelines and practical examples.
- Managing input and output parameters.
- Development and execution of PL/SQL functions.
- Syntax guidelines and practical examples.
- Integrating functions into SQL statements.
Cursors
- Explicit cursor management.
- Implicit cursor behavior.
- Data fetching techniques.
- Utilizing cursor attributes.
Exception Handling
- Handling predefined exceptions.
- Defining custom exceptions.
- Application of exception handling blocks (conceptually TRY-CATCH).
Transaction Control
- Managing transactions within PL/SQL.
- Utilizing nested blocks for transaction control.
- Oversight of nested transactions.
- Creation and usage of savepoints.
Advanced Cursor Techniques
- Distinguishing between strong and weak REF CURSORs.
- Identifying appropriate usage scenarios.
Triggers
- Process for creating triggers.
- Classification of trigger types.
- Leveraging triggers for audit logging.
PL/SQL Packages
- Package creation workflow.
- Defining specifications.
- Writing implementations.
- Execution strategies.
- Invocation methods.
- Practical real-world applications.
- Code walkthrough and analysis.
Summary and Future Learning Pathways
Requirements
- Fundamental knowledge of SQL
- Understanding of database schemas, tables, and their relationships
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.
