YoVDO

Implement a Data Analytics Solution with Azure Synapse Analytics

Offered By: Microsoft via Microsoft Learn

Tags

Azure Synapse Analytics Courses SQL Courses Data Warehousing Courses Apache Spark Courses Data Lakes Courses JSON Courses Data Analytics Courses Data Pipelines Courses Delta Lake Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
  • Module 1: Introduction to Azure Synapse Analytics

    In this module, you'll learn how to:

    • Identify the business problems that Azure Synapse Analytics addresses.
    • Describe core capabilities of Azure Synapse Analytics.
    • Determine when to use Azure Synapse Analytics.
  • Module 2: Use Azure Synapse serverless SQL pool to query files in a data lake

    After the completion of this module, you will be able to:

    • Identify capabilities and use cases for serverless SQL pools in Azure Synapse Analytics
    • Query CSV, JSON, and Parquet files using a serverless SQL pool
    • Create external database objects in a serverless SQL pool
  • Module 3:

Syllabus

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

Tags

Related Courses

SAP Business Warehouse powered by SAP HANA
SAP Learning Relational Database Support for Data Warehouses
University of Colorado System via Coursera Data Warehouse Concepts, Design, and Data Integration
University of Colorado System via Coursera Business Intelligence Concepts, Tools, and Applications
University of Colorado System via Coursera Design and Build a Data Warehouse for Business Intelligence Implementation
University of Colorado System via Coursera