Implement a Data Analytics Solution with Azure Synapse Analytics
- Offered byMicrosoft
Implement a Data Analytics Solution with Azure Synapse Analytics at Microsoft Overview
Duration | 2 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Implement a Data Analytics Solution with Azure Synapse Analytics at Microsoft Highlights
- Earn a certificate after completion of the course
Implement a Data Analytics Solution with Azure Synapse Analytics at Microsoft Course details
- Introduction to Azure Synapse Analytics
- Use Azure Synapse serverless SQL pool to query files in a data lake
- Analyze data with Apache Spark in Azure Synapse Analytics
- Use Delta Lake in Azure Synapse Analytics
- Analyze data in a relational data warehouse
- Build a data pipeline in Azure Synapse Analytics
- Prerequisites
- The Audience should have familiarity with notebooks that use different languages and a Spark engine, such as Databricks, Jupyter Notebooks, Zeppelin notebooks and more. They should also have some experience with SQL, Python, and Azure tools, such as Data Factory.
- Save
- Achievement Code
- Would you like to request an achievement code?
- Request achievement code
Implement a Data Analytics Solution with Azure Synapse Analytics at Microsoft Curriculum
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
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
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
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
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
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
Implement a Data Analytics Solution with Azure Synapse Analytics at Microsoft Entry Requirements
- The Audience should have familiarity with notebooks that use different languages and a Spark engine, such as Databricks, Jupyter Notebooks, Zeppelin notebooks and more. They should also have some experience with SQL, Python, and Azure tools, such as Data Factory
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?
ManagementBusiness AnalyticsData AnalysisImplement a Data Analytics Solution with Azure Synapse Analytics