Course Outline
Introduction to PL/SQL
- Defining PL/SQL
- Benefits of adopting PL/SQL
Fundamental Structure of a PL/SQL Block
- Anonymous blocks
- Named blocks
Variables and Data Types
- Variable declaration
- Syntactical rules and constraints
- Data types supported in PL/SQL
- Integrating variables into PL/SQL blocks
Control Flow Structures
- IF-THEN-ELSE logic
- CASE statement implementation
- FOR loop mechanisms
- WHILE loop mechanisms
Stored Procedures and Functions
- Developing and executing stored procedures
- Syntax and illustrative examples
- Managing input and output parameters
- Creating and running functions in PL/SQL
- Syntax and illustrative examples
- Utilizing functions within SQL queries
Cursors
- Explicit cursor definition
- Implicit cursor usage
- Data fetching techniques
- Accessing cursor attributes
Exception Management
- System-provided exceptions
- Custom exception definitions
- Application of TRY-CATCH blocks
Transaction Management
- Controlling transactions within PL/SQL
- Employing nested blocks for transaction control
- Orchestrating nested transactions
- Establishing and utilizing savepoints
Advanced Cursor Strategies
- Comparison of Strong and Weak REF CURSORs
- Appropriate use cases and scenarios
Triggers
- Trigger creation
- Categorization of trigger types
- Leveraging triggers for audit trails
PL/SQL Packages
- Package creation
- Specifying package components
- Implementing package logic
- Execution processes
- Invocation methods
- Application in real-world scenarios
- Detailed code review
Conclusion and Future Directions
Requirements
- Fundamental knowledge of SQL
- Comprehension of database schemas, tables, and inter-table relationships
Intended Participants
- 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.
