Implementing a Data Analytics Solution with Azure Synapse Analytics

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

Course Length: 1 day
Delivery Methods: Multiple delivery options
Course Overview

This course provides an in-depth exploration of Azure Synapse Analytics, a powerful integrated analytics service that brings together big data and data warehousing. Participants will gain a comprehensive understanding of how to leverage Azure Synapse Analytics for various data processing and analysis tasks, including querying data in a data lake with serverless SQL pools, analyzing data with Apache Spark, and using Delta Lake for handling streaming and batch data. The course also covers designing and querying data warehouses and building data pipelines within Azure Synapse Analytics, enabling participants to efficiently manage and analyze large volumes of data. By the end of the course, learners will have the skills needed to implement and optimize data solutions using Azure Synapse Analytics, driving better decision-making and insights within their organizations.

Course Benefits
  • Gain a deep understanding of Azure Synapse Analytics and its key components.
  • Learn how to query data in a data lake using Azure Synapse serverless SQL pools.
  • Develop skills in using Apache Spark within Azure Synapse for data analysis and visualization.
  • Understand the benefits and applications of Delta Lake in managing streaming and batch data.
  • Master the design and implementation of relational data warehouses in Azure Synapse.
  • Build and manage data pipelines within Azure Synapse Studio to automate data processing tasks.
  • Enhance your ability to handle big data and data warehousing tasks efficiently in a cloud environment.
Available Delivery Methods
Public Class
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private Class
Private classes are delivered for groups at your offices or a location of your choice.
Microsoft Certified Partner

Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Course Outline
  1. Introduction to Azure Synapse Analytics
    1. What is Azure Synapse Analytics
    2. How Azure Synapse Analytics works
    3. When to use Azure Synapse Analytics
  2. Use Azure Synapse serverless SQL pool to query files in a data lake
    1. Understand Azure Synapse serverless SQL pool capabilities and use cases
    2. Query files using a serverless SQL pool
    3. Create external database objects
  3. Analyze data with Apache Spark in Azure Synapse Analytics
    1. Get to know Apache Spark
    2. Use Spark in Azure Synapse Analytics
    3. Analyze data with Spark
    4. Visualize data with Spark
  4. Use Delta Lake in Azure Synapse Analytics
    1. Understand Delta Lake
    2. Create Delta Lake tables
    3. Create catalog tables
    4. Use Delta Lake with streaming data
    5. Use Delta Lake in a SQL pool
  5. Analyze data in a relational data warehouse
    1. Design a data warehouse schema
    2. Create data warehouse tables
    3. Load data warehouse tables
    4. Query a data warehouse
  6. Build a data pipeline in Azure Synapse Analytics
    1. Understand pipelines in Azure Synapse Analytics
    2. Create a pipeline in Azure Synapse Studio
    3. Define data flows
    4. Run a pipeline
Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Live Public Class
$681.10 / student
Please select a class.
Live Private Class
  • Private Class for your Team
  • Live training
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Proposal