Course Outline
Introduction to PL/SQL
- Definition and overview of PL/SQL.
- Key advantages of utilizing PL/SQL.
Foundations of PL/SQL Blocks
- Working with anonymous blocks.
- Working with named blocks.
Variables and Data Types
- Declaring variables.
- Relevant syntax and rules.
- Exploring PL/SQL data types.
- Integrating variables into PL/SQL blocks.
Control Structures
- Implementing IF-THEN-ELSE logic.
- Using CASE statements.
- Iterating with FOR loops.
- Iterating with WHILE loops.
Stored Procedures and Functions
- Development and execution of stored procedures.
- Syntactical rules and practical examples.
- Handling input and output parameters.
- Creating and running PL/SQL functions.
- Syntactical rules and practical examples.
- Incorporating functions into SQL statements.
Cursors
- Explicit cursors.
- Implicit cursors.
- Data retrieval techniques.
- Accessing cursor attributes.
Exception Handling
- Predefined exceptions.
- Custom-defined exceptions.
- Application of TRY-CATCH blocks.
Transaction Control
- Managing transactions in PL/SQL.
- Leveraging nested blocks for transaction management.
- Handling nested transactions.
- Implementing and using savepoints.
Advanced Cursor Techniques
- Distinguishing between strong and weak REF CURSORs.
- Practical usage scenarios.
Triggers
- Developing triggers.
- Categorizing trigger types.
- Applying triggers for auditing purposes.
PL/SQL Packages
- Creation process.
- Specification details.
- Implementation logic.
- Execution methods.
- Invocation techniques.
- Real-world applications.
- Code analysis and walkthrough.
Conclusion and Future Steps
Requirements
- Fundamental knowledge of SQL.
- Familiarity with 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.
