Course Outline
Introduction to PL/SQL
- Defining PL/SQL
- Key benefits of utilizing PL/SQL
Foundational Structure of a PL/SQL Block
- Anonymous blocks
- Named blocks
Variables and Data Types
- Declaring variables
- Syntactic rules and conventions
- Data types supported in PL/SQL
- Integrating variables within PL/SQL blocks
Control Structures
- IF-THEN-ELSE logic
- CASE statements
- FOR loops
- WHILE loops
Stored Procedures and Functions
- Developing and executing stored procedures
- Syntax and illustrative examples
- Input and output parameters
- Building and running functions in PL/SQL
- Syntax and illustrative examples
- Applying functions within SQL statements
Cursors
- Explicit cursors
- Implicit cursors
- Fetching data
- Cursor attributes
Exception Handling
- Predefined exceptions
- User-defined exceptions
- Utilizing TRY-CATCH blocks
Transaction Control
- Managing transactions in PL/SQL
- Employing nested blocks and transactions
- Overseeing nested transactions
- Establishing and utilizing savepoints
Advanced Cursor Techniques
- Strong vs. weak REF CURSOR
- Practical usage scenarios
Triggers
- Constructing triggers
- Categories of triggers
- Leveraging triggers for auditing purposes
Packages in PL/SQL
- Creation process
- Specification
- Implementation
- Execution
- Invocation
- Real-world applications
- Code analysis and walkthrough
Conclusion and Future Steps
Requirements
- A fundamental grasp of SQL concepts
- A clear understanding of database schemas, tables, and their relationships
Intended Audience
- Database administrators
- Database developers
- Software developers
- Data analysts
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.
