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

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