Model query and explore data in Azure Synapse
- Offered byMicrosoft
Model query and explore data in Azure Synapse at Microsoft Overview
Duration | 5 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Model query and explore data in Azure Synapse 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
- Analyze data in a relational data warehouse
- You'll learn how to query and visualize data in a data lake and a data warehouse
- This learning path helps you prepare for the Azure Enterprise Data Analyst Certification
- This learning path helps prepare you for Exam DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
- Learn about the features and capabilities of Azure Synapse Analytics - a cloud-based platform for big data processing and analysis
- With Azure Synapse serverless SQL pool, you can leverage your SQL skills to explore and analyze data in files, without the need to load the data into a relational database
Model query and explore data in Azure Synapse 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
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
Model query and explore data in Azure Synapse at Microsoft Entry Requirements
- You should have experience using Azure data services. If you have no previous Azure data experience, we recommend you complete the Azure Data Fundamentals: Explore core data concepts learning path before starting this one.
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?