• No hay productos en el carrito.

Inicio / Cursos / Project on Covid19
Impartido por Ramesh Retnasamy . 200,000+ LearnersPago único de $2,800 MXN · acceso por 12 meses

Project on Covid19

Real world project for Data Engineers using Azure Data Factory, SQL, Data Lake, Databricks, HDInsight, CI/CD [DP203]

Certificado oficial emitido por la SEPA través del Gobierno del Estado de México
12 meses de acceso En línea · 60 h 17 unidades
Qué aprenderás

Lo que serás capaz de hacer

Major updates to the course since the launch October 2023 - Updates related to UI changes to Storage Browser & Azure Data Factory. Renaming of Azure Active Directory to Microsoft Entra ID & Default settings changes to Devops Organisation January 2023 - Updates to section 3 (Environment Set-up) to reflect the change to the User Interface. Re-recorded 5 lessons. November 2022 - Addition of sections 15 & 16 focusing on Continuous Integration & Continuous Delivery (CI/CD) Welcome! I am looking forward to helping you with learning one of the in-demand data engineering tools in the cloud, Azure Data Factory (ADF)! This course has been taught with implementing a data engineering solution using Azure Data Factory (ADF) for a real world problem of reporting Covid-19 trends and prediction of the spread of this virus. This is like no other course in Udemy for Azure Data Factory or Data Engineering Technologies. Once you have completed the course including all the assignments, I strongly believe that you will be in a position to start a real world data engineering project on your own and also proficient on Azure Data Factory (ADF). I have also included lessons on the storage solutions such as Azure Data Lake Storage, Azure Blob Storage, Azure SQL Database etc. Also, there are lessons on Azure HDInsight and Azure Databricks. I have even included lessons on building reports using Power BI on the data processed by the Azure Data Factory data pipelines. I have considered the machine learning models to be out of scope. You can use this data to build your own models and predict the spread. The course follows a logical progression of real world project implementation with technical concepts being explained and the data pipelines in Azure Data Factory (ADF) being built at the same time. Even-though this course is not specifically designed to teach you the skills required for passing the Azure Data Engineer Associate Certification exam DP203, it can greatly help you get most of the necessary skills required for the exam. I value your time as much as I do mine. So, I have designed this course to be fast-paced and to the point. Also, the course has been taught with simple English and no jargons. I start the course from basis and by the end of the course you will be proficient in the technologies used. Currently the course teaches you the following Azure Data Factory Building a solution architecture for a data engineering solution using Azure Data Engineering technologies such as Azure Data Factory (ADF), Azure Data Lake Gen2, Azure Blob Storage, Azure SQL Database, Azure Databricks, Azure HDInsight and Microsoft PowerBI. Integrating data from HTTP clients, Azure Blob Storage and Azure Data Lake Gen2 using Azure Data Factory. Branching and Chaining activities in Azure Data Factory (ADF) Pipelines using control flow activities such as Get Metadata. If Condition, ForEach, Delete, Validation etc. Using Parameters and Variables in Pipelines, Datasets and LinkedServices to create a metadata driven pipelines in Azure Data Factory (ADF) Debugging the data pipelines and resolving issues. Scheduling pipelines using triggers such as Event Trigger, Schedule Trigger and Tumbling Window Trigger in Azure Data Factory (ADF) Creating Mapping Data Flows to create transformation logic. The course covers all of the transformation steps such as Source, Filter, Select, Pivot, Lookup, Conditional Split, Derived Column, Aggregate, Join and Sink transformation. Debugging data flows, investigating issues, fixing failures etc Implementing Azure Data Factory pipelines to invoke Mapping Data Flows and executing them. Creating ADF pipelines to execute HDInsight activities and carry out data transformations. Creating ADF pipelines to execute Databricks Notebook activities to carry out transformations. Creating dependency between pipelines to orchestrate the data flow Creating dependency between triggers to orchestrate the data flow Monitoring data pipelines, creating alerts, reporting of metrics from the Azure Data Factory Monitor. Monitoring of Data Factory pipelines using Azure Monitor and setting diagnostic setting to be forwarded to Azure Storage Account or Log Analytics Workspace. Creating Log Analytics workspace, creating workbooks and charts from log analytics on the Azure Data Factory pipelines Implementing the Azure Data Factory Analytics monitoring tool and how to extend the capability further. Azure Storage Solutions Creating Azure Storage Account, Creating containers, Uploading data, Access Control (IAM), Using Azure Storage explorer to interact with the storage account Creating Azure Data Lake Gen2, Creating containers, Uploading data, Access Control (IAM), Using Azure Storage explorer to interact with the storage account Creating Azure SQL Database, Pricing Tiers, Creating Admin User, Creating Tables, Loading Data and Querying the database. Azure HDInsight & Databricks Creating HDInsight Clusters, Interacting with the UI, Using Ambari, Creating Hive tables, Invoking HDInsight activities from Azure Data Factory Creating Azure Databricks Workspace, Creating Databricks clusters, Mounting storage accounts, Creating Databricks notebooks, performing transformations using Databricks notebooks, Invoking Databricks notebooks from Azure Data Factory. Azure Devops (CI/CD) Creating Azure Devops Environment and configuring Azure Devops Git Repository CI/ CD process for releasing Azure Data Factory artefacts to higher environments Creating build and release pipelines in Azure Devops to release code to higher environments (Test/ Prod) Configuring/ Parameterise CI/CD pipelines to release ADF pipelines that access Azure Data Lake Storage.

  • You will learn how to build a real-world data pipeline in Azure Data Factory (ADF).
  • You will acquire good Data Engineering skills in Azure using Azure Data Factory (ADF), Azure Data Lake Storage Gen2, Azure SQL Database and Azure Monitor
  • You will learn how to ingest data from sources such as HTTP and Azure Blob Storage into Azure Data Lake Gen2 using Azure Data Factory (ADF)
  • You will learn how to transform data using Data Flows in Azure Data Factory (ADF) and load into Azure Data Lake Storage Gen2
  • You will learn how to transform data using Databricks Notebook Activity in Azure Data Factory (ADF) and load into Azure Data Lake Storage Gen2
  • You will learn how to transform data using Azure HDInsight Activity in Azure Data Factory (ADF) and load into Azure Data Lake Storage Gen2

