Course Description

This course equips learners with skills to design and implement data solutions using Microsoft Azure. It covers data storage, transformation, integration, and analytics using services like Azure Data Factory, Synapse Analytics, and Databricks. Ideal for roles like data engineers, ETL developers, and cloud data professionals.

Why should I join?

Azure Data Engineering course is a powerful way to jumpstart or boost your career in the fast-growing field of cloud data engineering, Azure data solutions are used in healthcare, finance, retail, government, and more. Skills you learn are transferable across multiple sectors.

Gain knowledge of cloud infrastructure along with data engineering.  This combined skillset is highly valuable for digital transformation projects.Get ready for the Microsoft Certified: Azure Data Engineer Associate certification. Certification boosts your credibility and opens job opportunities globally.

Course Content

Module 1: Introduction to Tableau
5 Topics
What is Data Engineering?
Azure ecosystem overview
Role of a Data Engineer in cloud projects
Azure Data Engineer vs. Data Scientist vs. Data Analyst
Azure certifications overview (focus on DP-203)
Module 2: Azure Storage Fundamentals
5 Topics
Azure Blob Storage
Azure Data Lake Storage Gen2
Storage account types and performance tiers
Secure data access with Shared Access Signatures (SAS) and Azure AD
Lifecycle and tiering policies
Module 3: Data Ingestion with Azure Data Factory (ADF)
6 Topics
Introduction to Azure Data Factory
Creating pipelines and datasets
Linked services and triggers
Copy activity and data movement
Monitoring and debugging pipelines
Integration Runtime (Self-hosted vs Azure-hosted)
Module 4: Data Processing with Azure Synapse Analytics
5 Topics
Overview of Synapse Studio
Serverless SQL pools vs Dedicated SQL pools
Writing queries in Synapse SQL
Integrating ADF pipelines with Synapse
Data exploration with Synapse notebooks
Module 5: Data Processing with Azure Databricks
6 Topics
Introduction to Azure Databricks
Apache Spark fundamentals
Notebooks and clusters
ETL using PySpark
Delta Lake architecture
Working with structured streaming
Module 6: Real-Time Data with Azure Stream Analytics
4 Topics
Introduction to real-time processing
Streaming inputs and outputs
Writing Stream Analytics queries
Integrating with Event Hubs & IoT Hub
Module 7: Data Transformation and Orchestration
4 Topics
Data wrangling and data flows in ADF
Mapping vs. Wrangling Data Flows
Parameterization in pipelines
Custom activities using Azure Functions
Module 8: Azure SQL & NoSQL Databases
4 Topics
Azure SQL Database and Managed Instances
Azure Cosmos DB (Core API, SQL API)
Performance tuning and indexing
Data import/export tools
Module 9: Monitoring, Logging, and Security
5 Topics
Monitoring data pipelines (ADF & Synapse)
Azure Monitor, Log Analytics, and Application Insights
Managing identity with Azure AD
Role-Based Access Control (RBAC)
Key Vault for securing credentials
Module 10: Data Governance & Compliance
4 Topics
Introduction to Microsoft Preview
Data cataloging and classification
Lineage and auditing
Data masking and encryption options
Module 11: Capstone Project
2 Topics
Includes
11 Lessons
50 Topics