US flag US
888-843-8733
888-843-8733

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

  • 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, analyze, and visualize data 

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

Get This Course $895 GOV $620 For Team Prices Call: 888-843-8733

  • 1-Day Instructor-Led Training

  • Hands-On Labs

  • Microsoft Official Content

  • After-Course Instructor Coaching Included

  • Available for Private Team Training

#8688
  • Aug 25 9:00 AM - 4:30 PM EDT
    AnyWare
  • Sep 22 9:00 AM - 4:30 PM EDT
    AnyWare
  • Oct 20 9:00 AM - 4:30 PM EDT
    AnyWare
  • Nov 21 9:00 AM - 4:30 PM EST
    AnyWare
  • Dec 15 9:00 AM - 4:30 PM EST
    AnyWare
  • Jan 22 9:00 AM - 4:30 PM EST
    AnyWare
  • Feb 18 9:00 AM - 4:30 PM EST
    AnyWare
  • Mar 20 9:00 AM - 4:30 PM EDT
    AnyWare

Scroll to view additional course dates

  • 1-Day Instructor-Led Training

  • Hands-On Labs

  • Microsoft Official Content

  • After-Course Instructor Coaching Included

  • Available for Private Team Training

#8688
  • Aug 25 9:00 AM - 4:30 PM EDT
    AnyWare
  • Sep 22 9:00 AM - 4:30 PM EDT
    AnyWare
  • Oct 20 9:00 AM - 4:30 PM EDT
    AnyWare
  • Nov 21 9:00 AM - 4:30 PM EST
    AnyWare
  • Dec 15 9:00 AM - 4:30 PM EST
    AnyWare
  • Jan 22 9:00 AM - 4:30 PM EST
    AnyWare
  • Feb 18 9:00 AM - 4:30 PM EST
    AnyWare
  • Mar 20 9:00 AM - 4:30 PM EDT
    AnyWare

Scroll to view additional course dates

  • Bring this or any training to your organization

  • Full-scale program development

  • Delivered when, where, and how you want it

  • Blended learning models

  • Tailored content

  • Expert team coaching

#8688
Questions about this course?
* Required Fields
Customize Your Team Training Experience

Fill out the form below or call 888-843-8733

* Required Fields

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Contact Us

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

Familiarity with notebooks utilizing 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 utilize it. 

Related Courses

  • Learning Tree
    Azure Data Factory Training: Designing and Implementing Data Integration Solutions

    Design and implement data integration solutions with Azure Data Factory. Master the skills to efficiently manage and transform data.

    Intermediate
    3 days
    Online or In-class
    Starts from $2,785
  • Microsoft
    Data Engineering on Microsoft Azure (DP-203)

    In the (DP-203) Azure Data Engineering training course, students will learn about data engineering as it pertains to working with batch and real-time analytical solutions.

    Intermediate
    4 days
    Online or In-class
    Starts from $3,140
  • Microsoft
    Introduction to Microsoft Azure (AZ-900)

    Learning Tree's Azure Fundamentals training provides foundational level knowledge on cloud concepts, core Azure services, and Azure management.

    Foundation
    1 day
    Online or In-class
    Starts from $895
  • Microsoft
    Microsoft Azure Data Fundamentals Training (DP-900)

    In the Microsoft Azure Data Fundamentals Training DP-900 course, you'll learn the fundamentals of database concepts and build foundational knowledge.

    Foundation
    1 day
    Online or In-class
    Starts from $895
Chat With Us