Whether delivered online or in-person, our instructor-led Oracle PL/SQL training sessions utilize interactive, hands-on exercises to illustrate how Oracle PL/SQL creates a robust and adaptable programming environment within the Oracle Database.
We provide Oracle PL/SQL instruction as either "online live training" or "onsite live training". The online live option (also referred to as "remote live training") is facilitated through an interactive remote desktop. In contrast, onsite live training takes place locally at your customer premises in Durban or at NobleProg’s corporate training centers in Durban.
Also recognized as Oracle Procedural Language extensions to the Structured Query Language, Oracle PL/SQL enhances database functionality.
NobleProg -- Your Local Training Provider
Garden Court South Beach
Durban, South Africa
Way to get there
From Durban city centre: follow the beachfront/Marine Parade south toward South Beach.
By car/taxi: give the driver the address 73 O.R. Tambo Parade, South Beach, Durban 4001.
From King Shaka International Airport: the hotel is roughly 30 km ;from the airport.
This instructor-led, live training in Durban (online or onsite) is aimed at advanced-level developers and database administrators who wish to use PL/SQL to develop high-performing, secure, and scalable database solutions while leveraging advanced programming techniques and integrations.
By the end of this training, participants will be able to:
Work with complex data types, collections, and bulk operations for efficient data management.
Develop object types, table functions, and custom aggregates to enhance database functionality.
Apply performance tuning techniques, use native compilation, and safeguard against SQL injection.
Implement application contexts, VPD, and secure program units for robust database solutions.
This instructor-led, live training in Durban (online or onsite) is aimed at beginner-level developers and database administrators who wish to learn PL/SQL to automate database tasks, implement business logic, and develop robust database applications.
By the end of this training, participants will be able to:
Develop efficient PL/SQL programs to automate database operations and integrate SQL commands effectively.
Create reusable program units, including procedures, functions, packages, and triggers, for modular and scalable applications.
Implement advanced data structures like associative arrays and manage query results using cursors.
Handle errors robustly and secure code with encryption, obfuscation, and conditional compilation techniques.
Apply PL/SQL in real-world scenarios, leveraging built-in packages for file handling, email automation, and other advanced functionalities.
This instructor-led, live training in Durban (online or onsite) is aimed at intermediate-level database administrators who wish to have an in-depth understanding of Oracle Database 19c PL/SQL programming and advanced SQL techniques.
By the end of this training, participants will be able to:
Understand the fundamentals and advanced features of PL/SQL.
Develop advanced SQL queries to retrieve and manipulate data efficiently.
Implement PL/SQL programming constructs to manage data and database operations.
Optimize SQL queries for better performance.
Use advanced PL/SQL features like collections, bulk processing, and error handling.
Learn to debug and manage PL/SQL programs effectively.
This instructor-led live training in Durban empowers intermediate developers to master PL/SQL by constructing robust programs and managing exceptions. Learners will gain the ability to build reusable procedures, functions, and packages, utilizing effective control structures, cursors, and security features within Oracle Database.
This live training in Durban provides intermediate developers with the core PL/SQL skills required for Oracle 19c. Participants will gain proficiency in variables, control structures, cursors, and exception handling, enabling them to construct efficient and robust database applications through practical, hands-on exercises.
This intensive three-day workshop in Durban serves as an introduction to Oracle PL/SQL, focusing on the development of stored procedures, functions, and triggers. Through a combination of lectures and hands-on exercises, participants will master core concepts such as variables, cursors, and error handling, thereby building practical skills in database application development.
This training is aimed at database programmers who use SQL and need to broaden their workflow capabilities by employing procedural language mechanisms.
Read more...
Last Updated:
Testimonials (3)
To understand and better comprehensive with routine SQL
Online Oracle PL/SQL training in Durban, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) training courses in Durban, Weekend Oracle PL/SQL courses in Durban, Evening Oracle PL/SQL training in Durban, Oracle PL/SQL instructor-led in Durban, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) classes in Durban, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) instructor-led in Durban, Oracle PL/SQL boot camp in Durban, Oracle PL/SQL on-site in Durban, Oracle PL/SQL coaching in Durban, Oracle PL/SQL one on one training in Durban, Oracle PL/SQL trainer in Durban, Oracle PL/SQL private courses in Durban, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) instructor in Durban, Evening Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) courses in Durban, Weekend Oracle PL/SQL training in Durban, Online Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) training in Durban
