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
Bases de Datos SQL en AzureCoursera Project Network via Coursera Microsoft Future Ready: Azure Cloud Fundamentals
Cloudswyft via FutureLearn Crea un app de Machine Learning con Spark, Synapse Analytics
Coursera Project Network via Coursera Microsoft Azure Synapse for Developers
LinkedIn Learning Azure Synapse Analytics: desde el DWH, hasta PowerBI y Spark
Coursera Project Network via Coursera