Implementing a Data Analytics Solution with Azure Synapse Analytics (DP-3012)

Course 8688

Duration: 1 day
Language: English
Level: Intermediate

This single-day instructor-led course, Implementing a Data Analytics Solution with Azure Synapse Analytics (DP-3012), offers comprehensive instruction on SQL dedicated and serverless Spark pools, focusing on data wrangling and the ELT process using Synapse Pipelines. Comparable to Azure Data Factory (ADF), learners gain hands-on experience moving data into Synapse dedicated pool databases.

Implementing a Data Analytics Solution with Azure Synapse Analytics (DP-3012) Delivery Methods

In-Person
Online
Upskill your whole team by bringing Private Team Training to your facility.

Implementing a Data Analytics Solution with Azure Synapse Analytics (DP-3012) Training Information

In this course, you will learn how to:

Gain comprehensive instruction on SQL dedicated and serverless Spark pools.
Acquire practical knowledge in data wrangling and the ELT process using Synapse Pipelines
Learn to efficiently move data into Synapse dedicated pool databases.
Enhance skills in querying various file formats (CSV, JSON, Parquet) using serverless SQL pools.
Develop proficiency in analysing data with Apache Spark within Azure Synapse Analytics.
Understand the core features and capabilities of Delta Lake and learn to create, use, and query Delta Lake tables.
Master the design and implementation of a relational data warehouse schema, including loading and querying data using SQL.

Training Prerequisites

Familiarity with notebooks using diverse languages and a Spark engine
Experience with SQL, Python, and Azure tools such as Data Factory

Implementing a Data Analytics Solution with Azure Synapse Analytics (DP-3012) Training Outline

Introduction to Azure Synapse Analytics

Identifying business problems addressed by Azure Synapse Analytics
Describing core capabilities and determining when to use Azure Synapse Analytics

Lab: Exploring Azure Synapse Analytics

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

Identifying capabilities and use cases for serverless SQL pools
Querying CSV, JSON, and Parquet files
Creating external database objects

Lab: Querying files using a serverless SQL pool

Analyse Data with Apache Spark in Azure Synapse Analytics

Identifying core features and configuring a Spark pool
Running code to load, analyse, and visualise data

Lab: Analysing data with Spark

Use Delta Lake in Azure Synapse Analytics

Describing core features and capabilities of Delta Lake
Creating and using Delta Lake tables
Using Delta Lake tables for streaming data and querying from a Synapse Analytics SQL pool

Lab: Using Delta Lake in Azure Synapse Analytics

Analyse Data in a Relational Data Warehouse

Designing a schema for a relational data warehouse
Creating fact, dimension, and staging tables
Loading and querying data warehouse tables using SQL

Lab: Exploring a data warehouse

Get This Course £835

1-Day Instructor-Led Training
Hands-On Labs
Microsoft Official Content
After-Course Instructor Coaching Included
Available for Private Team Training

Include dates with afternoon start times

#8688

Guaranteed to Run - You can rest assured this class will not be canceled. Delivery format is subject to change – please call Customer Service if you have any questions.
Sep 10 9:00 AM - 4:30 PM BST

AnyWare
Sep 22 2:00 PM - 9:30 PM BST

AnyWare
Oct 20 2:00 PM - 9:30 PM BST

AnyWare
Nov 21 2:00 PM - 9:30 PM GMT

AnyWare
Dec 9 9:00 AM - 4:30 PM GMT

AnyWare
Dec 15 2:00 PM - 9:30 PM GMT

AnyWare
Jan 22 2:00 PM - 9:30 PM GMT

AnyWare
Feb 18 2:00 PM - 9:30 PM GMT

AnyWare
Mar 11 9:00 AM - 4:30 PM GMT

AnyWare
Mar 20 1:00 PM - 8:30 PM GMT

AnyWare
Jun 8 9:00 AM - 4:30 PM BST

AnyWare

Scroll to view additional course dates

Bring this or any training to your organisation
Full-scale programme development
Delivered when, where, and how you want it
Blended learning models
Tailored content
Expert team coaching

#8688

Speak with a Learning Consultant

Inquiring For

Myself

Team/Group

First Name*

Last Name*

Email*

Phone Number*

Company*

Job Title

I'm interested In

* Required Fields

Speak with a Learning Consultant

Fill out the form below or call 44 (0) 207 874 5000

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Implementing a Data Analytics Solution with Azure Synapse Analytics (DP-3012) FAQs

Familiarity with notebooks utilising various languages, a Spark engine, SQL, Python, and Azure tools such as Data Factory is recommended.

Learners will identify business problems addressed by Azure Synapse Analytics, describe its core capabilities, and determine when to utilise it.