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

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

Lab: Exploring Azure Synapse Analytics 

  • 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 

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

Lab: Analysing data with Spark 

  • 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 

  • 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 

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.