Oracle Database 23ai: PL/SQL tuning en beveiliging (Active Learning) (Virtueel)
Vijfhart IT-Opleidingen
Verdiep je Oracle PL/SQL-kennis met technieken voor packages, beveiliging, profiling, caching en performance-optimalisatie.
- Price
- from €1,485
- Level
- Not specified
- Kind
- Training
- Subject
- Automation and IT
More information and registration at Vijfhart IT-Opleidingen
Description
In de cursus Advanced PL/SQL leer je complexe PL/SQL-programma's ontwerpen, bouwen en optimaliseren. Je verdiept je kennis van Oracle PL/SQL en gebruikt geavanceerde technieken om code beter te structureren, beveiligen, analyseren en afstemmen op prestaties. Daarbij werk je onder meer met packages, subtypen, compile-time warnings, PL/SQL wrapping en conditioneel compileren. Je behandelt verschillende vormen van SQL-injectie en gebruikt bindvariabelen en DBMS_ASSERT om risico's in PL/SQL-code te beperken. Voor toegangsbeheer werk je met Virtual Private Database (VPD), security policies en Secure Application Context. Ook analyseer je PL/SQL-code met Oracle dictionary views en standaardpackages zoals DBMS_DESCRIBE en DBMS_METADATA. Met DBMS_TRACE, DBMS_PROFILER en DBMS_HPROF onderzoek je de uitvoering en prestaties van code. Daarnaast gebruik je de debugmogelijkheden van SQL Developer en werk je met PL/SQL Code Coverage. Tijdens de cursus werk je in een persoonlijke oefenomgeving met Oracle Database 23ai. Je ontwikkelt packages, past VPD en andere beveiligingstechnieken toe en onderzoekt hoe bestaande PL/SQL-code kan worden verbeterd.
Start dates
| Start | End | Place | Price |
|---|---|---|---|
| 23 November 2026 | 24 November 2026 | Online | €1,485 |
| 25 November 2026 | 26 November 2026 | Online | €1,485 |
| 1 December 2026 | 2 December 2026 | Online | €1,485 |
| 3 December 2026 | 4 December 2026 | Online | €1,485 |
| 9 December 2026 | 10 December 2026 | Online | €1,485 |
| 11 December 2026 | 14 December 2026 | Online | €1,485 |
| 14 December 2026 | 15 December 2026 | Online | €1,485 |
| 16 December 2026 | 17 December 2026 | Online | €1,485 |
| 22 December 2026 | 23 December 2026 | Online | €1,485 |
| 24 December 2026 | 28 December 2026 | Online | €1,485 |
| 30 December 2026 | 31 December 2026 | Online | €1,485 |
| 5 January 2027 | 6 January 2027 | Online | €1,485 |
| 7 January 2027 | 8 January 2027 | Online | €1,485 |
| 13 January 2027 | 14 January 2027 | Online | €1,485 |
| 15 January 2027 | 18 January 2027 | Online | €1,485 |
| 18 January 2027 | 19 January 2027 | Online | €1,485 |
| 20 January 2027 | 21 January 2027 | Online | €1,485 |
| 26 January 2027 | 27 January 2027 | Online | €1,485 |
| 28 January 2027 | 29 January 2027 | Online | €1,485 |
| 3 February 2027 | 4 February 2027 | Online | €1,485 |
| 5 February 2027 | 8 February 2027 | Online | €1,485 |
| 8 February 2027 | 9 February 2027 | Online | €1,485 |
| 10 February 2027 | 11 February 2027 | Online | €1,485 |
| 16 February 2027 | 17 February 2027 | Online | €1,485 |
| 18 February 2027 | 19 February 2027 | Online | €1,485 |
| 24 February 2027 | 25 February 2027 | Online | €1,485 |
| 26 February 2027 | 1 March 2027 | Online | €1,485 |
| 1 March 2027 | 2 March 2027 | Online | €1,485 |
| 3 March 2027 | 4 March 2027 | Online | €1,485 |
| 9 March 2027 | 10 March 2027 | Online | €1,485 |
| 11 March 2027 | 12 March 2027 | Online | €1,485 |
| 17 March 2027 | 18 March 2027 | Online | €1,485 |
| 19 March 2027 | 22 March 2027 | Online | €1,485 |
| 22 March 2027 | 23 March 2027 | Online | €1,485 |
| 24 March 2027 | 25 March 2027 | Online | €1,485 |
| 30 March 2027 | 31 March 2027 | Online | €1,485 |
| 1 April 2027 | 2 April 2027 | Online | €1,485 |
| 7 April 2027 | 8 April 2027 | Online | €1,485 |
| 9 April 2027 | 12 April 2027 | Online | €1,485 |
| 12 April 2027 | 13 April 2027 | Online | €1,485 |
| 14 April 2027 | 15 April 2027 | Online | €1,485 |
| 20 April 2027 | 21 April 2027 | Online | €1,485 |
| 22 April 2027 | 23 April 2027 | Online | €1,485 |
| 28 April 2027 | 29 April 2027 | Online | €1,485 |
| 30 April 2027 | 3 May 2027 | Online | €1,485 |
| 3 May 2027 | 4 May 2027 | Online | €1,485 |
| 5 May 2027 | 10 May 2027 | Online | €1,485 |
| 11 May 2027 | 12 May 2027 | Online | €1,485 |
| 13 May 2027 | 14 May 2027 | Online | €1,485 |
| 19 May 2027 | 20 May 2027 | Online | €1,485 |
The first 50 start dates are shown here. The provider has more.