Course Outline
Introduction to PL/SQL
- Defining PL/SQL
- Key benefits of PL/SQL adoption
Core Structure of PL/SQL Blocks
- Working with anonymous blocks
- Using named blocks
Variables and Data Types
- Variable declaration syntax
- Governing rules and syntax standards
- Supported data types in PL/SQL
- Integrating variables into PL/SQL blocks
Control Structures
- Implementing IF-THEN-ELSE logic
- Using CASE statements
- Managing FOR loops
- Handling WHILE loops
Stored Procedures and Functions
- Creating and executing stored procedures
- Syntax and practical examples
- Managing input and output parameters
- Developing and running PL/SQL functions
- Syntax and practical examples
- Applying functions within SQL statements
Cursors
- Working with explicit cursors
- Understanding implicit cursors
- Data fetching techniques
- Utilizing cursor attributes
Exception Handling
- Leveraging predefined exceptions
- Creating user-defined exceptions
- Implementing TRY-CATCH block structures
Transaction Control
- Managing transactions in PL/SQL
- Using nested blocks and transactions
- Handling nested transactions
- Creating and utilizing savepoints
Advanced Cursor Techniques
- Differentiating between strong and weak REF CURSORs
- Identifying optimal usage scenarios
Triggers
- Building database triggers
- Exploring different trigger types
- Applying triggers for audit logging
PL/SQL Packages
- Package creation process
- Writing package specifications
- Implementing package bodies
- Executing package components
- Invoking package procedures and functions
- Real-world application case studies
- Detailed code walkthroughs
Summary and Next Steps
Requirements
- Familiarity with fundamental SQL concepts.
- A solid grasp of database schemas, tables, and their relationships.
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.
