Implement a Data Analytics Solution with Azure Synapse Analytics

Overview

Module 1: Introduction to Azure Synapse Analytics
In this module, you'll learn how to:
- Identify the business problems that Azure Synapse Analytics addresses.
- Describe core capabilities of Azure Synapse Analytics.
- Determine when to use Azure Synapse Analytics.
Module 2: Use Azure Synapse serverless SQL pool to query files in a data lake
After the completion of this module, you will be able to:
- Identify capabilities and use cases for serverless SQL pools in Azure Synapse Analytics
- Query CSV, JSON, and Parquet files using a serverless SQL pool
- Create external database objects in a serverless SQL pool
Module 3:

Syllabus

Module 1: Module 1: Introduction to Azure Synapse Analytics
- Introduction
- What is Azure Synapse Analytics
- How Azure Synapse Analytics works
- When to use Azure Synapse Analytics
- Exercise - Explore Azure Synapse Analytics
- Knowledge check
- Summary
Module 2: Module 2: Use Azure Synapse serverless SQL pool to query files in a data lake
- Introduction
- Understand Azure Synapse serverless SQL pool capabilities and use cases
- Query files using a serverless SQL pool
- Create external database objects
- Exercise - Query files using a serverless SQL pool
- Knowledge check
- Summary
Module 3: Module 3: Analyze data with Apache Spark in Azure Synapse Analytics
- Introduction
- Get to know Apache Spark
- Use Spark in Azure Synapse Analytics
- Analyze data with Spark
- Visualize data with Spark
- Exercise - Analyze data with Spark
- Knowledge check
- Summary
Module 4: Module 4: Use Delta Lake in Azure Synapse Analytics
- Introduction
- Understand Delta Lake
- Create Delta Lake tables
- Create catalog tables
- Use Delta Lake with streaming data
- Use Delta Lake in a SQL pool
- Exercise - Use Delta Lake in Azure Synapse Analytics
- Knowledge check
- Summary
Module 5: Module 5: Analyze data in a relational data warehouse
- Introduction
- Design a data warehouse schema
- Create data warehouse tables
- Load data warehouse tables
- Query a data warehouse
- Exercise - Explore a data warehouse
- Knowledge check
- Summary
Module 6: Module 6: Build a data pipeline in Azure Synapse Analytics
- Introduction
- Understand pipelines in Azure Synapse Analytics
- Create a pipeline in Azure Synapse Studio
- Define data flows
- Run a pipeline
- Exercise - Build a data pipeline in Azure Synapse Analytics
- Knowledge check
- Summary