The illustrations were created in cooperation between humans and artificial intelligence. They show a future in which technology is omnipresent, but people remain at the center.
AI-generated illustration
Oracle PL/SQL - The course for advanced users
Triggers, dynamic SQL and advanced functions
Online
.svg)
2 days
.svg)
German
€ 1.860,-
plus VAT.
€ 2.213,40
incl. VAT.
Booking number
36178
Venue
Online
.svg)
2 dates
€ 1.860,-
plus VAT.
€ 2.213,40
incl. VAT.
Booking number
36178
Venue
Online
2 dates
plus VAT.
incl. VAT.
Booking number
Venue
0 Dates
Become a certified
Machine Learning Engineer
Machine Learning Engineer
This course is part of the certified Master Class "Machine Learning Engineer". If you book the entire Master Class, you save over 15 percent compared to booking this individual module.
To the Master Class
In-house training
In-house training just for your employees - exclusive and effective.
Inquiries
In cooperation with
This workshop, which builds on PL/SQL basics, covers more advanced functionalities. The topics range from packages and triggers to PL/SQL arrays, pipelined table functions and bulk operations.
Contents
- Packages - advantages, structure, overloading, package variables
- REF Cursor - Purpose, Definition Strong versus Weak REF Cursor, SYS_REFCURSOR
- PL/SQL arrays - intended use, types (real, associative, varrays and nested tables)
- Dynamic SQL
- Static versus dynamic SQL
- EXECUTE IMMEDIATE
- DBMS_SQL
- Some Oracle provided packages
- DBMS_OUTPUT
- UTL_FILE
- DBMS_SCHEDULER
- UTL_MAIL
- DBMS_UTILITY
- etc.
- Trigger
- Trigger types: DML, Instead-of, Logon, Database Event Trigger
- Timing: BEFORE, AFTER, INSEAD OF
- Level: STATEMENT or ROW
- Mutating Table Trigger
- Functions for advanced users
- Records as a return value
- TABLE Operator
- REF Cursor as parameter
- Pipelined Table Functions
- Bulk Operations - what is it and why should you use it?
Your benefit
- Advanced knowledge of Oracle PL/SQL
- Understanding packages and triggers
- Knowledge of PL/SQL arrays, pipelined table functions and bulk operations
Peter Renner
Methods
This course consists of training training and is led by a trainer who supervises the participants live. Theory and practice are taught with live demonstrations and practical exercises. The video conferencing software Zoom is used.
Final examination
Recommended for
This workshop is aimed at prospective Oracle database administrators, Oracle developers or architects, generally anyone who has to do with Oracle SQL. PL/SQL programming knowledge is required. Basic SQL knowledge is a prerequisite.
.svg)
