Course Outline
Introduction to PL/SQL
- Defining PL/SQL.
- Key benefits of adopting PL/SQL.
Foundations of PL/SQL Block Structure
- Working with anonymous blocks.
- Constructing named blocks.
Variables and Data Types
- Variable declaration techniques.
- Syntax and governing rules.
- Exploring data types in PL/SQL.
- Utilizing variables within PL/SQL blocks.
Control Structures
- IF-THEN-ELSE logic.
- CASE statement implementation.
- Iterating with FOR loops.
- Condition-based WHILE loops.
Stored Procedures and Functions
- Building and executing stored procedures.
- Syntax guidelines and examples.
- Managing input and output parameters.
- Creating and running functions in PL/SQL.
- Syntax guidelines and examples.
- Integrating functions into SQL statements.
Cursors
- Explicit cursor management.
- Implicit cursor usage.
- Data fetching mechanisms.
- Interpreting cursor attributes.
Exception Handling
- Handling predefined exceptions.
- Implementing user-defined exceptions.
- Applying TRY-CATCH block strategies.
Transaction Control
- Managing transactions in PL/SQL.
- Using nested blocks for transaction control.
- Overseeing nested transactions.
- Creating and leveraging savepoints.
Advanced Cursor Techniques
- Distinguishing between strong and weak REF CURSORs.
- Appropriate usage scenarios.
Triggers
- Creating database triggers.
- Categories of triggers.
- Leveraging triggers for auditing purposes.
Packages in PL/SQL
- Package creation process.
- Specification definition.
- Implementation details.
- Execution methods.
- Invocation techniques.
- Real-world application scenarios.
- Code walkthrough and analysis.
Summary and Future Pathways
Requirements
- Fundamental knowledge of SQL.
- Comprehension of database schemas, tables, and their relationships.
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.
