Explore Our Courses

Oracle Database 19c PL and Advanced SQL

28 Hours
This instructor-led, live training in the US (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.
Read more...

PL/SQL in Oracle 19c

 21 Hours
This instructor-led, live training in the US (online or onsite) is aimed at intermediate-level developers and administrators who wish to have a solid PL/SQL programming foundation to develop efficient and robust database applications using Oracle 19c.By the end of this training, participants will be able to:
  • Gain a comprehensive understanding of what PL/SQL is and its advantages over standard SQL.
  • Learn how to declare and use variables and different data types within PL/SQL blocks.
  • Apply control structures like IF-THEN-ELSE, CASE statements, and loops to create robust PL/SQL programs.
  • Understand and implement explicit and implicit cursors for data retrieval.
  • Handle exceptions effectively using predefined and user-defined exceptions.
  • Develop and manage triggers to automate and enforce business rules.
  • Create and use PL/SQL packages to encapsulate and modularize code for reuse and maintainability.
Read more...

ORACLE PL/SQL Fundamentals

 21 Hours
This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands.The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.
Read more...

Oracle 11g - Programming with PL / SQL I - Workshops

 28 Hours
For whoWorkshops are dedicated to developers, end users and administrators, who until now have had no contact with the language PL / SQL, and the need to exploit its huge potential in working with a database, automate processes, and in building applicationsExams and CertificatesThe plan covers the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer Certified AssociatePurpose of trainingThe workshop aims to familiarize participants with the programming language PL / SQL, its capabilities and limitations. This workshop will include a full understanding of the mechanisms involved in the programming language PL / SQL needed to implement the logic of the free applications, automation of data processing and database management.The content of the training
  • Introduction to PL / SQL architecture solutions based on this language, the organization of the working environment
  • Create scripts and stored program units that operate on data
NotesThe workshops are based on the software version 11g XE
Read more...

Oracle 11g - Programming with PL / SQL II

 21 Hours
For whoThis training is in addition to, and continuation of the 'Oracle 11g - Programming in PL / SQL and - workshops ", but can also be designed for practitioners, developers, PL / SQL who already have experience with the language, and who want to systematize their knowledge and learn advanced mechanisms and solutions developed in this language.The content of the training
  • Objects, streams and complex data structures
  • Advanced solutions based on PL / SQL
Exams and CertificatesThe plan covers the training material required to pass the exam 1Z0-146 Oracle Advanced PL / SQL and obtain the title of Oracle Advanced PL / SQL Developer Certified ProfessionalPurpose of trainingThe training is designed to familiarize participants with the advanced aspects of programming in an Oracle database. The emphasis is on flexibility and performance solutions based on PL / SQL.NotesThe workshops are based on the software version 11g XE
Read more...

Last Updated:

Testimonials(3)

The exercises were explained very good.

Monica - DB Global Technology

Course - PL/SQL in Oracle 19c

Bien preparado, apegado al temario, se revisó temario completo, ejemplos adecuados.

Luis Gerardo Torres - thyssenkrupp Presta de México SA de CV

Course - Fundamentos de ORACLE PL / SQL

Very high competence of the trainer!!.

Heino Eilers

Course - Oracle 11g - Programming with PL / SQL I - Workshops

Upcoming Courses

Other regions in the US

Other Countries

These courses are also available in other countries

Consulting

Oracle PL/SQL Consulting
Online Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) courses, Weekend Oracle PL/SQL courses, Evening Oracle PL/SQL training, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) boot camp, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) instructor-led, Weekend Oracle PL/SQL training, Evening Oracle PL/SQL courses, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) coaching, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) instructor, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) trainer, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) training courses, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) classes, Oracle Procedural Language extensions to the Structured Query Language (PL/SQL) on-site, Oracle PL/SQL private courses, Oracle PL/SQL one on one training