Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 21 hours
Course Outline
PL/SQL Fundamentals
- PL/SQL architecture and block structure
- Data types, variables, and constants
- Variable declaration and assignment
Control Flow and Decision Logic
- IF, CASE, and nested conditional statements
- LOOP, WHILE, and FOR constructs
- EXIT and CONTINUE commands
Cursors and Transactions
- Implicit and explicit cursors
- Cursor FOR loops and associated attributes
- Transaction management: COMMIT, ROLLBACK, SAVEPOINT
Exception Handling
- Categorization of exceptions and WHEN clauses
- Application of RAISE_APPLICATION_ERROR
- Custom exceptions and handlers
Procedures and Functions
- Creation of procedures and functions
- IN, OUT, and IN OUT parameters
- Invoking stored procedures from SQL and PL/SQL
Packages and Triggers
- Development and administration of packages
- Package specification versus body
- Row-level and statement-level triggers
Security and Testing
- Execution privilege granting and revocation
- PL/SQL debugging using SQL Developer
- Unit testing of stored procedures and packages
Summary and Next Steps
Requirements
- Comprehension of relational database concepts
- Fundamental knowledge of SQL
- Academic or practical familiarity with the basics of procedural programming
Target Audience
- Database developers
- Backend programmers and data engineers
- Technical support and DevOps professionals operating within Oracle environments
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 (2)
To understand and better comprehensive with routine SQL
Faizal KAHAR - Soitec Microelectronics Singapore Pte Ltd
Course - Oracle Database 19c PL and Advanced SQL
I liked the hands-on experience and the opportunity to work on actual coding activities
