Vinsys

Select Language

Select Country

ENQUIRE NOW

training

usa

Domain / Vendor

dp 3012 implementing data analytics solution with azure synapse certification

Expert-led Comprehensive Learnings Microsoft Certified Trainers [MCTs]

Official Microsoft Content Authorized Course Material

ILVT, Online & In-house Interactive Face-to-face Solutions

Schedule-flexible eLearning Self-paced Offerings

Overview Learning Objectives Who Should Attend Prerequisite Outline

Course Overview

MS Azure Synapse Analytics Course Overview

Microsoft Azure administrators deploy, administer, and manage
Azure solutions. On the other hand, Azure data engineers design,
implement and manage data solutions on the Azure platform.

The Implementing a Data Analytics Solution with Azure Synapse Analytics
training introduces you to various instructions on the SQL dedicated and
serverless Spark pools. In addition, it also brings instructions for data
wrangling and the ELT process using Synapse Pipelines, which is very similar
to those familiar with MS Azure Data Factory (ADF) to move data into the
Synapse dedicated pool database.

Course Objectives

To Get Introduced to MS Azure Synapse Analytics.
Utilize 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.

Audience

Microsoft Azure Administrators & Data Engineers.

Eligibility Criteria

Familiarity with notebooks that use different languages and a Spark engine like Databricks, Jupyter Notebooks or Zeppelin notebooks.
Reasonable experience with SQL, Python and Azure tools, such as Data Factory

Course Outline

Microsoft Azure Synapse Analytics Introduction

Identifying the business problems that Azure Synapse Analytics addresses.
Describing core capabilities of Azure Synapse Analytics.
Determining when to use Azure Synapse Analytics.

Utilizing Azure Synapse Serverless SQL Pool to Query Files in a Data Lake

Identifying capabilities and use cases for serverless SQL pools in Azure Synapse Analytics.
Querying CSV, JSON, and Parquet files using a serverless SQL pool.
Creating external database objects in a serverless SQL pool.

Analyzing Data with Apache Spark in Azure Synapse Analytics

Identifying core features/capabilities of Apache Spark.
Configuring a Spark pool in Azure Synapse Analytics.
Running code to load, analyze, and visualize data in a Spark notebook.

Using Delta Lake in Azure Synapse Analytics

Describing core features and capabilities of Delta Lake.
Creating and using Delta Lake tables in a Synapse Analytics Spark pool.
Creating Spark catalog tables for Delta Lake data.
Using Delta Lake tables for streaming data.
Querying Delta Lake tables from a Synapse Analytics SQL pool.

Analyzing Data in a Relational Data Warehouse

Designing a schema for a relational data warehouse.
Creating fact, dimension, and staging tables.
Using SQL to load data into data warehouse tables.
Using SQL to query relational data warehouse tables.

Building a Data Pipeline in Azure Synapse Analytics

Describing core concepts for Azure Synapse Analytics pipelines.
Creating a pipeline in Azure Synapse Studio.
Implementing a data flow activity in a pipeline.
Initiating and monitoring pipeline runs

Choose Your Preferred Mode

FAQ’s

Why is Microsoft Azure Synapse Analytics often described as a new class of data analytics?

It is the enterprise analytics service that is beneficial for accelerating time to insight across data warehouses and big data systems. It combines the best SQL technologies used in enterprise data warehousing, Apache Spark technologies for big data, and Azure Data Explorer for log and time series analytics.

May I attend the training without completing my Microsoft Azure Fundamentals course?

Yes, you can. There is no mandatory prerequisite.

What's the hourly duration of DP-3012 training?

Approx. 8 hours.

Does DP-3012 training provide approved courseware?

Yes, you will get access to the Microsoft Official Courseware (MOC)

Is there an option to customize the DP-3012 training and choose my desired learning time slots?

You may opt for any of our highly customizable, blended and time-flexible ILVT, online, in-house, interactive face-to-face, eLearning or self-paced solutions.