WhatsApp: +573224181125
customerservice@infinity.org

INTERNATIONAL CERTIFICATION SQL DATABASES FUNDAMENTS + ORACLE 19C DBA OCP

INTERNATIONAL CERTIFICATION SQL DATABASES FUNDAMENTS + ORACLE 19C DBA OCP

Módulos

Nivel I: Sql Database Fundamentals (SQLF-001)

    

  • Introducción a bases de datos  
  • No relacionales  
  • Relacionales  
  • Terminología básica  
  • Qué es SQL  
  • Tipos de sentencias SQL  
  • SQL como un lenguaje no procedimental
  • Ejemplos de sql

  • Crear una base de datos  
  • Tipos de datos  
  • Carácter  
  • Numérico  
  • Datos temporales  
  • Creación de tablas  
  • Diseño  
  • Refinamiento  
  • Creación de esquema  
  • Alimentar y modificar datos en la tabla  
  • Insertar  
  • Actualizar  
  • Eliminar  
  • Cuando las buenas instrucciones no funcionan  
  • Sin llave primaria  
  • Sin llave foránea  
  • Violación de columna  
  • Conversiones inválidas de fecha

  • Mecanismos de las consultas  
  • Cláusulas de las consultas  
  • Cláusula SELECT  
  • Alias  
  • Remover duplicados  
  • Cláusula FROM  
  • Tablas  
  • Tablas enlazadas  
  • Definir alias de las tablas  
  • Cláusula WHERE  
  • Cláusula GROUP BY y HAVING  
  • Cláusula ORDER BY

  • Condiciones  
  • Uso de parámetros  
  • Operador NOT  
  • Construcción de condiciones  
  • Tipos de condiciones  
  • Igualdad  
  • Rango  
  • Membresía  
  • Semejanza  
  • NULL

  • Qué es el JOIN  
  • Producto cartesiano  
  • Inner joins  
  • Sintaxis ANSI JOIN  
  • JOIN con tres o más tablas  
  • Usar subqueries como tablas  
  • Uso de la misma tabla dos veces

  • Teoría de conjuntos  
  • Teoría de conjuntos en práctica  
  • Operadores de conjuntos  
  • Unión  
  • Intersect  
  • Except  
  • Reglas de operaciones de conjuntos  
  • Ordenar queries compuestos  
  • Precedencia de las operaciones

  • Trabajando con cadena de caracteres  
  • Generación  
  • Manipulación  
  • Trabajando con datos numéricos  
  • Funciones aritméticas  
  • Controlando precisión del número  
  • Trabajando con datos temporales  
  • Zona horaria  
  • Generar datos temporal  
  • Manipular datos temporales

  • Conceptos de agrupación  
  • Funciones de agregación  
  • Implícito versus explícito  
  • Contar valores distintos  
  • Usar expresiones  
  • Cómo son NULL interpretados  
  • Generar agrupaciones  
  • Una columna  
  • Múltiples columnas  
  • Agrupar con expresiones  
  • Generar rollups

  • Qué es un subquery  
  • Tipos de subqueries  
  • Subqueries no relacionados  
  • Múltiple columna  
  • Múltiple fila, única columna  
  • Subqueries relacionados  
  • Operador EXISTS  
  • Manipulación de datos usando subqueries  
  • Cuándo utilizar subqueries  
  • Subquery como origen de datos  
  • Subquery como expresión

  • Bases multiusuario  
  • Bloqueo  
  • Bloqueo granular  
  • Qué es una transacción  
  • Iniciar una transacción  
  • Finalizar una transacción  
  • Puntos de guardado de transacciones

  • Qué son las vistas  
  • Por qué usar vistas  
  • Seguridad de los datos  
  • Agregación de datos  
  • Ocultar complejidad  
  • Unir tablas particionadas

    

    

  • Course objectives, roadmap, and appendixes used in the course  
  • Overview of Oracle Database 19c and related products  
  • Overview of relational database management concepts and terminologies  
  • Human Resource (HR) Schema and the tables used in the course  
  • Introduction to SQL and its development environments  
  • Oracle Database 19c SQL Documentation and Additional Resources

  • Capabilities of SQL SELECT statements  
  • Arithmetic expressions and NULL values in the SELECT statement  
  • Column aliases  
  • Use of the concatenation operator, literal character strings, the alternative quote operator, and the DISTINCT keyword  
  • DESCRIBE command

  • Limiting rows with:  
  • The WHERE clause  
  • The comparison operators using =
  • Logical conditions using AND, OR, and NOT operators  
  • Rules of precedence for operators in an expression  
  • Sorting rows using the ORDER BY clause  
  • SQL row limiting clause in a query  
  • Substitution variables in Oracle  
  • Assigning values to variables

  • Single-row SQL functions  
  • Character functions  
  • Nesting functions  
  • Number functions  
  • Working with dates in Oracle Databases  
  • Working with dates in MySQL Databases  
  • Date functions

  • Implicit and explicit data type conversion  
  • TO_CHAR, TO_DATE, TO_NUMBER functions in Oracle  
  • Using the CAST() function in MySQL  
  • General functions (NVL, NVL2, NULLIF, COALESCE)  
  • Conditional expressions (CASE, Searched CASE, DECODE)  
  • JSON functions: (JSON_QUERY, JSON_TABLE, JSON_VALUE)

  • Group functions
  • Types and syntax
  • Use AVG, SUM, MIN, MAX, COUNT
  • Use the DISTINCT keyword within group functions
  • NULL values in a group function
  • Grouping rows: (GROUP BY clause, Having clause)

  • Displaying Data from Multiple Tables Using Joins
  • Types of JOINS and their syntax
  • Natural join
  • Join with the USING clause
  • Join with the ON clause
  • Self-join
  • Nonequijoins
  • OUTER join (LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN)
  • Cartesian product (Cross join)

  • Subquery: Types, syntax, and guidelines
  • Single-row subqueries
  • Group functions in a subquery
  • HAVING clause with subqueries
  • Multiple-row subqueries
  • Using All or Any Operator
  • Multiple-column subqueries
  • Null values in a subquery

  • Set operators: Types and guidelines
  • Tables used in this lesson
  • UNION and UNION ALL operator
  • INTERSECT operator
  • MINUS operator
  • Matching SELECT statements
  • Using the ORDER BY clause in set operations

  • Adding new rows in a table ( INSERT statement )
  • Changing data in a table ( UPDATE statement)
  • Removing rows from a table: ( DELETE y TRUNCATE statement)
  • Database transaction control using COMMIT, ROLLBACK, and SAVEPOINT
  • Read consistency
  • Manual Data Locking

  • Adding new rows in a table (INSERT statement)
  • Changing data in a table (UPDATE statement)
  • Removing rows from a table: ( DELETE y TRUNCATE statement)
  • Database transaction control using COMMIT, ROLLBACK, and SAVEPOINT
  • Read consistency
  • Manual Data Locking

  • Database objects ( Naming rules )
  • CREATE TABLE statement
  • Data types
  • Overview of constraints: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK constraints
  • Creating a table using a subquery
  • ALTER TABLE statement
  • DROP TABLE statement

  • Database objects ( Naming rules ) 
  • CREATE TABLE statement
  • Data types 
  • Indexes, keys, and constraints
  • Column options
  • Creating a table using a subquery
  • ALTER TABLE statement
  • DROP TABLE statement

  • Introduction to data dictionary
  • Querying the dictionary views for the following
  • Table information
  • Column information
  • Constraint information
  • Adding a comment to a table and querying the dictionary views for comment information

  • Overview of sequences
  • Overview of synonyms
  • Overview of indexes

  • Overview of views
  • Creating, modifying, and retrieving data from a view
  • Data manipulation language (DML) operations on a view
  • Dropping a view

  • Managing constraints
  • Creating and using temporary tables
  • Creating and using external tables

  • Retrieving data by using a subquery as a source
  • Writing a multiple-column subquery
  • Using scalar subqueries in SQL
  • Solving problems with correlated subqueries
  • Using the EXISTS and NOT EXISTS operators
  • Using the WITH clause

  • Using subqueries to manipulate data
  • Inserting values by using a subquery as a target
  • Using the WITH CHECK OPTION keyword on DML statements
  • Using correlated subqueries to update and delete rows

  • System privileges
  • Creating a role
  • Object privileges
  • Revoking object privileges

  • Specifying explicit default values in the INSERT and UPDATE statements  
  • Using the following types of multitable INSERTs:  
  •  Unconditional INSERT  
  • Conditional INSERT ALL  
  • Conditional INSERT FIRST  
  • Pivoting INSERT  
  • Merging rows in a table  
  • Performing flashback operations  
  • Tracking the changes in data over a period of time

  • CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP  
  • INTERVAL data types  
  • Using the following functions:  
  • EXTRACT  
  • TZ_OFFSET  
  • FROM_TZ  
  • TO_TIMESTAMP  
  • TO_YMINTERVAL  
  • TO_DSINTERVAL

    

  • Database Server Architecture

   

  • Creating a Database Using DBCA

  • Creating a Database Using a SQL Command

  • Opening and Closing PDBs

  • Managing the Database

  • Cofiguring and Administering Oracle Net Services

  • Oracle Net Components
  • Naming Method

    

     

  • Connection Manager

  • Provisoning New Pluggable Databases

  • Method of creating and migrating PDBs

     

  • Purpose of the Default Tablespaces
  • Storage of Data in blocks
  • Advanage of Deferred Segment Creation

  • Viewing Tablespace information

  • Space Management Features
  • Creating Global Temporary Tables

  • Enabiling temporary Undo

          

       

    

  • Configuring Auditing
  • Viewing Audit Policy Information

     

   

  • Using the RMAN convert Command

  • External Table Demo

  • Automated Maintenance Tasks: Components

  • Cofiguring Automated Maintenance Task

    

  • Understanding Monitoring Database Performance
  • Database Processes
  • Managing Memory

    

     

  • Understanding Instance Recovery

  • Configuration Demo
  • Control File Demo
  • Adding a Redo file to Redo Group - Demo

  • Connection the RMAN and a Taget Database Demo
  • Using the sequel and RMAN Demo
  • Managing the setting RMAN Demo

   

  • Fast Incremental Backup  
  • Syntax and clause in RMAN used for backups (Demo)  
  • Creating image copies for backup (Demo)  
  • Creating a whole backup of container or non-container database system (Demo)  
  • Creating a partial PDB backup (Demo)  
  • Maintaining the block change tracking file (Demo)  
  • Backing up control files to trace file (Demo)

  • Compressed Backup (Demo)  
  • Creating duplex backup sets using backup copies (Demo)  
  • Creating backups of backup sets (Demo)  
  • Creating archival backups with RMAN (Demo)  
  • Backups of the recovery file

  • Asynchronos I/O Bottlenecks

    

  • Configure a Recovery Catalog Database Demo
  • Creating a Recovery Catalog Owner Demo
  • Creating a Recovery Catalog Demo

  • Register a Database in Rcovery Catalog Demo
  • Manually Resynchronizing Recovery Catalog Demo

    

   

  • Instance Failure

  • Data Recovery Advisor
  • Diagnosing Failure Using Oracle Database Recovery Advisor Demo

  • Performing Complete Recovery Using RMAN Demo

  • Architecture Tablespace Point-in-Time Recovery
  • Perfoming incomplete Recovery Using Data Recovery Advisor RMAN Demo

  • Perfoming Block Media Recovery

      

     

  • Flashback Drop and the Recycle Bin
  • Prepare to Using Flashback Technology Demo

  • Enabiling Oracle Flashback Database Demo

     

     

  • Allocating Auxiliary Channels

     

  • Describe the multitenant architecture
  • Describe the CDB root and pluggable database containers
  • Differentiate the CDB root from a pluggable database
  • Understand the terminology of commonality
  • List impacts in various areas

  • Configure and create a CDB  
  • Provision new PDBs  
  • Create a new PDB from the CDB seed  
  • Explore the instance  
  • Explore the structure of PDBs  
  • Explore the Automatic Diagnostic Repository (ADR)

  • Describe application containers in CDBs  
  • Explain the purpose of application root and application seed  
  • Define application PDBs  
  • Create application PDBs  
  • Explain application installation on top of application containers  
  • Install, upgrade and patch an application  
  • Describe the commonality concept in application contexts  
  • Use a dynamic container map

  • Clone a regular PDB  
  • Clone an application PDB  
  • Unplug and plug a non-CDB  
  • Unplug and plug a regular PDB  
  • Unplug and plug an application container  
  • Convert regular PDBs to application PDBs  
  • Configure and use the local UNDO mode  
  • Perform hot cloning and relocation

  • Establish connections to CDB and PDB  
  • Start up and shut down a CDB  
  • Open and close PDBs  
  • Avoid service name conflicts  
  • Start PDB service  
  • Change the different modes and settings of PDBs  
  • Evaluate the impact of parameter value changes  
  • Configure host name and port number per PDB

  • Manage permanent tablespaces in CDB and PDBs  
  • Manage temporary tablespaces in CDB and PDBs  
  • Manage the UNDO tablespaces in CDB root and PDB

  • Manage common and local users, roles, privileges and profiles in PDBs  
  • Manage common and local objects in application containers  
  • Enable common users to access data in PDBs  
  • Manage PDB lockdown profiles  
  • Audit users in CDB and PDBs  
  • Manage other types of policies in application containers  
  • Protect data with Database Vault policies in CDB and PDBs  
  • Encrypt data in PDBs

  • Backup CDB and PDBs  
  • Use RMAN backups to plug unplugged PDBs  
  • Duplicate PDBs  
  • Duplicate an active PDB into an existing CDB  
  • Duplicate a CDB as encrypted  
  • Validate CDBs and PDBs

  • Recover a PDB from essential file damage  
  • Recover a PDB from non-essential file damage  
  • Reuse preplugin backups after conversion of a non-CDB to a PDB  
  • Reuse preplugin backups after plugging/relocating a PDB into another CDB  
  • Perform CDB flashback  
  • Perform PDB flashback  
  • Use clean restore points to complete PDB flashback  
  • Manage PDB snapshots

  • Monitor operations in a CDB and PDBs  
  • Monitor performance in a CDB and PDBs  
  • Manage SGA and PGA limits at the PDB level  
  • Manage AWR snapshots at the CDB and PDB levels  
  • Run ADDM tasks for CDB and PDB recommendations  
  • Manage application shared object statistics  
  • Control query DOP involving the containers() construct  
  • Control PDB I/O rate limits

  • Manage resource allocation between PDBs and within a PDB  
  • Enable parallel statement queuing at PDB level  
  • Manage PDB performance profiles  
  • Avoid excessive session usage and resource contention

  • Export from a non-CDB and import into a PDB  
  • Export from a PDB and import into a PDB  
  • Export from a PDB and import into a non-CDB  
  • Use SQL*Loader to load data into a PDB

  • Upgrade 12.2 CDB to 18c  
  • Upgrade 12.2 PDBs to PDBs in 18c  
  • Plug in a remote PDB through XTTS into a target CDB

This program provides comprehensive training in SQL database management and advanced administration in Oracle 19C, addressing from the structure and handling of databases to support and recovery strategies in business environments. It focuses on the architecture of Oracle Database 19C, its optimization and security. The course prepares participants to obtain international certifications:

  • SQL DATABASES FUNDAMENTS (SQLF-001)
  • Oracle Database 19C: SQL Workshop (1Z0-082)
  • Oracle Database 19C: Administration Workshop (1Z0-082)
  • Oracle Database 19C: Backup and Recovery (1Z0-083)
  • Oracle Database 18C: Managing Multitenant Architecture (1Z0-083)-Oracle Certified Professional (OCP)
  • This program is aimed at database administrators, data architects and professionals in IT who seek to specialize in SQL and ORACLE DATA MANAGEMENT at the business level

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

  • SQL DATABASES FUNDAMENTOS
  • Understand the basic concepts of relational databases
  • Create and manage database structures
  • Manipulate data using advanced SQL queries
  • Apply database optimization and modeling techniques
  • Manage transactions and blockages in multi -user databases
  • Oracle Database 19C: SQL Workshop (1Z0-082)
  • Apply SQL in Oracle database management
  • Create and manage users, roles and privileges in Oracle
  • Manage tables and data files
  • Optimize consultations and execution of consultation plans
  • Implement indexing and partitioning strategies
  • Oracle Database 19C: Administration Workshop (1Z0-082)
  • Install and configure Oracle Database 19C in business environments
  • Manage database processes and memory management
  • Configure Oracle networks and services for remote connections
  • Monitor performance and perform optimization settings
  • Implement safety and audit policies in Oracle databases
  • Oracle Database 19C: Backup and Recovery (1Z0-083)
  • Implement support and recovery strategies with RMAN
  • Perform diagnoses and recovery of faults in databases
  • Configure flashback technologies for rapid recovery
  • Use Oracle Data Pump and SQL Loader for data migrations
  • Configure high availability and disaster recovery
  • Oracle Database 18C: Multitenant Architecture Managing (1Z0-083)
  • Manage multitenant databases (CDB and PDB)
  • Implement safety strategies in multitenant environments
  • Optimize the performance and management of resources in CDB/PDB
  • Perform migrations and cloning of databases in Oracle
  • Configure backups and restorations in multitenant databases

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

  • Basic knowledge in computer science and relational databases
  • Experience in Data Consultation and Manipulation through SQL
  • Familiarity with Windows or Linux environments for database administration
  • These requirements guarantee that participants can focus on the advanced learning of database administration without initial technical difficulties

