Model, query, and explore data in Azure Synapse
Offered By: Microsoft via Microsoft Learn
Course Description
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: 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
Tags
Related Courses
Building Cloud Apps with Microsoft Azure - Part 1 (self-paced)Microsoft via edX Building Cloud Apps with Microsoft Azure - Part 3
Microsoft via edX DEV202.2x: Building Cloud Apps with Microsoft Azure – Part 2
Microsoft via edX Architecting Microsoft Azure Solutions
Microsoft via edX Implementing Predictive Analytics with Spark in Azure HDInsight
Microsoft via edX