Course Outline
Introduction to PL/SQL
- Defining PL/SQL
- Key benefits of adopting PL/SQL
Foundational Structure of a PL/SQL Block
- Anonymous blocks
- Named blocks
Variables and Data Types
- Declaring variables
- Syntactical rules and conventions
- Available data types in PL/SQL
- Applying variables within PL/SQL blocks
Control Structures
- IF-THEN-ELSE logic
- CASE statements
- FOR loops
- WHILE loops
Stored Procedures and Functions
- Development and execution of stored procedures
- Syntax and illustrative examples
- Managing input and output parameters
- Construction and execution of PL/SQL functions
- Syntax and practical examples
- Integrating functions into SQL statements
Cursors
- Explicit cursors
- Implicit cursors
- Data fetching mechanisms
- Cursor attributes
Exception Handling
- Predefined exceptions
- Custom user-defined exceptions
- Application of TRY-CATCH blocks
Transaction Control
- Managing transactions in PL/SQL
- Leveraging nested blocks for transaction management
- Controlling nested transactions
- Creating and utilizing savepoints
Advanced Cursor Techniques
- Distinguishing between strong and weak REF CURSOR
- Appropriate usage scenarios
Triggers
- Creation of triggers
- Different types of triggers
- Leveraging triggers for auditing purposes
PL/SQL Packages
- Package creation
- Specification details
- Implementation logic
- Execution methods
- Invocation techniques
- Real-world application cases
- Detailed code walkthrough
Summary and Path Forward
Requirements
- Fundamental knowledge of SQL
- Comprehension 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.
