Módulos

This program provides advanced training in SQL and PL/SQL in Oracle 19C, allowing participants to develop data manipulation skills, consultation optimization, development of stored procedures, triggers and functions, in addition to efficient database management.

The course prepares participants to obtain international certifications:

Oracle Database 19C: SQL Workshop (1Z0-071) (Exam required for PL/SQL Developer OCP certification).

Oracle Program With PL/SQL (1Z0-149) (Oracle Certified Professional-PL/SQL Developer OCP).

This program is aimed at software developers, database administrators and professionals in IT who seek to specialize in Oracle database management and development with PL/SQL.

At the end of the course, participants will be able to:

• Oracle SQL Workshop (1Z0-071)
• Understand the architecture of Oracle Database 19C and its ecosystem
• Make advanced consultations with SQL in Oracle databases
• Manipulate data using functions and operators in SQL
• Optimize consultations through indices, partitioning and statistics
• Manage users, roles and permissions in Oracle databases
• Apply advanced functions such as subconsultations, joins and set operators
• Execute transactions, blockages and data recovery
• PL/SQL DEVELOPER OCP (1Z0-149) SQL
• Write and optimize stored procedures and functions in PL/SQL
• Handle exceptions and control structures in PL/SQL
• Use explicit and implicit cursors in PL/SQL
• Create and manage packages and modules in Oracle
• Develop and manage advanced triggers in Oracle databases
• Implement dynamic SQL and compilation PL/SQL for performance optimization
• Apply advanced security and audit techniques in PL/SQL
• Use purification and optimization tools in Oracle

To participate in this training, attendees must meet the following requirements:

• Experience as a developer in any programming language or having completed the Software Programmer Fundament course
• Basic knowledge in databases or having taken the SQL Databases Fundamental course
• These requirements guarantee that participants can focus on the advanced learning of SQL and PL/SQL without initial technical difficulties

Learning Methodology

The learning methodology, regardless of the modality (in-person or remote), is based on the development of workshops or labs that lead to the construction of a project, emulating real activities in a company.

The instructor (live), a professional with extensive experience in work environments related to the topics covered, acts as a workshop leader, guiding students' practice through knowledge transfer processes, applying the concepts of the proposed syllabus to the project.

The methodology seeks that the student does not memorize, but rather understands the concepts and how they are applied in a work environment.

As a result of this work, at the end of the training the student will have gained real experience, will be prepared for work and to pass an interview, a technical test, and/or achieve higher scores on international certification exams.

Conditions to guarantee successful results:

• a. An institution that requires the application of the model through organization, logistics, and strict control over the activities to be carried out by the participants in each training session.
• b. An instructor located anywhere in the world, who has the required in-depth knowledge, expertise, experience, and outstanding values, ensuring a very high-level knowledge transfer.
• c. A committed student, with the space, time, and attention required by the training process, and the willingness to focus on understanding how concepts are applied in a work environment, and not memorizing concepts just to take an exam.

Pre-enrollment

You do not need to pay to pre-enroll. By pre-enrolling, you reserve a spot in the group for this course or program. Our team will contact you to complete your enrollment.

Infinity Payments

Make your payment quickly, safely and reliably

- For bank transfer payments, request the details by email capacita@aulamatriz.edu.co.

- If you wish to finance your payment through our credit options
(Sufi, Cooperativa Unimos or Fincomercio), click on the following link:
Ver opciones de crédito.