Cart 0

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

Price:
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
Attendance Method
Additional Details (optional)

Private Team Training

Interested in this course for your team? Please complete and submit the form below and we will contact you to discuss your needs and budget.