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

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX