Course Modules
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
Mostrar datos usando la sentencia SQL SELECT
- 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 y ordenando datos
- Filtrando los registros
- Reglas de precedencia de operadores en una expresión
- Sustitución de variables
- Uso del comando DEFINE y VERIFY
Utilizando Funciones de registro para personalizar la salida
- 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
Uso de funciones de conversión y expresiones condicionales
- 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
Reportes usando datos agregadoscon funciones de grupos
- Funciones de Grupo
- Creando Grupos de datos
- Restriccion de resultados de grupo
Mostrar datos desde multiples tablas usando Joins
- Introducción a Joins
- Tipos de Joins
- Natural Join
- Self-join
- Non equijoins
- Outer Join
Usando Subconsultas para resolver Cosultas
- Introduccion a Subconsultas
- Subqueries en filas simples
- Subqueries en multiples filas
Usando los operadores SET
- Operadores SET
- Operador UNION ans UNION ALL
- Operador INTERSECT
- Operador MINUS
- Coincidencias de las sentencias SELECT
- Usando la clausula order by en operadores SET
Administrar tablas usando sentencias DML
- Lenguaje de manipulacion de datos
- Las transacciones de bases datos
Introduccion al lenguaje de defiición de datos
- Lenguaje de definición de datos
Introducción a diccionario de datos , vistas
- 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
Creando Secuencias , sinonimos e Indexes
- Descripción general de secuencias
- Descripción general de sinonimos
- Descripción general de indexes
Creando Vistas
- Descripcion general de las vistas
Mostrando datos usando Subconsultas
- Mostrando datos usando subconsultas como ruta
- Trabajando con multiples columnas
- Usando Scalar consultas en SQL
- Subconsultas Subrelacionadas
- Trabajando con la clausula With
Manipulación de datos usando subconsultas
- 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
Controlar el acceso a usuarios
- Privilegios de sistema
- Creando un rol
- Privilegios de objeto
- Revocando privilegios de objeto
Manipulando Datos
- 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
Gestión de datos en diferentes Zonas Horarias
- Trabajando con CURRENT_DATE, CURRENT TIMESTAMP, Y LOCALTIMESTAMP
- Tabajar con INTERVAL en tipos de datos
Current process 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
Prerequisites
Preferred schedule
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
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| Oracle Database 19C: SQL Workshop (1Z0-082) | 30 hours |
| • E-learning reinforcement topics and exclusive materials and simulators | • Complementary platform with digital resources, study guides, support recordings and exam simulators. |
| • Flexible educational model (in-person or live remote) | • Possibility to choose modality without losing human interaction and teaching support. |
| • Focus on employability and professional performance and exam preparation. | • Preparation oriented to certification, job performance and professional scaling based on practice, enhanced with AI support. |
| • Integration of Artificial Intelligence in learning | • Students use AI tools to reinforce understanding, practice exams and enhance their productivity. |
| • International Certification included | • Official endorsement with global recognition. Includes certification exams and access to the partner platform. |
| • Laboratories in real learning environments. | • Unlimited practical experience with real lab accounts and access to professional cloud infrastructure. |
| • Live classes with certified expert instructors. | • Guided and personalized training with direct real-time support, not offline. Recorded classes only for review. |
| • Personalized attention, small groups. | • Individual tracking, progress evaluations and technical support during training. AI-proctored performance examiner. |
| • Post-certification support and extended access to resources | • Post-assistance, access to materials for and continuous updates. |
| • Practical methodology and real and/or simulated projects. | • Applied learning from day one: simulations, business cases, projects and real cloud environments. |
| • Certificates of Approval and/or participation. | • International Certification by Oracle Academy
• Infinity Training Institute USA: International Certification Diploma in English • Aula Matriz IETDH Colombia - Certificate of participation |
Why choose Infinity Training Institute?
1. Internationally guaranteed certifications
All our courses are Internationally certified:
- Infinity Training Institute USA: International Certification Diploma in English.
- International Certification from our partners Microsoft, Oracle, Certitalents, AWS, PMI, Cisco, etc.
2. We are not an automatic platform, nor self-study through videos
We are a unique model, in-person or Remote modality (with live instructor). Technology + pedagogy + AI + expert instructors + real practice — not self-study or outdated content.
3. Training designed for today's job market
Experience applicable immediately in interviews, technical tests and real work environments.
4. Real or simulated projects with international standards
Students access real environments such as Azure, AWS, Google Cloud, Oracle Cloud, develop real or simulated projects, building a demonstrable technical portfolio depending on the type of course or certification they have chosen.
5. A unique combination in Latin America and the USA
Certification + real practice + AI + continuous support + dual diploma.
6. Proven results
More than 95% of our graduates obtain official certification and improve professionally in less than six months.
7. Competency level guarantee
If the student during the practical training process does not reach a minimum performance level of 75%, they must repeat the course if the instructor determines so, and the student has shown the commitment and minimum class attendance required by the model.
Your professional future starts here
At Infinity Training Institute we boost your growth with an innovative, flexible model focused on real learning and performance evaluation. Certified instructors, intensive practice, integrated AI and constant support: world-class training.
All our courses are Internationally certified:
- Infinity Training Institute USA: International Certification Diploma in English.
- International Certification from our partners Microsoft, Oracle, Certitalents, AWS, PMI, Cisco, etc.
2. We are not an automatic platform, nor self-study through videos
We are a unique model, in-person or Remote modality (with live instructor). Technology + pedagogy + AI + expert instructors + real practice — not self-study or outdated content.
3. Training designed for today's job market
Experience applicable immediately in interviews, technical tests and real work environments.
4. Real or simulated projects with international standards
Students access real environments such as Azure, AWS, Google Cloud, Oracle Cloud, develop real or simulated projects, building a demonstrable technical portfolio depending on the type of course or certification they have chosen.
5. A unique combination in Latin America and the USA
Certification + real practice + AI + continuous support + dual diploma.
6. Proven results
More than 95% of our graduates obtain official certification and improve professionally in less than six months.
7. Competency level guarantee
If the student during the practical training process does not reach a minimum performance level of 75%, they must repeat the course if the instructor determines so, and the student has shown the commitment and minimum class attendance required by the model.
Your professional future starts here
At Infinity Training Institute we boost your growth with an innovative, flexible model focused on real learning and performance evaluation. Certified instructors, intensive practice, integrated AI and constant support: world-class training.
Learning Methodology
At Infinity Training Institute, we apply a comprehensive, ever-evolving methodology centered on practical learning, powered by Artificial Intelligence, enabling personalized instruction, performance assessment, and optimized preparation for international certifications with certified instructors, real labs, simulators, and e-learning platforms. Participants learn by doing, developing technical and professional skills in small groups, with personalized follow-up and pre and post-certification support. Infinity Training Institute: Learn. Apply. Get Certified. Transcend.
Current process 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
Prerequisites
Preferred schedule
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
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| Oracle Database 19C: SQL Workshop (1Z0-082) | 30 hours |
| • E-learning reinforcement topics and exclusive materials and simulators | • Complementary platform with digital resources, study guides, support recordings and exam simulators. |
| • Flexible educational model (in-person or live remote) | • Possibility to choose modality without losing human interaction and teaching support. |
| • Focus on employability and professional performance and exam preparation. | • Preparation oriented to certification, job performance and professional scaling based on practice, enhanced with AI support. |
| • Integration of Artificial Intelligence in learning | • Students use AI tools to reinforce understanding, practice exams and enhance their productivity. |
| • International Certification included | • Official endorsement with global recognition. Includes certification exams and access to the partner platform. |
| • Laboratories in real learning environments. | • Unlimited practical experience with real lab accounts and access to professional cloud infrastructure. |
| • Live classes with certified expert instructors. | • Guided and personalized training with direct real-time support, not offline. Recorded classes only for review. |
| • Personalized attention, small groups. | • Individual tracking, progress evaluations and technical support during training. AI-proctored performance examiner. |
| • Post-certification support and extended access to resources | • Post-assistance, access to materials for and continuous updates. |
| • Practical methodology and real and/or simulated projects. | • Applied learning from day one: simulations, business cases, projects and real cloud environments. |
| • Certificates of Approval and/or participation. | • International Certification by Oracle Academy
• Infinity Training Institute USA: International Certification Diploma in English • Aula Matriz IETDH Colombia - Certificate of participation |
Why choose Infinity Training Institute?
1. Internationally guaranteed certificationsAll our courses are Internationally certified:
- Infinity Training Institute USA: International Certification Diploma in English.
- International Certification from our partners Microsoft, Oracle, Certitalents, AWS, PMI, Cisco, etc.
2. We are not an automatic platform, nor self-study through videos
We are a unique model, in-person or Remote modality (with live instructor). Technology + pedagogy + AI + expert instructors + real practice — not self-study or outdated content.
3. Training designed for today's job market
Experience applicable immediately in interviews, technical tests and real work environments.
4. Real or simulated projects with international standards
Students access real environments such as Azure, AWS, Google Cloud, Oracle Cloud, develop real or simulated projects, building a demonstrable technical portfolio depending on the type of course or certification they have chosen.
5. A unique combination in Latin America and the USA
Certification + real practice + AI + continuous support + dual diploma.
6. Proven results
More than 95% of our graduates obtain official certification and improve professionally in less than six months.
7. Competency level guarantee
If the student during the practical training process does not reach a minimum performance level of 75%, they must repeat the course if the instructor determines so, and the student has shown the commitment and minimum class attendance required by the model.
Your professional future starts here
At Infinity Training Institute we boost your growth with an innovative, flexible model focused on real learning and performance evaluation. Certified instructors, intensive practice, integrated AI and constant support: world-class training.
Learning Methodology
At Infinity Training Institute, we apply a comprehensive, ever-evolving methodology centered on practical learning, powered by Artificial Intelligence, enabling personalized instruction, performance assessment, and optimized preparation for international certifications with certified instructors, real labs, simulators, and e-learning platforms. Participants learn by doing, developing technical and professional skills in small groups, with personalized follow-up and pre and post-certification support. Infinity Training Institute: Learn. Apply. Get Certified. Transcend.