INTERNATIONAL CERTIFICATION SQL DATABASES FUNDAMENTS + ORACLE 19C DBA OCP Applies
INTERNATIONAL CERTIFICATION SQL DATABASES FUNDAMENTS + ORACLE 19C DBA OCP 164 hours

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.

Pre-enroll now

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.

To continue you must
Log In

Or if you don't have an account you must
Register

Description

This program provides comprehensive training in SQL database management and advanced administration in Oracle 19C, addressing from the structure and handling of databases to support and recovery strategies in business environments. It focuses on the architecture of Oracle Database 19C, its optimization and security. The course prepares participants to obtain international certifications:

  • SQL DATABASES FUNDAMENTS (SQLF-001)
  • Oracle Database 19C: SQL Workshop (1Z0-082)
  • Oracle Database 19C: Administration Workshop (1Z0-082)
  • Oracle Database 19C: Backup and Recovery (1Z0-083)
  • Oracle Database 18C: Managing Multitenant Architecture (1Z0-083)-Oracle Certified Professional (OCP)
  • This program is aimed at database administrators, data architects and professionals in IT who seek to specialize in SQL and ORACLE DATA MANAGEMENT at the business level

Objectives

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

  • SQL DATABASES FUNDAMENTOS
  • Understand the basic concepts of relational databases
  • Create and manage database structures
  • Manipulate data using advanced SQL queries
  • Apply database optimization and modeling techniques
  • Manage transactions and blockages in multi -user databases
  • Oracle Database 19C: SQL Workshop (1Z0-082)
  • Apply SQL in Oracle database management
  • Create and manage users, roles and privileges in Oracle
  • Manage tables and data files
  • Optimize consultations and execution of consultation plans
  • Implement indexing and partitioning strategies
  • Oracle Database 19C: Administration Workshop (1Z0-082)
  • Install and configure Oracle Database 19C in business environments
  • Manage database processes and memory management
  • Configure Oracle networks and services for remote connections
  • Monitor performance and perform optimization settings
  • Implement safety and audit policies in Oracle databases
  • Oracle Database 19C: Backup and Recovery (1Z0-083)
  • Implement support and recovery strategies with RMAN
  • Perform diagnoses and recovery of faults in databases
  • Configure flashback technologies for rapid recovery
  • Use Oracle Data Pump and SQL Loader for data migrations
  • Configure high availability and disaster recovery
  • Oracle Database 18C: Multitenant Architecture Managing (1Z0-083)
  • Manage multitenant databases (CDB and PDB)
  • Implement safety strategies in multitenant environments
  • Optimize the performance and management of resources in CDB/PDB
  • Perform migrations and cloning of databases in Oracle
  • Configure backups and restorations in multitenant databases

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

  • Basic knowledge in computer science and relational databases
  • Experience in Data Consultation and Manipulation through SQL
  • Familiarity with Windows or Linux environments for database administration
  • These requirements guarantee that participants can focus on the advanced learning of database administration without initial technical difficulties

offers

INTERNATIONAL CERTIFICATION SQL DATABASES FUNDAMENTS + ORACLE 19C DBA OCP Applies
INTERNATIONAL CERTIFICATION SQL DATABASES FUNDAMENTS + ORACLE 19C DBA OCP 164 hours

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.

Pre-enroll now
Download Syllabus