Module 1: Introduction to Azure Data Lake Storage Gen2

• Under Azure Data Lake Storage Gen2
• Enable Azure Data Lake Storage Gen2 in Azure Storage
• Compare Azure Data Lake Storage to Azure Blob Storage

Module 2: Introduction to Azure Synapse Analytics

• What is Azure Synapse Analytics
• How Azure synapse Analytics Works
• When to Use Azure Synapse Analytics

Module 3: Use Azure Synapse Serverless SQL Pool to Query Files in a Data Lake

• Understand Azure Synapse Serverless SQL Pool Capabilities and Use Cases
• Query Files Using a Serverless SQL Pool
• Create External Database Objects

Module 4: Use Azure Synapse Serverless SQL Pools to Transform Data in a Data Lake

• Transform Data files with the CREATE EXTERNAL TABLE AS SELECT Statement
• Encapsulate Data Transformations in a Stored Procedure
• Include a Data Transformation Stored procedure in a Pipeline

Module 5: Create a Lake Database in Azure Synapse Analytics

• Understand Lake Database concepts
• Explore Database Template
• Create a Lake Database
• Use a Lake Database

Module 6: Analyze Data with Apache Spark in Azure Synapse Analytics

• Get to Know Apache Spark
• Use Spark in Azure Synapse Analytics
• Analyze Data with Spark
• Visualize Data with Spark

Module 7: Transform Data with Spark in Azure Synapse Analytics

• Modify and Save Dataframes
• Partition Data Files
• Transform Data with SQL

Module 8: Use Delta Lake in Azure Synapse Analytics

• Understand Delta Lake
• Create Delta Lake Tables
• Create Catalog Tables
• Use Delta Lake with Streaming Data
• Use Delta Lake in a SQL Pool

Module 9: Analyze Data in a Relational Data Warehouse

• Design a Data Warehouse Schema
• Create Data Warehouse Tables
• Load Data Warehouse Tables
• Query a Data Warehouse

Module 10: Load Data into a Relational Database Warehouse

• Load Staging Tables
• Load Dimension Tables
• Load Time Dimension Tables
• Load Slowly Changing Dimensions
• Load Fact Tables
• Perform Post Load Optimization

Module 11: Build a data Pipeline in Azure Synapse Analytics

• Understand Pipelines in Azure Synapse Analytics
• Create a Pipeline in Azure Synapse Studio
• Define Data Flows
• Run a Pipeline

Module 12: Use Spark Notebooks in an Azure synapse Pipeline

• Understand Synapse Notebooks and Pipelines
• Use a Synapse Notebook Activity in a Pipeline
• Use Parameters in a Notebook

Module 13: Plan Hybrid Transactional and Analytical Processing Using Azure Synapse Analytics

• Understand Hybrid Transactional and Analytical Processing Patterns

Module 14: Implement Azure Synapse Link with Azure Cosmos DB

• Enable Cosmos DB Account to Use Azure Synapse Link
• Create a Linked Service for Cosmos DB
• Query Cosmos DB Data with Spark
• Query Cosmos DB with Synapse SQL

Module 15: Implement Azure Synapse Link for SQL

• What is Azure Synapse Link for SQL
• Configure Azure Synapse Linke for Azure SQL Database
• Configure Azure Synapse Link for SQL Server 2022

Module 16: Get Started with Azure Stream Analytics

• Understand Data Streams
• Understand Event Processing
• Understand Window Functions

Module 17: Ingest Streaming Data Using Azure Stream Analytics and Azure Synapse Analytics

• Stream Ingestion Scenarios
• Configure Inputs and Outputs
• Define a Query to Select, Filter, and Aggregate Data
• Run a Job to Ingest Data

Module 18: Visualize Real-Time Data with Azure Stream Analytics and Power BI

• Use a Power BI Output in Azure Stream Analytics
• Create a Query for Real-Time Visualization
• Create Real-Time Data Visualizations in Power BI

Module 19: Introduction to Microsoft Purview

• What is Microsoft Purview
• How Microsoft Purview Works
• When to Use Microsoft Purview

Module 20: Integrate Microsoft Purview and Azure Synapse Analytics

• Catalog Azure Synapse Analytics Data Assets in Microsoft Purview
• Connect Microsoft Purview to and Azure Synapse Analytics Workspace
• Search a Purview Catalog in Synapse Studio
• Track Data Lineage in Pipelines

Module 21: Explore Azure Databricks

• Get started with Azure Databricks
• Identify Azure Databricks Workloads
• Understand Key Concepts

Module 22: Use Apache Spark in Azure Databricks

• Get to Know Spark
• Create a Spark Cluster
• Use Spark in Notebooks
• Use Spark to Work with Data Files
• Visualize Data

Module 23: Run Azure Databricks Notebooks with Azure Data Factory

• Understand Azure Databricks Notebooks and Pipelines
• Create a Linked Service for Azure Databricks
• Use a Notebook Activity in a Pipeline
• Use Parameters in a Notebook