International Development SQL Server 2019 + Azure Data Engineer Program for International Certification

International Development SQL Server 2019 + Azure Data Engineer Program for International Certification

Módulos

  • La arquitectura básica de SQL Server
  • Versiones y ediciones de SQL Server
  • Primeros pasos con SQL Server Management Studio

  • Escritura de sentencias SELECT Simples
  • Eliminar duplicados con DISTINCT
  • Usando columnas y alias de tabla
  • Escribir expresiones casos Simple

  • Entender Joins
  • Consultas con Inners Joins
  • Consultas con Outer Joins
  • Consultar con Cross joins y self joins

  • Ordenar datos
  • Filtrar datos con predicados
  • Filtrado con el TOP y OFFSET-FETCH
  • Trabajar con valores desconocidos

  • Introducción de tipos de datos SQL Server 2019
  • Trabajando con datos de carácter
  • Trabajar con datos de tiempo y fecha

  • Insertar datos
  • Modificar y eliminar datos

  • Escribir consultas con funciones integradas
  • Utilizar funciones de conversión
  • Usando funciones lógicas
  • Utilizar funciones para trabajar con NULL

  • Usando funciones de agregación
  • Usando la clausula GROUP BY
  • Grupos de filtrado con having

  • Escribir subconsultas autónomas
  • Escribir subconsultas correlacionadas
  • Usando el prefijo Exist con subconsultas

  • Usando Vistas
  • Usando Funciones Inline Table-Valued
  • Usando tablas derivadas
  • Uso de expresiones comunes de tabla

  • Escribir consultas con PIVOT y UNPIVOT
  • Trabajar con conjuntos de agrupación

  • Consulta de datos con procedimientos almancenadoss
  • Pasando parametros a procedimientos almacenados
  • Creando Simple procedimientos almacenados
  • Trabajando con Sql Dinamico

  • Declaración de variables y delimitación de lotes
  • Uso de elementos de control de flujo
  • Uso de variables en una instrucción SQL dinámica
  • Uso de sinónimo

  • Implementación del manejo de errores T-SQL
  • Implementación del manejo estructurado de excepciones

  • Transacciones y los motores de base de datos
  • Control de transacciones

  • Introducción a la plataforma de SQL Server
  • Tareas de desarrollo de base de datos de SQL Server

  • Diseño de tablas
  • Tipos de datos
  • Trabajar con esquemas
  • Creación y modificación de tablas

  • Partición de datos
  • Compresión de datos
  • Mesas Temporales

  • Aplicación de la integridad de datos
  • Implementación de la integridad del dominio de datos
  • Implementación de la entidad y la integridad referencial

  • Conceptos básicos de indexación
  • Tipos de datos e índices
  • Índices apilados, agrupados y no agrupados
  • Índices de una sola columna y compuestos

  • Estrategias de índice
  • Gestión de índices
  • Planes de ejecución
  • El Asesor de optimización del motor de base de datos
  • Tienda de consultas

  • Introducción a los índices Columnstore
  • Creación de índices de columnas
  • Trabajar con los índices Columnstore

  • Introducción a las vistas
  • Creación y administración de vistas
  • Consideraciones de rendimiento para las vistas

  • Descripción general de las funciones
  • Diseño e implementación de funciones escalares
  • Diseño e implementación de funciones de valor de tabla
  • Consideraciones para la implementación de funciones
  • Alternativas a las funciones

  • Diseño de desencadenadores DML
  • Implementación de desencadenadores DML
  • Conceptos avanzador

  • Tablas optimizadas para la memoria
  • Procedimientos almacenados compilados de forma nativa

  • Introducción a los esquemas XML y XML
  • Almacenamiento de datos y esquemas XML en SQL Server
  • Implementación del tipo de datos XML
  • Uso de la sentencia de Transact-SQL FOR XML
  • Introducción a XQuery
  • Destruir XML

  • Introducción a los datos espaciales
  • Trabajar con tipos de datos espaciales de SQL Server
  • Uso de datos espaciales en aplicaciones

  • Consideraciones para los datos BLOB
  • Trabajar con FILESTREAM
  • Uso de la búsqueda de texto completo

  • Concurrencia y transacciones
  • Bloquo Internos

  • Conceptos básicos de datos
  • Roles y responsabilidades en el mundo de los datos
  • Conceptos de datos relacionales.
  • Conceptos de datos no relacionales
  • Conceptos de análisis de datos

  • Ofertas de datos relacionales en Azure
  • Aprovisionamiento e implementación de ofertas de bases de datos relacionales en Azure
  • Consultar datos relacionales en Azure

  • Ofertas de datos no relacionales en Azure
  • Aprovisionamiento e implementación de servicios de datos no relacionales en Azure
  • Administrar almacenes de datos no relacionales en Azure

  • Componentes de un almacén de datos moderno
  • Ingestión de datos en Azure
  • Almacenamiento y procesamiento de datos en Azure
  • Creando con Power BI

  • Introducción a Azure Synapse Analytics
  • Describir Azure Databricks
  • Introducción al almacenamiento de Azure Data Lake
  • Describir la arquitectura de Delta Lake - Trabajar con flujos de datos utilizando Azure Stream Analytics

  • Diseñar un esquema multidimensional para optimizar las cargas de trabajo analíticas
  • Transformación sin código a escala con Azure Data Factory
  • Rellenar dimensiones que cambian lentamente en los pipelines de Azure Synapse Analytics

  • Diseñar un almacén de datos moderno utilizando Azure Synapse Analytics
  • Asegurar un almacén de datos en Azure Synapse Analytics

  • Explorar capacidades de los pools SQL sin servidor de Azure Synapse
  • Consultar de datos en el lago utilizando pools SQL sin servidor de Azure Synapse
  • Crear objetos de metadatos en pools SQL sin servidor de Azure Synapse
  • Proteger datos y gestionar usuarios en pools SQL sin servidor de Azure Synapse

  • Comprender la ingeniería de big data con Apache Spark en Azure Synapse Analytics
  • Ingesta de datos con notebooks Apache Spark en Azure Synapse Analytics
  • Transformar datos con DataFrames en Apache Spark Pools en Azure Synapse Analytics
  • Integrar pools de SQL y Apache Spark en Azure Synapse Analytics

  • Describir Azure Databricks
  • Leer y escribir datos en Azure Databricks
  • Trabajar con DataFrames en Azure Databricks
  • Trabajar con métodos avanzados de DataFrames en Azure Databricks

  • Utilizar las mejores prácticas de carga de datos en Azure Synapse Analytics
  • Ingesta a escala de petabytes con Azure Data Factory

  • Integración de datos con Azure Data Factory o Azure Synapse Pipelines
  • Transformación sin código a escala con Azure Data Factory o Azure Synapse Pipelines

  • Orquestar el movimiento y la transformación de datos en Azure Data Factory

  • Optimizar el rendimiento de las consultas del almacén de datos en Azure Synapse Analytics
  • Comprender funciones de programador de almacén de datos de Azure Synapse Analytics

  • Analizar y optimizar almacenamiento del almacén de datos en Azure Synapse Analytics

  • Diseñar un procesamiento transaccional y analítico híbrido utilizando Azure Synapse Analytics
  • Configurar Azure Synapse Link con Azure Cosmos DB
  • Consultar Azure Cosmos DB con pools de Apache Spark
  • Consultar Azure Cosmos DB con pools SQL sin servidor

  • Asegurar un almacén de datos en Azure Synapse Analytics
  • Configurar y gestionar los secretos en Azure Key Vault
  • Implementar controles de cumplimiento para los datos sensibles

  • Habilitar la mensajería fiable para aplicaciones de Big Data utilizando Azure Event Hubs
  • Trabajar con flujos de datos utilizando Azure Stream Analytics
  • Ingerir flujos de datos con Azure Stream Analytics

  • Procesar datos de streaming con el streaming estructurado de Azure Databricks

  • Crear informes con Power BI utilizando su integración con Azure Synapse Analytics

  • Utilizar el proceso de aprendizaje automático integrado en Azure Synapse Analytics

