Facebook-f Instagram Linkedin

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

  • Course Code : IDA002
  • Duration : 1 Day
  • Price : 706 GBP
  • Level: Intermediate
  • Language: English

Course Content

  • This single-day instructor-led course provides an in-depth exploration of Azure Synapse Analytics, focusing on SQL dedicated pools and serverless Spark pools. Participants will gain hands-on experience with data wrangling, the ELT process using Synapse Pipelines, and efficiently moving data into Synapse dedicated pool databases. The course also covers querying diverse file formats, leveraging Apache Spark for analysis, and utilizing Delta Lake within Synapse Analytics.

Delivery Method

  • In-Person
  • Online
  • Private Team Training: Customized sessions delivered at your facility.

Have questions about this course?


Goals

    • By the end of this course, you will:

      • Understand the capabilities of SQL dedicated pools and serverless Spark pools in Azure Synapse Analytics.
      • Gain practical experience in data wrangling and executing ELT processes with Synapse Pipelines.
      • Learn how to efficiently move data into Synapse dedicated pool databases.
      • Query files in formats such as CSV, JSON, and Parquet using serverless SQL pools.
      • Analyze data using Apache Spark within Azure Synapse Analytics.
      • Explore and utilize Delta Lake features, including table creation and querying.
      • Design and implement a relational data warehouse schema, loading and querying data using SQL.

Pre Requisites

    • Participants should have:

      • Familiarity with notebooks and a Spark engine using diverse languages.
      • Experience with SQL, Python, and Azure tools like Data Factory.

Course Outline

Module 1: Introduction to Azure Synapse Analytics
    • Understand business problems solved by Azure Synapse Analytics.
    • Explore the core capabilities and determine when to use Azure Synapse Analytics.
    • Lab: Explore Azure Synapse Analytics.
    • Identify the capabilities and use cases for serverless SQL pools.
    • Query data files in formats such as CSV, JSON, and Parquet.
    • Create external database objects for querying data.
    • Lab: Query files using a serverless SQL pool.
    • Configure and utilize a Spark pool in Azure Synapse Analytics.
    • Load, analyze, and visualize data using Apache Spark.
    • Lab: Analyze data with Spark in Azure Synapse Analytics.
    • Explore the features and capabilities of Delta Lake.
    • Create and query Delta Lake tables for both streaming and batch data.
    • Integrate Delta Lake tables with Synapse Analytics SQL pools.
    • Lab: Work with Delta Lake in Azure Synapse Analytics.
    • Design schemas for relational data warehouses, including fact, dimension, and staging tables.
    • Load and query data warehouse tables using SQL.
    • Lab: Explore and analyze data in a data warehouse.

Struggling to Choose the Perfect Training Solution? We've Got You Covered!

Our Training Advisors Are Ready to Guide You!

Contact US

News and Insights

SAP Technical Overviews
November 18, 2024

SAP Analysis for Microsoft Office BOAN10

Read More
SAP Technical Overviews
November 18, 2024

SAP Integration Technology – Interfaces I (BAPI / IDoc) BIT101

Read More
SAP Technical Overviews
November 18, 2024

Introduction to SAP Business Technology Platform (BTP) Administration ADMCLD

Read More

What you should know for our service

Common Questions and Answers

Discover answers to frequently asked questions about our digital agency services. Learn more about our offerings, processes, and how we can support your digital marketing needs.

Our digital agency offers a comprehensive range of services designed to enhance your online presence and drive business growth. 

Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts. Separated they live in Bookmarksgrove right at the coast

We measure the success of our digital marketing campaigns using various key performance indicators (KPIs) and analytics tools.

Join thousands of professionals upgrading their SAP skills through our flexible virtual and in-classroom training. We guide you to stay certified and competitive in today’s SAP-driven world.

Solutions

Ford Rose

Policies

Social Media

Facebook-f X-twitter Instagram

Copyright © 2024 Ford Rose | All Rights Reserved

All Trademarks Are Owned By Their Respective Owners