Implementing Data Analytics with Synapse (DP-3012)
Description
In this single-day course "Implementing a Data Analytics Solution with Azure Synapse Analytics" (DP-3012), you will learn how to use Azure Synapse for your Data Processing and Analytics.
You will learn:
- How Synapse works
- How you can use Serverless SQL pools to query files in your data lake
- How to analyze data in Spark
- How to use Delta Lake
- Work with Dedicated SQL Pools for your relational data warehouse
- How to build data pipelines in Azure Synapse Analytics
The primary audience for this course are Data Engineers who want to learn how to use Synapse for your data processing needs.
Secondary audiences are Solution Architects and Administrators who want to learn how to design solutions using Azure Synapse.
After completing this course, you will be able to:
- Identify the business problems that Azure Synapse Analytics addresses.
- Describe core capabilities of Azure Synapse Analytics.
- Determine when to use Azure Synapse Analytics.
- 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
- Identify core features and capabilities of Apache Spark.
- Configure a Spark pool in Azure Synapse Analytics.
- Run code to load, analyze, and visualize data in a Spark notebook.
- Describe core features and capabilities of Delta Lake.
- Create and use Delta Lake tables in a Synapse Analytics Spark pool.
- Create Spark catalog tables for Delta Lake data.
- Use Delta Lake tables for streaming data.
- Query Delta Lake tables from a Synapse Analytics SQL pool.
- Design a schema for a relational data warehouse.
- Create fact, dimension, and staging tables.
- Use SQL to load data into data warehouse tables.
- Use SQL to query relational data warehouse tables.
- Describe core concepts for Azure Synapse Analytics pipelines.
- Create a pipeline in Azure Synapse Studio.
- Implement a data flow activity in a pipeline.
- Initiate and monitor pipeline runs.
Prerequisites
As this is a single-day course, it is important to notice that this is not a beginner's course. You should already have familiarity with:
- Notebooks (such as Databricks, Jupyter, or Zeppelin)
- SQL
- Python
- Azure tools
Course outline
- Introduction to Azure Synapse Analytics
- Use a 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
- Load data into a relational data warehouse
- Build a data pipeline in Azure Synapse Analytics
Course material
In the course "Implementing a Data Analytics Solution with Azure Synapse Analytics" (DP-3012) we use Microsoft Official Courseware. We will ensure that you receive this (digital) material at the start of the course.
Available dates
| Title | Date |
|---|---|
| DP-3012 |
| Title | Date |
|---|---|
| DP-3012 |