This program provides integral training in database development with SQL Server 2019 and Azure Data Engineering, covering the creation, consultation, administration and optimization of databases in on-premise environments and in the cloud. This program prepares participants to obtain international certifications:

  • SQL Server 2019 Development
  • Microsoft Certified Azure Data Fundamentals (DP-900) (included in offline mode with pre-recorded videos)
  • Azure Data Engineer Associate (DP-203)
  • Participants will learn to develop scalable database solutions in SQL Server and Azure, implement query optimization strategies and configure data flows in the cloud
  • Following the practical Learning Method approach, students will develop practical laboratories, simulations and real projects, ensuring the application of knowledge acquired in a work environment

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

  • Design, develop and manage SQL Server and Azure SQL databases
  • Write complex consultations in Transact-SQL to handle large volumes of data
  • Optimize the performance of databases and SQL consultations
  • Implement indexing strategies, views and stored procedures
  • Transform data with tools such as Azure Data Factory and Azure Synapse Pipelines
  • Eating and loading data in modern data stores in Azure
  • Automate data engineering processes with Apache Spark and Azure Databricks
  • Perform real -time flow processing with Azure Stream Analytics and Event Hubs
  • Implement safety and compliance in cloud databases
  • Obtain international SQL Server 2019 Development and Azure Data Engineer Associate (DP-203) international certifications

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

  • Basic knowledge in databases or having taken the SQL Databases fundamental course in matrix classroom
  • Familiarity with SQL and basic consultations
  • Experience in data manipulation and database structures
  • These requirements guarantee that participants can focus on the development and administration of databases without initial technical difficulties

