Course Outline
Getting Started with PL/SQL
- Defining PL/SQL and its core purpose
- Key benefits of incorporating PL/SQL into development
Foundations of PL/SQL Block Structure
- Understanding anonymous blocks
- Working with named blocks
Working with Variables and Data Types
- Proper declaration of variables
- Syntax rules and best practices
- Exploring data types available in PL/SQL
- Applying variables within PL/SQL blocks
Implementing Control Structures
- Using IF-THEN-ELSE logic
- Employing CASE statements
- Utilizing FOR loops
- Utilizing WHILE loops
Developing Stored Procedures and Functions
- Creating and executing stored procedures
- Reviewing syntax and practical examples
- Managing input and output parameters
- Creating and running functions in PL/SQL
- Reviewing syntax and practical examples
- Integrating functions into SQL statements
Mastering Cursors
- Using explicit cursors
- Understanding implicit cursors
- Fetching and processing data
- Interpreting cursor attributes
Effective Exception Handling
- Leveraging predefined exceptions
- Defining custom user exceptions
- Applying TRY-CATCH mechanisms
Managing Transaction Control
- Controlling transactions within PL/SQL
- Working with nested blocks and transactions
- Managing nested transaction flows
- Creating and utilizing savepoints
Advanced Cursor Strategies
- Distinguishing between strong and weak REF CURSORs
- Identifying optimal usage scenarios
Implementing Triggers
- Building effective triggers
- Understanding different trigger types
- Utilizing triggers for auditing purposes
Working with PL/SQL Packages
- Package creation basics
- Writing specifications
- Developing implementations
- Executing package components
- Invoking package methods
- Applying concepts to real-world scenarios
- Detailed code walkthrough
Conclusion and Future Directions
Requirements
- Familiarity with fundamental SQL concepts
- Working knowledge 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.
