Course Outline
Introduction to PL/SQL
- Defining PL/SQL.
- Key benefits of using PL/SQL.
Foundational Structure of PL/SQL Blocks
- Anonymous blocks.
- Named blocks.
Variables and Data Types
- Declaring variables.
- Syntax and governing rules.
- 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
- Creating and executing stored procedures.
- Syntax and practical examples.
- Managing input and output parameters.
- Developing and running functions in PL/SQL.
- Syntax and examples.
- Integrating functions within SQL statements.
Cursors
- Explicit cursors.
- Implicit cursors.
- Data fetching techniques.
- Utilizing cursor attributes.
Exception Handling
- Predefined exceptions.
- User-defined exceptions.
- Implementing exception handling blocks.
Transaction Control
- Managing transactions in PL/SQL.
- Using nested blocks and transactions.
- Handling nested transactions.
- Creating and utilizing savepoints.
Advanced Cursor Techniques
- Strong vs. weak REF CURSOR types.
- Applicable usage scenarios.
Triggers
- Creating triggers.
- Categorizing trigger types.
- Leveraging triggers for auditing purposes.
PL/SQL Packages
- Package creation.
- Writing the specification.
- Defining the implementation.
- Execution processes.
- Invocation methods.
- Real-world application examples.
- Code walkthrough and analysis.
Summary and Recommended Next Steps
Requirements
- Foundational knowledge of SQL.
- Understanding of database schemas, tables, and 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.
