- 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:
Overview
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: 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