Course Outline
Introduction to PL/SQL
- Overview of PL/SQL
- Benefits of adopting PL/SQL
Fundamental Structure of PL/SQL Blocks
- Anonymous blocks
- Named blocks
Variables and Data Types
- Declaring variables
- Syntax and governing rules
- Data types available in PL/SQL
- Integrating variables into PL/SQL blocks
Control Flow Structures
- IF-THEN-ELSE logic
- CASE statements
- FOR loops
- WHILE loops
Stored Procedures and Functions
- Creating and executing stored procedures
- Syntax and practical examples
- Handling input and output parameters
- Developing and running PL/SQL functions
- Syntax and practical examples
- Incorporating functions into SQL statements
Cursors
- Explicit cursors
- Implicit cursors
- Data fetching mechanisms
- Cursor attributes
Exception Management
- Predefined exceptions
- User-defined exceptions
- Application of exception handling blocks
Transaction Management
- Controlling transactions in PL/SQL
- Utilizing nested blocks and transactions
- Managing nested transaction flows
- Establishing and using savepoints
Advanced Cursor Methodologies
- Strong vs. weak REF CURSOR
- Applicable use cases
Triggers
- Trigger creation
- Categorization of trigger types
- Leveraging triggers for audit purposes
PL/SQL Packages
- Package creation
- Specification phase
- Implementation phase
- Execution mechanisms
- Invocation methods
- Real-world applications
- Code review and walkthrough
Conclusion and Subsequent Actions
Requirements
- Fundamental knowledge of SQL
- Familiarity with database schemas, tables, and inter-table 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.
