SQL DATABASES INTERNATIONAL CERTIFICATION Fundamental

SQL DATABASES INTERNATIONAL CERTIFICATION Fundamental

Módulos

Modulo I: Introducción

  • Introducción a bases de datos  
    • No relacionales    
    •   Relacionales  
    • Terminología básica
  • Que 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 invalidas de fecha

  • Mecanismos de las consultas
  • Clausulas de las consultas
  • Clausula select  
    • Alias
    • Remover duplicados
    • Clausula from      
    • Tablas    
    • Tablas enlazadas      
    • Definir alias de las tablas
  • Clausula where
  • Clausula group by y having
  • Clausula order by

  • Condiciones
    • Uso de parámetros
    • Operador not
  • Construcción de condiciones
  • Tipos de condiciones Igualdad
    • Rango
    • Membresia
    • Semejanza
  • Null

  • Que es el join
    • Producto cartesiano
    • Inner joins
    • Sintaxis Ansi join
  • Join tres o mas tablas
    • Usar subqueries como tablas
    • Uso de la misma tabla dos veces

  • Teoría de conjuntos
  • Teoría de conjuntos en practica 
  • Operadores de conjuntos
    • Unión
    • Intersect
    • Except
  • Reglas de operaciones de conjuntos
    • Ordenar queries compuestos
    • Presedencia de las operaciones

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

  • Conceptos de agrupación
  • Funciones de agregación      
    • Implicito versus explicito      
    • Contar valores distintos      
    • Usar expresiones      
    • Como son null interpretados
  • Generar agrupaciones      
    • Una columna      
    • Multiples columnas      
    • Agrupar con expresiones

  • Que es un subquery 
  • Tipos de subqueries 
  • Subqueries no relacionados
    • Multiple columna
    • Multiple fila, única columna 
  • Subqueries relacionados
    • Operador exists
    • Manipulación de datos usando subqueries 
  • Cuando utilizar subqueries.
    • |Subquery como origen de datos
    • Subquery como expresión

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

  • Que son las vistas 
  • Porque usar vistas
    • Seguridad de los datos
    • Agregación de datos
    • Ocultar complejidad
    • Unir tablas particionadas

The SQL DATABASES Fundamental course is designed to provide participants with a solid understanding of relational databases, SQL language and basic database administration.

This course prepares students to obtain international certification:

SQL DATABASES FUNDAMENTS (SQLF-001).

Aimed at people interested in starting their career in database administration, the course covers from the foundations to the management and optimization of SQL consultations.

Under the practical Learning Method approach, participants will work on laboratories, practical workshops and/or real projects, ensuring the effective application of knowledge acquired in business environments.

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

  • Understand the basic concepts of databases, including relational and non -relational databases
  • Create and manage database objects, such as tables and schemes
  • Manipulate data through SQL sentences (SELECT, INSERT, UPDATE, DELETE)
  • Optimize SQL queries, using standardization rates and techniques
  • Apply transactions and concurrence control, ensuring the integrity of the data
  • Manage and manage databases, implementing good practices in SQL
  • Obtain the International SQL Databases Fundamental certification (SQLF-001)

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

  • Basic knowledge of computer science
  • These requirements ensure that participants can focus on the practical application of development with SQL without initial technical difficulties

SQL DATABASES INTERNATIONAL CERTIFICATION Fundamental Applies
SQL DATABASES INTERNATIONAL CERTIFICATION Fundamental 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

The SQL DATABASES Fundamental course is designed to provide participants with a solid understanding of relational databases, SQL language and basic database administration.

This course prepares students to obtain international certification:

SQL DATABASES FUNDAMENTS (SQLF-001).

Aimed at people interested in starting their career in database administration, the course covers from the foundations to the management and optimization of SQL consultations.

Under the practical Learning Method approach, participants will work on laboratories, practical workshops and/or real projects, ensuring the effective application of knowledge acquired in business environments.

Objectives

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

  • Understand the basic concepts of databases, including relational and non -relational databases
  • Create and manage database objects, such as tables and schemes
  • Manipulate data through SQL sentences (SELECT, INSERT, UPDATE, DELETE)
  • Optimize SQL queries, using standardization rates and techniques
  • Apply transactions and concurrence control, ensuring the integrity of the data
  • Manage and manage databases, implementing good practices in SQL
  • Obtain the International SQL Databases Fundamental certification (SQLF-001)

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

  • Basic knowledge of computer science
  • These requirements ensure that participants can focus on the practical application of development with SQL without initial technical difficulties

offers

SQL DATABASES INTERNATIONAL CERTIFICATION Fundamental Applies
SQL DATABASES INTERNATIONAL CERTIFICATION Fundamental 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.

-->