Build a Data Mesh using Azure-Hands on, real-world scenario

Azure Synapse Analytics-Data Ingestion, Transformation; Analysis; Entra ID; Azure RBAC; Azure Data Lake Storage gen V2

Ratings 4.25 / 5.00
Build a Data Mesh using Azure-Hands on, real-world scenario

What You Will Learn!

  • Data Mesh Principles ; Apply Domain Driven Design; Create Azure free account & Subscription
  • Microsoft Entra Id previously Azure Active Directory- Create users& groups
  • Create Azure Data Lake storage gen v2, Understand Azure RBAC, Assign built in roles, Azure network security features and Encryption overview
  • Azure synapse analytics for Data Ingestion and Transformation-pipeline, dataflow, CETAS, linked service, copy data tool, expressions, and activities
  • Azure synapse analytics for Data Ingestion and Transformation using Spark Pools using data frame
  • Azure synapse analytics Data Analysis - Use Spark & SQL, understand OPENROWSET to query files, understand using data types in OPENROWSET, column referencing
  • Azure synapse analytics Data Analysis - query subset of data, use collation, create database, create external data source, create external table and view
  • Cross domain data analysis, practically understand no data silos exists in a data mesh

Description

In this course, I will practically show you how to build a Data Mesh using Microsoft’s cloud computing platform Azure. By the end of the course, you would have gained a solid understanding of Azure Synapse analytics, and how it can be used for data ingestion, transformation, and analysis. I will give you an overview of all the Hubs in Azure Synapse and show you how to use Serverless SQL Pools and Spark Pools. You will understand the OPENROWSET function, explicit data types, collation, database, external data source, linked service, built-in copy data tool, CETAS, pipelines, activities, dataflows, external table, and view. I will show how to perform data analysis using Spark and SQL.  You will understand what data mesh is and its principles, and how it can be applied in a real-world scenario. You will learn about the importance of data domains.  You will learn about azure data lake storage gen v2. You will learn about how to assign built-in roles in Azure.

Furthermore, you would have explored the role of domain-driven design in creating a modular scalable data infrastructure. Data Mesh emphasizes the decentralization of data management, allowing teams to own their data and avoid dependencies on a central data team, you will learn about using Azure to create decentralized teams, in the Microsoft Entra Id previously Azure active directory we will create users and groups for the decentralized teams. Then we will build the data domains using the domain-specific teams. The principles of data mesh can help you build more robust and scalable data systems that meet your organization's needs. Whether you are a data engineer or a data scientist or a data analyst or a business analyst or whichever role in IT, at the end of this course you will understand how with the new Data Mesh architecture in place, the company can build data-driven products without any data silos.

Who Should Attend!

  • Anyone interested to understand data mesh, domain driven design and application of data mesh to a real world scenario in cloud
  • Anyone interested in learning azure synapse analytics, and azure RBAC
  • University students, Data Engineers, Data Analyst , Data scientist
  • Project Managers, Project Sponsors who are involved in projects related to Azure Synapse Analytics
  • Business Analyst, Product owners, Product managers who are involved in designing Data Mesh and/or Azure synapse projects
  • You will learn some topics that cover DP203, however this course is not designed for just certification of DP203

TAKE THIS COURSE

Tags

  • Azure Synapse Analytics

Subscribers

127

Lectures

65

TAKE THIS COURSE



Related Courses