Temario

UNIDAD 1 - Introduction · 3 lecciones

UNIDAD 1 - Introduction

  • Course IntroductionVideo · 5 min
  • Course StructureVideo · 2 min
  • Course Slides DownloadLectura · 0 min
UNIDAD 2 - Overviews · 5 lecciones

UNIDAD 2 - Overviews

  • Azure Data Factory OverviewVideo · 6 min
  • Project OverviewVideo · 4 min
  • Solution Architecture OverviewVideo · 6 min
  • Azure Storage Solutions OverviewVideo · 6 min
  • Useful Links & ResourcesLectura · 0 min
UNIDAD 3 - Environment Set-up · 9 lecciones

UNIDAD 3 - Environment Set-up

  • Environment Set-up - Module OverviewVideo · 2 min
  • Creating Azure Free AccountVideo · 6 min
  • Azure Portal OverviewVideo · 4 min
  • Creating Azure Data FactoryVideo · 4 min
  • Creating Azure Storage AccountVideo · 4 min
  • Installing Azure Storage ExplorerVideo · 4 min
  • Creating Azure Data Lake Storage Gen2Video · 4 min
  • Creating Azure SQL DatabaseVideo · 6 min
  • Useful Links & ResourcesLectura · 0 min
UNIDAD 4 - Data Ingestion from Azure Blob · 12 lecciones

