Implement a Data Analytics Solution with Azure Synapse Analytics

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.
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

Syllabus

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
- Module assessment
- Summary
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
- Module assessment
- Summary
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
- Module assessment
- Summary
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
- Module assessment
- Summary
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
- Module assessment
- Summary
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
- Module assessment
- Summary