YoVDO

Realize Integrated Analytical Solutions with Azure Synapse Analytics

Offered By: Microsoft via Microsoft Learn

Tags

Microsoft Azure Courses Data Analysis Courses Data Visualization Courses Apache Spark Courses Azure Synapse Analytics Courses Data Preparation Courses Data Integration Courses

Course Description

Overview

  • Module 1: Introduction to Azure Synapse Analytics
  • In this module, you will learn:

    • What is Azure Synapse Analytics
    • How Azure Synapse Analytics works
    • When to use Azure Synapse Analytics
  • Module 2: Survey the Components of Azure Synapse Analytics
  • In this module, you will:

    • Create Azure Synapse Analytics Workspace
    • Describe Azure Synapse SQL
    • Explain Apache Spark in Azure Synapse Analytics
    • Orchestrate Data Integration with Azure Synapse Pipelines
    • Visualize your analytics with Power BI
    • Understand Hybrid Transactional Analytical Processing with Azure Synapse Link
  • Module 3: Explore Azure Synapse Studio
  • In this module, you will:

    • Use Azure Synapse Studio
    • Understand the Azure Synapse Analytical processes
    • Explore the Data hub
    • Explore the Develop hub
    • Explore the Integrate hub
    • Explore the Monitor hub
    • Explore the Manage hub
  • Module 4: Design a Modern Data Warehouse using Azure Synapse Analytics
  • In this module, you will:

    • Describe a Modern Data Warehouse
    • Define a Modern Data Warehouse Architecture
    • Design ingestion patterns for a Modern Data Warehouse
    • Understand data storage for a Modern Data Warehouse
    • Understand file formats and structure for a modern data warehouse
    • Prepare and transform data with Azure Synapse Analytics
    • Serve data for analysis with Azure Synapse Analytics

Syllabus

  • Module 1: Introduction to Azure Synapse Analytics
    • Introduction
    • What is Azure Synapse Analytics
    • How Azure Synapse Analytics works
    • When to use Azure Synapse Analytics
    • Knowledge check
    • Summary
  • Module 2: Survey the Components of Azure Synapse Analytics
    • Introduction
    • Create Azure Synapse Analytics workspace
    • Exercise - Create and manage Azure Synapse Analytics workspace
    • Describe Azure Synapse Analytics SQL
    • Explain Apache Spark in Azure Synapse Analytics
    • Exercise - Create pools in Azure Synapse Analytics
    • Orchestrate data integration with Azure Synapse pipelines
    • Exercise-Identifying Azure Synapse pipeline components
    • Visualize your analytics with Power BI
    • Understand hybrid transactional analytical processing with Azure Synapse Link
    • Knowledge check
    • Summary
  • Module 3: Explore Azure Synapse Studio
    • Introduction
    • Use Azure Synapse Studio
    • Understand the Azure Synapse Analytical processes
    • Explore the Data hub
    • Explore the Develop hub
    • Explore the Integrate hub
    • Explore the Monitor hub
    • Explore the Manage hub
    • Knowledge check
    • Summary
  • Module 4: Design a Modern Data Warehouse using Azure Synapse Analytics
    • Introduction
    • Describe a modern data warehouse
    • Define a modern data warehouse architecture
    • Exercise - Identify modern data warehouse architecture components
    • Design ingestion patterns for a modern data warehouse
    • Understand data storage for a modern data warehouse
    • Understand file formats and structure for a modern data warehouse
    • Prepare and transform data with Azure Synapse Analytics
    • Serve data for analysis with Azure Synapse Analytics
    • Knowledge check
    • Summary

Tags

Related Courses

AZ-103 Microsoft Azure Administrator 2019 (Preview)
A Cloud Guru
AZ-104 Microsoft Azure Administrator Certification Prep
A Cloud Guru
AZ-204: Developing Solutions for Microsoft Azure
A Cloud Guru
AZ-303 Part 1 - Implement and Monitor Azure Infrastructure
A Cloud Guru
AZ-303 Part 2 - Implement Management and Security Solutions in Azure
A Cloud Guru