MODALIDAD ONLINE
ORACLE 12C PL / SQL
developer
DURACIÓN: 90 HORAS
En este curso online, obtendrás los conocimientos y habilidades necesarias para la obtención del certificado
internacional Oracle Database SQL Certified Associate y Oracle PL/SQL Developer Certified Associate Certification,
basado en el material oficial de Oracle bajo el convenio de Workforce Development Program (WDP). Además, aprenderás
a interactuar con el motor y objetos de base de datos, utilizando el lenguaje SQL y PLSQL.
DIRIGIDO
Profesionales, egresados y estudiantes, interesados en convertirse en programador en base de datos Oracle.
METODOLOGÍA
El enfoque práctico-reflexivo de cada una de las sesiones virtuales en tiempo real, así como la participación de los
estudiantes en un ambiente interactivo de clases moderado por el instructor, permitirá el aprendizaje de contenidos y su
aplicación en la resolución de contextos reales, utilizando herramientas digitales para el aprendizaje significativo.
BENEFICIOS
• Acceso a la plataforma de Microsoft Azure Lab Services, desde cualquier PC o laptop con una conexión de Internet
de 2 Mbps como mínimo.
• La máquina virtual estará configurada con el software y hardware necesario, con velocidad 2.1 Gbps de navegación
disponible para las sesiones de clases.
• Correo institucional de Cibertec.
• Licencia de Office 365 (Word, Excel, Power Point, etc.).
• Acceso a Microsoft OneDrive y Microsoft Teams.
LOGROS DEL CURSO
Al finalizar el curso, estarás en la capacidad de:
• Desarrollar aplicaciones utilizando el lenguaje de programación PL/SQL.
• Construir consultas para agregar información desde distintas tablas con funciones.
• Construir funciones, paquetes, procedimiento y disparadores con leguaje PL/SQL.
• Gestionar correctamente las excepciones de código.
PRE-REQUISITOS
• Conocimiento de modelamiento de base de datos (recomendado).
• Conocimiento de lenguaje SQL (recomendado).
• Conocimiento de inglés técnico (nivel intermedio).
CERTIFICACIONES
• Al término de la capacitación, obtendrás un certificado de “Oracle 12C SQL & PL/SQL Developer”, a nombre de
Cibertec.
LÍNEA DE ESPECIALIZACIÓN
Oracle Database 12C
Program with PL/SQL
Oracle Database 12C
Introduction to SQL
CONCEPTOS Y TERMINOLOGÍA
• Single-Row Functions • Create Users • Write Executable Statements
• Functions & Conditional Expressions • Grant System Privileges • Explicit Cursors
• Multiple Tables Using Joins • Grant Object Privileges • Control Structures
• Sub-queries to Solve Queries • Revoke Object Privileges • Composite Data Types
• Data Manipulation Statements • Flashback Operations • Exception Handling
• Create and Manage Tables • Multiple Column Subquery • Stored Procedures
• Control User Access • Commit & Rollback • Packages
• Retrieve Data Sub-queries • Autonomous Transactions • Triggers
CONTENIDO
CONTENIDOTEMÁTICO
TEMÁTICO
ORACLE DATABASE 12C: INTRO- Aggregate Data Using the Group Data Manipulation Statements
DUCTION TO SQL Functions • Describe each DML statement.
• Use the aggregation functions to • Insert rows into a table.
Single-Row Functions to Custo- produce meaningful reports. • Change rows in a table by the
mize Output • Retrieved data in groups by UPDATE statement.
• Single row and multiple row using the GROUP BY. • Delete rows from a table with
functions. • Exclude groups of data by using the DELETE statement.
• Strings with character function the HAVING clause. • Save and discard changes with
in the SELECT and WHERE the COMMIT and ROLLBACK
clauses. Display Data Multiple Tables statements.
• Numbers with the ROUND, Using Joins • Explain read consistency.
TRUNC, and MOD functions. • Write SELECT statements to
• Manipulate dates with the DATE access data from more than one Use of DDL Statements to Create
functions. table. and Manage Tables
• Join a table to itself by using a • Categorize the main database
Functions and Conditional self-join. objects.
Expressions • Review the table structure.
• Use the TO_CHAR, TO_NUMBER, Use Sub-queries to Solve Queries • List the data types available for
and TO_DATE conversion func- • Define sub-queries. columns.
tions. • Write single-row and multi- • Create a simple table.
• Nest multiple functions. ple-row sub-queries. • Decipher how constraints can be
• Apply the NVL, NULLIF, and • Describe the SET operators. created at table creation.
COALESCE functions to data. • Use a SET operator to combine • Describe how schema objects
• Use conditional IF THEN ELSE multiple queries into a single work.
logic in a SELECT statement. query.
Control User Access Control Structures Packages
• Create Users. • Conditional processing using IF • Listing the advantages of
• Grant System Privileges. Statements. Packages.
• Create and Grant Privileges to a • Conditional processing using • Develop a Package.
Role. CASE Statements. • How to enable visibility of a
• Change Your Password. • Describe simple Loop Statement. Package’s Components?
• Grant Object Privileges. • Describe While Loop Statement. • Create the Package Specification
• How to pass on privileges? • Describe For Loop Statement. and Body using the SQL CREATE
• Revoke Object Privileges. • Use the Continue Statement. Statement and SQL Developer.
• Invoke the Package Constructs.
Management of Schema Objects Composite Data Types • View the PL/SQL Source Code
• Add, Modify, and Drop a Column. • Use PL/SQL Records. using the Data Dictionary.
• Add, Drop, and Defer a Constra- • The %ROWTYPE Attribute.
int. • Insert and Update with PL/SQL Dynamic SQL
• How to enable and Disable a Records. • What is Dynamic SQL?
Constraint? • INDEX BY Tables. • Declare Cursor Variables.
• Create and Remove Indexes. • Use INDEX BY Table of Records. • Dynamically Executing a PL/SQL
• Create a Function-Based Index. Block.
• Perform Flashback Operations. Explicit Cursors • Implement DBMS_SQL with a
• Create an External Table by • Declare the Cursor. Parameterized DML Statement.
Using ORACLE_LOADER and by • Open the Cursor. • Dynamic SQL Functional Com-
Using ORACLE_DATAPUMP. • Fetch data from the Cursor. pleteness.
• Query External Tables. • Close the Cursor.
• Cursor FOR loop. Design Considerations for PL/SQL
Retrieve Data Sub-queries • The %NOTFOUND and %ROW- Code
• Multiple-Column Subqueries. COUNT Attributes. • Write Autonomous Transactions.
• Pairwise and Nonpairwise. • Implement the NOCOPY Compi-
• Solve problems with Correlated Exception Handling ler Hint.
Subqueries. • Handle Exceptions with PL/SQL. • Invoke the PARALLEL_ENABLE
• Update and Delete Rows Using • Trap Predefined Oracle Server Hint.
Correlated Subqueries. Errors. • The Cross-Session PL/SQL
• Trap Non-Predefined Oracle Function Result Cache.
ORACLE DATABASE 12C: PROGRAM Server Errors.
WITH PL/SQL • Trap User-Defined Exceptions. Triggers
• Propagate Exceptions. • Create DML Triggers using the
Write Executable Statements • RAISE_APPLICATION_ERROR CREATE TRIGGER Statement and
• Describe Basic PL/SQL Block Procedure. SQL Developer.
Syntax. • Identify the Trigger Event Types,
• Comment the Code. Stored Procedures Body, and Firing (Timing).
• Deployment of SQL Functions in • Create a Modularized and • Differences between Statement
PL/SQL. Layered Subprogram Design. Level Triggers and Row Level
• How to convert Data Types? • Modularize Development With Triggers.
• Describe Nested Blocks. PL/SQL Blocks. • Create Instead of and Disabled
• Identify the Operators in PL/SQL. • Understand the PL/SQL Execu- Triggers.
tion Environment. • How to Manage, Test and
Interaction with the Oracle Server • List the benefits of using PL/SQL Remove Triggers?
• Invoke SELECT Statements in Subprograms.
PL/SQL. • List the differences between Creating Compound, DDL, and
• Retrieve Data in PL/SQL. Anonymous Blocks and Subpro- Event Database Triggers
• SQL Cursor concept. grams. • Understand the Compound
• Avoid Errors by using Naming • Create, Call, and Remove Stored Trigger Structure for Tables and
Conventions when using Retrie- Procedures. Views.
val and DML Statements. • Implement Procedures Parame- • Implement a Compound Trigger
• Data Manipulation in the Server ters and Parameters Modes. to Resolve the Mutating Table
using PL/SQL. • View Procedure Information. Error.
• Use SQL Cursor Attributes to • Comparison of Database Triggers
Obtain Feedback on DML. to Stored Procedures.
• Save and Discard Transactions.
