Course Outline
Introduction to PL/SQL
- Defining PL/SQL
- Key benefits of PL/SQL adoption
Foundational PL/SQL Block Structure
- Anonymous blocks
- Named blocks
Variables and Data Typing
- Variable declaration standards
- Syntactic rules and conventions
- Available data types in PL/SQL
- Integrating variables into PL/SQL logic
Control Flow Mechanisms
- IF-THEN-ELSE logic
- CASE statement implementation
- FOR loop construction
- WHILE loop construction
Stored Procedures and Functions
- Authoring and executing stored procedures
- Syntax guidelines and practical examples
- Managing input and output parameters
- Creating and invoking functions
- Syntax guidelines and practical examples
- Integrating functions into SQL statements
Cursor Management
- Explicit cursor definitions
- Implicit cursor behavior
- Data fetching techniques
- Utilizing cursor attributes
Exception Handling Strategies
- Working with predefined exceptions
- Designing user-defined exceptions
- Applying TRY-CATCH constructs
Transaction Management
- Controlling transactions within PL/SQL
- Utilizing nested blocks for transaction scope
- Managing nested transaction flows
- Implementing and leveraging savepoints
Advanced Cursor Concepts
- Distinguishing strong vs. weak REF CURSORs
- Identifying optimal usage scenarios
Trigger Development
- Constructing database triggers
- Categorizing trigger types
- Applying triggers for audit logging
PL/SQL Package Engineering
- Package creation workflows
- Defining specifications
- Writing implementations
- Execution strategies
- Procedures for invocation
- Real-world application case studies
- Detailed code walkthroughs
Conclusion and Path Forward
Requirements
- Fundamental knowledge of SQL
- Conceptual understanding of database schemas, tables, and relational structures
Target Audience
- Database administrators
- Database developers
- Software engineers
- 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.
