1-Day Instructor-Led Training
Hands-On Labs
Microsoft Official Content
After-Course Instructor Coaching Included
Available for Private Team Training
#8688
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
Speak with a Learning Consultant
Speak with a Learning Consultant
Fill out the form below or call 888-843-8733
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 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.