WhatsApp: +573224181125
customerservice@infinity.org

Oracle Database 19C: SQL Workshop (1Z0-082)

Oracle Database 19C: SQL Workshop (1Z0-082)

Módulos

Introducción

  • Objetivos del curso, programa del curso y apendices utilizadas en este curso
  • Visión general de Oracle 12 C y productos relacionados
  • Descripción general de los conceptos y terminologías de bases de datos relacionales
  • Introduccion a Sql y sus entornos de desarrollo
  • Que es Oracle Sql Developer
  • Acceso de Sql Plus desde Sql Developer
  • El esquema de recursos humanos (HR)
  • Tablas usadas en el curso

  • Capacidades de la sentencia SELECT
  • Expresiones aritmeticas y manejo de valores nulos
  • Alias en columnas
  • Uso de operadores de concatenación , cadenas de caracteres, operador quote y palabra clave DISTINCT
  • Uso del comando Describe

  • Filtrando los registros
  • Reglas de precedencia de operadores en una expresión
  • Sustitución de variables
  • Uso del comando DEFINE y VERIFY

  • Presentar las diferencias entre funciones de registro simple y de multiples registros
  • Manipular cadenas de caracteres con la clausula select y where
  • Manipular números con las funciones ROUND, TRUNC Y MOD
  • Hacer operaciones aritmeticas con fechas
  • Manipular fechas con las funciones de fechas

  • Describir la conversión de tipos de dato implicitas y explicitas
  • Utilizar las funciones de conversión TO_CHAR, TO_NUMBER y TO_DATE
  • Agrupar multiples funciones
  • Aplicar las funciones NVL, NULLIF y COALESCE a los datos
  • Usa la logica condicional IF THEN ELSE en una sentencia Select

  • Funciones de Grupo
  • Creando Grupos de datos
  • Restriccion de resultados de grupo

  • Introducción a Joins
  • Tipos de Joins
  • Natural Join
  • Self-join
  • Non equijoins
  • Outer Join

  • Introduccion a Subconsultas
  • Subqueries en filas simples
  • Subqueries en multiples filas

  • Operadores SET
  • Operador UNION ans UNION ALL
  • Operador INTERSECT
  • Operador MINUS
  • Coincidencias de las sentencias SELECT
  • Usando la clausula order by en operadores SET

  • Lenguaje de manipulacion de datos
  • Las transacciones de bases datos

  • Lenguaje de definición de datos

  • Introducción al diccionario de datos
  • Describir la estructura de los diccionarios de datos
  • Usando las vistas de los diccionarios de datos
  • Consultando las vistas de los diccionarios de datos

  • Descripción general de secuencias
  • Descripción general de sinonimos
  • Descripción general de indexes

  • Descripcion general de las vistas

  • Mostrando datos usando subconsultas como ruta
  • Trabajando con multiples columnas
  • Usando Scalar consultas en SQL
  • Subconsultas Subrelacionadas
  • Trabajando con la clausula With

  • Usando subconsultas para manipular datos
  • Inserción usando subconsulta como target
  • Usando la palabra WITH CHECK POINT en sentencias DML
  • Usando subconsultas correlacionadas para actualizar y eliminar campos

  • Privilegios de sistema
  • Creando un rol
  • Privilegios de objeto
  • Revocando privilegios de objeto

  • Descripción general
  • Usando INSERT en multiples tablas
  • Usando la sentencia MERGE
  • Realización de las operaciones de flashback
  • Seguimiento de cambios en los datos

  • Trabajando con CURRENT_DATE, CURRENT TIMESTAMP, Y LOCALTIMESTAMP
  • Tabajar con INTERVAL en tipos de datos

This course is designed to provide comprehensive training in management and manipulation of databases with SQL Oracle, covering from the creation of consultations and reports to the advanced administration of data and structures in Oracle Database 19C.

The course prepares participants to obtain international certification:

Oracle Database SQL (1Z0-082).

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

  • • Identify the main structural components of Oracle Database 19C
  • • Execute SQL sentences for handling and data management
  • • Create and manage tables, views and sequences
  • • Implement advanced consultations and subconsultations
  • • Manage user privileges and roles in Oracle Database
  • • Develop structured and aggregate data reports
  • • Use advanced operators and SQL functions to customize consultations
  • • Prepare for Oracle SQL 1Z0-082 certification

Courses

  1. SQL DATABASES INTERNATIONAL CERTIFICATION Fundamental

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

  • • Familiarity with data processing concepts and techniques
  • • Basic knowledge of computer science and databases
  • These requirements guarantee that participants can focus on SQL administration and development in Oracle without initial technical difficulties

Oracle Database 19C: SQL Workshop (1Z0-082) Applies
Oracle Database 19C: SQL Workshop (1Z0-082) 30 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
Or if you don't have an account you must

Description

This course is designed to provide comprehensive training in management and manipulation of databases with SQL Oracle, covering from the creation of consultations and reports to the advanced administration of data and structures in Oracle Database 19C.

The course prepares participants to obtain international certification:

Oracle Database SQL (1Z0-082).

Objectives

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

  • • Identify the main structural components of Oracle Database 19C
  • • Execute SQL sentences for handling and data management
  • • Create and manage tables, views and sequences
  • • Implement advanced consultations and subconsultations
  • • Manage user privileges and roles in Oracle Database
  • • Develop structured and aggregate data reports
  • • Use advanced operators and SQL functions to customize consultations
  • • Prepare for Oracle SQL 1Z0-082 certification

Courses

  1. SQL DATABASES INTERNATIONAL CERTIFICATION Fundamental

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

  • • Familiarity with data processing concepts and techniques
  • • Basic knowledge of computer science and databases
  • These requirements guarantee that participants can focus on SQL administration and development in Oracle without initial technical difficulties

offers

Oracle Database 19C: SQL Workshop (1Z0-082) Applies
Oracle Database 19C: SQL Workshop (1Z0-082) 30 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.

La metodología persigue que el estudiante "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
-->