International Business Intelligence SQL Server 2019 + Azure Data Scientist Certification Program

International Business Intelligence SQL Server 2019 + Azure Data Scientist Certification Program

Módulos

  • Resumen de Data Warehousing
  • Consideraciones para una solución de almacén de datos

  • Consideraciones para infraestructura de Data Warehouse
  • Planificación Hardware de almacén de datos

  • Diseño lógico para un almacén de datos
  • Diseño físico para un almacén de datos

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

  • Introducción a ETL con SSIS
  • Exploración de los datos de origen
  • Implementación del flujo de datos 

  • Introducción al flujo de control
  • Creación de paquetes dinámicos
  • Uso de contenedores

  • Depuración de un paquete SSIS
  • Registro de eventos del paquete SSIS
  • Manejo de errores en un paquete de SSIS

  • Introducción al Incremental ETL
  • Extracción de datos modificados
  • Mesas Temporales

  • Introducción a la calidad de los datos
  • Uso de servicios de calidad de datos para limpiar datos
  • Uso de los servicios de calidad de datos para coincidir con los datos

  • Usando componentes personalizados en SSIS
  • Usando Scripts de SSIS

  • Resumen de despliegue de SSIS
  • Implementar proyectos SSIS
  • Planificación ejecución del paquete SSIS

  • Introducción a la Inteligencia de Negocios
  • La plataforma de inteligencia empresarial de Microsoft

  • Introduccion al análisis multidimensional
  • Creacion de fuentes de datos y vistas de fuentes de datos
  • Creacion de un cubo
  • Vision general de la seguridad del cubo

  • Configuracion de dimensiones
  • Definir jerarquías de atributos
  • Clasificacion y clasificacion de atributos

  • Trabajo con medidas
  • Trabajar con grupos de medida

  • Fundamentos MDX
  • Agregar cálculos a un cubo
  • Utilizar MDX para consultar un cubo

  • Implementación de indicadores clave de rendimiento
  • Implementación de acciones
  • Implementando perspectivas
  • Implementación de traducciones

  • Introducción a los modelos de datos tabulares
  • Creación de un modelo de datos tabular
  • Utilización de un modelo tabular de servicios de análisis en una solución de BI empresarial

  • Fundamentos de DAX
  • Utilizar DAX para crear columnas y medidas calculadas en un modelo de datos tabular

  • Resumen de la minería de datos
  • Uso del complemento de minería de datos para Excel
  • Creación de una solución personalizada de minería de datos
  • Validación de un modelo de minería de datos
  • Conexión y consumo de un modelo de minería de datos

  • 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 Machine Learning
  • Herramientas de Azure Machine Learning

  • Modelos de capacitación con Designer
  • Publicación de modelos con Designer

  • Introducción a los experimentos
  • Formación y registro de modelos

  • Trabajar con almacenes de datos
  • Trabajar con conjuntos de datos

  • Trabajar con entornos
  • Trabajar con objetivos de cómputo

  • Introducción de canalizaciones
  • Publicación y ejecución de canalizaciones

  • Inferencia en tiempo real
  • Inferencia por lotes

  • Ajuste de hiperparámetro
  • Machine Learning automatizado

  • Introducción a la interpretación del modelo
  • Usando explicaciones del modelo

  • Modelos de monitorización con Application Insights
  • Monitorización de deriva de datos

This program is designed to provide comprehensive training in database administration in on-premise environments and in the cloud with Microsoft Azure, focusing on the implementation, maintenance, safety and optimization of SQL Server and Azure SQL databases. This program prepares participants to obtain international certifications:

  • SQL DATABASES FUNDAMENTS (SQLF-001)
  • Administrator SQL Server 2019 (administering a SQL Database Infrastructure + Provisioning SQL Databases)
  • Microsoft Certified Azure Data Fundamentals (DP-900) (included in pre-recorded videos)
  • Azure Database Administrator Associate (DP-300)
  • Participants will learn to design, manage and optimize SQL databases in business environments and in the Azure cloud, guaranteeing safety, scalability and efficiency in data management
  • 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:

  • Understand the basic concepts of relational databases and SQL
  • Create and manage database objects in SQL Server and Azure SQL
  • Execute consultations and manipulate data efficiently
  • Implement security strategies to protect data on SQL Server and Azure
  • Configure backup schemes, recovery and high availability in databases
  • Manage SQL Server with advanced tools, including Powershell
  • Supervise and optimize SQL database performance
  • Automate administrative tasks and manage databases in cloud and on-premise environments
  • Obtain international SQL Databases Fundamental certifications, administrator SQL Server 2019 and Azure Database Administrator Associate (DP-300)

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

  • Basic computer concepts
  • General knowledge about relational databases
  • Familiarity with SQL and basic consultations
  • Interest in Business Database Administration
  • These requirements guarantee that participants can focus on the administration of databases without initial technical difficulties

International Business Intelligence SQL Server 2019 + Azure Data Scientist Certification Program Applies
International Business Intelligence SQL Server 2019 + Azure Data Scientist Certification Program 64 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 is designed to provide comprehensive training in database administration in on-premise environments and in the cloud with Microsoft Azure, focusing on the implementation, maintenance, safety and optimization of SQL Server and Azure SQL databases. This program prepares participants to obtain international certifications:

  • SQL DATABASES FUNDAMENTS (SQLF-001)
  • Administrator SQL Server 2019 (administering a SQL Database Infrastructure + Provisioning SQL Databases)
  • Microsoft Certified Azure Data Fundamentals (DP-900) (included in pre-recorded videos)
  • Azure Database Administrator Associate (DP-300)
  • Participants will learn to design, manage and optimize SQL databases in business environments and in the Azure cloud, guaranteeing safety, scalability and efficiency in data management
  • 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:

  • Understand the basic concepts of relational databases and SQL
  • Create and manage database objects in SQL Server and Azure SQL
  • Execute consultations and manipulate data efficiently
  • Implement security strategies to protect data on SQL Server and Azure
  • Configure backup schemes, recovery and high availability in databases
  • Manage SQL Server with advanced tools, including Powershell
  • Supervise and optimize SQL database performance
  • Automate administrative tasks and manage databases in cloud and on-premise environments
  • Obtain international SQL Databases Fundamental certifications, administrator SQL Server 2019 and Azure Database Administrator Associate (DP-300)

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

  • Basic computer concepts
  • General knowledge about relational databases
  • Familiarity with SQL and basic consultations
  • Interest in Business Database Administration
  • These requirements guarantee that participants can focus on the administration of databases without initial technical difficulties

offers

International Business Intelligence SQL Server 2019 + Azure Data Scientist Certification Program Applies
International Business Intelligence SQL Server 2019 + Azure Data Scientist Certification Program 64 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