Cart 0

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

Course Outline

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) Benefits

  • 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 analyzing 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 

Analyze Data with Apache Spark in Azure Synapse Analytics 

  • Identifying core features and configuring a Spark pool 
  • Running code to load, analyze, and visualize data 

Lab: Analyzing 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 

Analyze 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 

Course Dates - North America
Course Dates - Europe
Attendance Method
Additional Details (optional)