DP-3012: Implementing a Data Analytics Solution with Azure Synapse Analytics DP-3012

This is a single day Instructor Lead Course designed to give the learners instruction on the SQL dedicated and serverless Spark pools and providing instruction of data wrangling and the ELT process using Synapse Pipelines which is very similar to those familiar with Azure Data Factory (ADF) to move data into the Synapse dedicated pool database.

Difficulty Level: Intermediate

Product: Azure, Microsoft Fabric

Role: Administrator, Data Engineer

DP-3012: Implementing a Data Analytics Solution with Azure Synapse Analytics DP-3012

Virtual Instructor Led Online Schedule

Duration

1 Days

Price

$995.00

Interested in group training?

Schedule Course Outline

This green checkmark in the Upcoming Schedule below indicates that this session is Guaranteed to Run.

Course Outline

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.

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

Use Azure Synapse serverless SQL pool to query files in a data lake
Use Azure Synapse serverless SQL pools to transform data in a data lake
Create a lake database in Azure Synapse Analytics
Secure data and manage users in Azure Synapse serverless SQL pools

Analyze data with Apache Spark in Azure Synapse Analytics
Transform data with 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
Manage and monitor data warehouse activities in Azure Synapse Analytics
Secure a data warehouse in Azure Synapse Analytics

Build a data pipeline in Azure Synapse Analytics
Use Spark Notebooks in an Azure Synapse Pipeline

Build a data pipeline in Azure Synapse Analytics
Use Spark Notebooks in an Azure Synapse Pipeline

Virtual Instructor Led Online Schedule

Duration

1 Days

Price

$995.00