UNIDAD 4 - Data Ingestion from Azure Blob

  • Data Ingestion from Azure Blob - Module OverviewVideo · 2 min
  • Copy Activity OverviewVideo · 6 min
  • Environment PreparationVideo · 4 min
  • Naming StandardsVideo · 3 min
  • Linked Services & Data SetsVideo · 9 min
  • Creating ADF PipelineVideo · 9 min
  • Control Flow Activities (1) - Validation ActivityVideo · 7 min
  • Control Flow Activities (2) - Get Metadata, If Condition, Web ActivitiesVideo · 10 min
  • Control Flow Activities (3) - Delete ActivityVideo · 3 min
  • ADF Triggers OverviewVideo · 9 min
  • Creating Event TriggerVideo · 8 min
  • Useful Links & ResourcesLectura · 0 min
UNIDAD 5 - Data Ingestion From HTTP · 12 lecciones

UNIDAD 5 - Data Ingestion From HTTP

  • Important - Recent Changes to ECDC DataVideo · 4 min
  • Data Ingestion From HTTP - Module OverviewVideo · 2 min
  • ECDC Data OverviewVideo · 6 min
  • Create PipelineVideo · 11 min
  • Frequently Asked Questions - Please ReadLectura · 0 min
  • Pipeline VariablesVideo · 9 min
  • Pipeline Parameters & Schedule TriggerVideo · 9 min
  • Control Flow ActivitiesVideo · 11 min
  • ADF potential bug in the next lesson - Please ReadLectura · 0 min
  • Linked Service ParametersVideo · 5 min
  • Metadata Driven PipelineVideo · 9 min
  • Useful Links & ResourcesLectura · 0 min
UNIDAD 6 - Data Flows - Cases & Deaths Data Transformation · 12 lecciones

UNIDAD 6 - Data Flows - Cases & Deaths Data Transformation

  • Data Flows(1) - Module OverviewVideo · 1 min
  • Introduction to Data FlowsVideo · 5 min
  • Data Flow UI OverviewVideo · 8 min
  • Transformation Requirement OverviewVideo · 7 min
  • Source TransformationVideo · 13 min
  • Filter TransformationVideo · 5 min
  • Select TransformationVideo · 9 min
  • Pivot TransformationVideo · 7 min
  • Lookup TransformationVideo · 8 min
  • Sink TransformationVideo · 6 min
  • Create ADF PipelineVideo · 9 min
  • Useful Links & ResourcesLectura · 0 min
UNIDAD 7 - Data Flows - Hospital Admissions Data Transformation · 15 lecciones

UNIDAD 7 - Data Flows - Hospital Admissions Data Transformation

  • Data Flows(2) - Module OverviewVideo · 1 min
  • Transformation RequirementVideo · 7 min
  • Source Transformation (Assignment)Video · 3 min
  • Select Transformation (Assignment)Video · 2 min
  • Lookup Country (Assignment)Video · 4 min
  • Conditional Split TransformationVideo · 3 min
  • Source Transformation - DimDateVideo · 4 min
  • Derived Column TransformationVideo · 4 min
  • Aggregate TransformationVideo · 5 min
  • Join TransformationVideo · 5 min
  • Pivot Transformation (Assignment)Video · 9 min
  • Sort TransformationVideo · 4 min
  • Sink Transformation (Assignment)Video · 9 min
  • Create ADF Pipeline (Assignment)Video · 9 min
  • Useful Links & ResourcesLectura · 0 min
UNIDAD 8 - Prepare Data for HDInsight & Databricks · 1 lecciones

UNIDAD 8 - Prepare Data for HDInsight & Databricks

  • Prepare Data for HDInsight & DatabricksVideo · 8 min
UNIDAD 9 - HDInsight Activity · 9 lecciones

UNIDAD 9 - HDInsight Activity

  • HDInsight Activity - Module OverviewVideo · 2 min
  • Note for Azure Free Tier & Student Subscription usersLectura · 0 min
  • Create HDInsight ClusterVideo · 12 min
  • Tour of the HDInsight UIVideo · 6 min
  • Transformation RequirementVideo · 2 min
  • Hive Script WalkthroughVideo · 7 min
  • Create ADF Pipeline with Hive ActivityVideo · 8 min
  • Delete HDInsight ClusterVideo · 3 min
  • Useful Links & ResourcesLectura · 0 min