International Development SQL Server 2019 + Azure Data Engineer Program for International Certification Applies
International Development SQL Server 2019 + Azure Data Engineer Program for International Certification 72 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 program provides integral training in database development with SQL Server 2019 and Azure Data Engineering, covering the creation, consultation, administration and optimization of databases in on-premise environments and in the cloud. This program prepares participants to obtain international certifications:

  • SQL Server 2019 Development
  • Microsoft Certified Azure Data Fundamentals (DP-900) (included in offline mode with pre-recorded videos)
  • Azure Data Engineer Associate (DP-203)
  • Participants will learn to develop scalable database solutions in SQL Server and Azure, implement query optimization strategies and configure data flows in the cloud
  • Following the practical Learning Method approach, students will develop practical laboratories, simulations and real projects, ensuring the application of knowledge acquired in a work environment

Objectives

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

  • Design, develop and manage SQL Server and Azure SQL databases
  • Write complex consultations in Transact-SQL to handle large volumes of data
  • Optimize the performance of databases and SQL consultations
  • Implement indexing strategies, views and stored procedures
  • Transform data with tools such as Azure Data Factory and Azure Synapse Pipelines
  • Eating and loading data in modern data stores in Azure
  • Automate data engineering processes with Apache Spark and Azure Databricks
  • Perform real -time flow processing with Azure Stream Analytics and Event Hubs
  • Implement safety and compliance in cloud databases
  • Obtain international SQL Server 2019 Development and Azure Data Engineer Associate (DP-203) international certifications

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

  • Basic knowledge in databases or having taken the SQL Databases fundamental course in matrix classroom
  • Familiarity with SQL and basic consultations
  • Experience in data manipulation and database structures
  • These requirements guarantee that participants can focus on the development and administration of databases without initial technical difficulties

offers

International Development SQL Server 2019 + Azure Data Engineer Program for International Certification Applies
International Development SQL Server 2019 + Azure Data Engineer Program for International Certification 72 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.

Download Syllabus