Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to PL/SQL
- What is PL/SQL?
- Advantages of using PL/SQL
Basic Structure of a PL/SQL Block
- Anonymous blocks
- Named blocks
Variables and Data Types
- Declaration of variables
- Syntax and rules
- Data types in PL/SQL
- Using variables in PL/SQL blocks
Control Structures
- IF-THEN-ELSE
- CASE statements
- FOR loops
- WHILE loops
Stored Procedures and Functions
- Creating and running stored procedures
- Syntax and examples
- Input and output parameters
- Creating and executing functions in PL/SQL
- Syntax and examples
- Usage in SQL statements
Cursors
- Explicit cursors
- Implicit cursors
- Fetching data
- Cursor attributes
Exception Handling
- Predefined exceptions
- User-defined exceptions
- Using TRY-CATCH blocks
Transaction Control
- Transaction control in PL/SQL
- Using nested blocks and transactions
- Managing nested transactions
- Creating and using savepoints
Advanced Cursor Techniques
- Strong vs. weak REF CURSOR
- Usage scenarios
Triggers
- Creating triggers
- Types of triggers
- Using triggers for auditing
Packages in PL/SQL
- Creation
- Specification
- Implementation
- Execution
- Invocation
- Real-world application
- Code walkthrough
Summary and Next Steps
Requirements
- Basic understanding of SQL
- Understanding of database schemas, tables, and relationships
Audience
- Database administrators
- Database developers
- Software developers
- Data analysts
21 Hours
Testimonials (3)
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.