UNIDAD 10 - Databricks Activity · 9 lecciones

UNIDAD 10 - Databricks Activity

  • Databricks Activity - Module OverviewVideo · 2 min
  • Cluster Configuration - Only for Free and Student SubscriptionsLectura · 0 min
  • Create Azure Databricks ServiceVideo · 5 min
  • Create Azure Databricks ClusterVideo · 7 min
  • Mounting Azure Data Lake StorageVideo · 10 min
  • Transformation RequirementsVideo · 8 min
  • Create ADF Pipeline Databricks Notebook ActivityVideo · 10 min
  • Only for students using Free Azure SubscriptionLectura · 0 min
  • Useful Links & ResourcesLectura · 0 min
UNIDAD 11 - Copy Data to Azure SQL · 5 lecciones

UNIDAD 11 - Copy Data to Azure SQL

  • Copy Data to Azure SQL - Module OverviewVideo · 1 min
  • Copy Data Activity - Cases & Deaths DataVideo · 9 min
  • Copy Data Activity - Hospital Admissions DataVideo · 5 min
  • Copy Data Activity - Testing DataVideo · 8 min
  • Useful Links and ResourcesLectura · 0 min
UNIDAD 12 - Making Pipelines Production Ready · 4 lecciones

UNIDAD 12 - Making Pipelines Production Ready

  • Making Pipelines Production Ready - Module OverviewVideo · 7 min
  • Option 1 - Pipeline DependencyVideo · 11 min
  • Option 2 - Trigger DependencyVideo · 12 min
  • Useful Links & ResourcesLectura · 0 min
UNIDAD 13 - Monitoring · 12 lecciones

UNIDAD 13 - Monitoring

  • Monitoring - Module OverviewVideo · 1 min
  • What to Monitor & HowVideo · 4 min
  • Azure Data Factory MonitorVideo · 6 min
  • Creating AlertsVideo · 6 min
  • Monitor Pipeline FailuresVideo · 5 min
  • Re-run Failed PipelinesVideo · 7 min
  • Reporting on MetricsVideo · 5 min
  • Introduction to Azure MonitorVideo · 6 min
  • Introduction to Log AnalyticsVideo · 7 min
  • Log Analytics Further capabilitiesVideo · 9 min
  • Azure data factory analyticsVideo · 4 min
  • Useful Links & ResourcesLectura · 0 min
UNIDAD 14 - Power BI Reports · 5 lecciones

UNIDAD 14 - Power BI Reports

  • Power BI Reports - Module OverviewVideo · 1 min
  • Introduction to PowerBI DesktopVideo · 9 min
  • Walk through the Covid-19 ReportVideo · 6 min
  • Useful Links & ResourcesLectura · 0 min
  • Sample QuizCuestionario · 0 min
UNIDAD 15 - Continuous Integration / Continuous Delivery (CI/CD) · 22 lecciones

UNIDAD 15 - Continuous Integration / Continuous Delivery (CI/CD)

  • Continuous Integration/ Continuous Delivery - Module OverviewVideo · 1 min
  • Introduction to Continuous Integration/ Continuous Delivery (CI/CD)Video · 7 min
  • Introduction to CI/CD for Azure Data FactoryVideo · 5 min
  • Overview of Azure DevOpsVideo · 3 min
  • Azure DevOps Environment Set-upVideo · 9 min
  • Azure Data Factory Environment Set-upVideo · 4 min
  • Azure Data Factory Git ConfigurationVideo · 8 min
  • Azure Data Factory Code Development using GitVideo · 13 min
  • Option 1 - Manual BuildVideo · 4 min
  • Option 1 - Release Pipeline DesignVideo · 3 min
  • Option 1 - Creating ARM Deployment TaskVideo · 14 min
  • Option 1 - Testing ARM Deployment TaskVideo · 6 min
  • Option 1 - Pitfalls of ARM Deployment TaskVideo · 8 min
  • Option 1 - Pre and Post Deployment TasksVideo · 14 min
  • Option 1 - Pipeline VariablesVideo · 4 min
  • Option 1 - Add Production StageVideo · 9 min
  • Option 2 - OverviewVideo · 6 min
  • Option 2 - YAML Build Pipeline Script WalkthroughVideo · 6 min
  • Option 2 - Create YAML Build PipelineVideo · 5 min
  • Option 2 - Update Release PipelineVideo · 8 min
  • Option 2 - CI/CD End to End TestingVideo · 5 min
  • Useful Links & ResourcesLectura · 0 min
