In this course, the student will learn about the data engineering patterns and practices as it pertains to working with batch and real-time analytical solutions using Azure data platform technologies.
Course Objectives:
Explore compute and storage options for data engineering workloads in Azure, Design and Implement the serving layer, Understand data engineering considerations, Run interactive queries using serverless SQL pools, Explore, transform, and load data into the Data Warehouse using Apache Spark, Perform data Exploration and Transformation in Azure Databricks, Ingest and load Data into the Data Warehouse, Transform Data with Azure Data Factory or Azure Synapse Pipelines, Integrate Data from Notebooks with Azure Data Factory or Azure Synapse Pipelines, Optimize Query Performance with Dedicated SQL Pools in Azure Synapse, Analyze and Optimize Data Warehouse Storage, Support Hybrid Transactional Analytical Processing (HTAP) with Azure Synapse Link, Perform end-to-end security with Azure Synapse Analytics, Perform real-time Stream Processing with Stream Analytics, Create a Stream Processing Solution with Event Hubs and Azure Databricks, Build reports using Power BI integration with Azure Synpase Analytics,Perform Integrated Machine Learning Processes in Azure Synapse Analytics