UNIDAD 16 - CI/CD Scenario - Data Lake Access · 9 lecciones

UNIDAD 16 - CI/CD Scenario - Data Lake Access

  • Access to Data Lake Storage OverviewVideo · 2 min
  • Data Lake Storage Set-upVideo · 5 min
  • Using Managed Identity - Grant access to Data LakeVideo · 4 min
  • Using Managed Identity - Create Data Factory PipelineVideo · 7 min
  • Using Managed Identity - Release Pipeline changesVideo · 7 min
  • Using Access Keys - Solution Options OverviewVideo · 3 min
  • Using Access Keys - Key Vault Set-upVideo · 6 min
  • Using Access Keys - Create Data Factory PipelineVideo · 7 min
  • Using Access Keys - Release Pipeline ChangesVideo · 6 min
UNIDAD 17 - Conclusion · 2 lecciones

UNIDAD 17 - Conclusion

  • Congratulations & Good LuckVideo · 1 min
  • Bonus LectureLectura · 0 min
Certificado oficial

Tu certificado lo emite la SEP, no solo una plataforma

Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.

Tu certificado con INEC

  • Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
  • Documento oficial con folio verificable en línea
  • Lo otorga la Universidad Tecnológica Fidel Velázquez

Otras plataformas en línea

  • Constancia privada emitida por la misma plataforma
  • Solo acredita horas cursadas o asistencia
  • Sin respaldo de una autoridad educativa
Cómo funciona

Tu itinerario, de la inscripción al certificado

  1. 1

    Inscripción con pago único

    Pagas $2,800 MXN una sola vez y entras de inmediato al curso.

  2. 2

    Estudias a tu ritmo

    17 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.

  3. 3

    Cuestionarios por unidad

    1 cuestionarios para comprobar lo aprendido.

  4. 4

    Certificado

    Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.

Lo que obtienes

Un certificado oficial de la SEP

Muestra del certificado: Project on Covid19

Muestra · verificable por folio y QR

  • Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
  • Contenido impartido por Ramesh Retnasamy . 200,000+ Learners.
  • Folio y QR verificables para compartirlo con quien te contrate.
Medios que necesitas
Equipo de cómputo Conexión estable a internet
Pago único

Empieza hoy, a tu ritmo

Un solo pago y acceso inmediato al curso completo durante 12 meses.

  • 17 unidades · 146 lecciones · 60 h
  • 12 meses de acceso
  • 1 cuestionarios de evaluación
  • Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Pago único
$2,800MXN
Acceso por 12 meses
Inscribirme Hablar con un asesor
Preguntas frecuentes

Sobre tu inscripción

¿Cómo es el pago?

Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.

¿Cuánto tiempo tengo acceso?

12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.

¿Quién imparte el contenido?

El curso es impartido por Ramesh Retnasamy . 200,000+ Learners; INEC gestiona tu inscripción, evaluación y certificado.

¿Qué pasa cuando vence mi acceso?

Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.

Certificado emitido por la SEP a través del Gobierno del Estado de México · Project on Covid19

Inscribirme
  INEC es una Marca de SalesPartners Ciudad de México S de RL de CV. Template Design © Learnify LMS. All rights reserved. Terminos y Condiciones Aviso de Privacidad Politica de Devolución
Hide picture