YoVDO

Build data analytics solutions using Azure Synapse serverless SQL pools

Offered By: Microsoft via Microsoft Learn

Tags

Microsoft Azure Courses Data Visualization Courses SQL Courses Data Transformation Courses Data Analytics Courses User Management Courses Data Security Courses

Course Description

Overview

  • Module 1: Explore Azure Synapse serverless SQL pools capabilities

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

    • Identify Azure Synapse serverless SQL pools
    • Describe when to use Azure Synapse serverless SQL pools
    • Discuss Azure Synapse serverless SQL pools use cases
  • Module 2: Query data in the lake using Azure Synapse serverless SQL pools

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

    • Query a CSV file using Azure Synapse serverless SQL pools
    • Query a Parquet file using Azure Synapse serverless SQL pools
    • Query a JSON file using Azure Synapse serverless SQL pools
    • Query multiple files and folders using Azure Synapse serverless SQL pools
    • Understand storage considerations when using Azure Synapse serverless SQL pools
  • Module 3: Create metadata objects in Azure Synapse serverless SQL pools

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

    • Create databases in Azure Synapse serverless SQL pools
    • Create and manage credentials in Azure Synapse serverless SQL pools
    • Create external data sources in Azure Synapse serverless SQL pools
    • Create external tables in Azure Synapse serverless SQL pools
    • Create views in Azure Synapse serverless SQL pools
  • Module 4: Use Azure Synapse serverless SQL pools for transforming the data in the lake

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

    • Transform data with Azure Synapse serverless SQL pools using CREATE EXTERNAL TABLE AS SELECT statement
    • Operationalize data transformation with Azure Synapse serverless SQL pools using stored procedures
    • Use Azure Synapse serverless SQL pool stored procedures from Synapse Pipelines
  • Module 5: Serve the data from Azure Synapse serverless SQL pool

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

    • Use Synapse Studio to analyze and visualize data via Azure Synapse serverless SQL pool
    • Use Azure Synapse serverless SQL pools as a data source in Synapse Pipelines
    • Use Power BI to visualize the data from Azure Synapse serverless SQL pool
    • Issue queries programmatically on Azure Synapse serverless SQL pool
  • Module 6: Secure data and manage users in Azure Synapse serverless SQL pools

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

    • Choose an authentication method in Azure Synapse serverless SQL pools
    • Manage users in Azure Synapse serverless SQL pools
    • Manage user permissions in Azure Synapse serverless SQL pools

Syllabus

  • Module 1: Explore Azure Synapse serverless SQL pools capabilities
    • Introduction
    • What is Azure Synapse serverless SQL pools
    • When to use Azure Synapse serverless SQL pools
    • Azure Synapse serverless SQL pools use cases
    • Knowledge check
    • Summary
  • Module 2: Query data in the lake using Azure Synapse serverless SQL pools
    • Introduction
    • Query a CSV file using Azure Synapse serverless SQL pools
    • Query a Parquet file using Azure Synapse serverless SQL pools
    • Query a JSON file using Azure Synapse serverless SQL pools
    • Query multiple files and folders using Azure Synapse serverless SQL pools
    • Storage considerations when using Azure Synapse serverless SQL pools
    • Knowledge check
    • Summary
  • Module 3: Create metadata objects in Azure Synapse serverless SQL pools
    • Introduction
    • Create databases in Azure Synapse serverless SQL pools
    • Create and manage credentials in Azure Synapse serverless SQL pools
    • Create external data sources in Azure Synapse serverless SQL pools
    • Create external tables in Azure Synapse serverless SQL pools
    • Create views in Azure Synapse serverless SQL pools
    • Knowledge check
    • Summary
  • Module 4: Use Azure Synapse serverless SQL pools for transforming the data in the lake
    • Introduction
    • Transform data with Azure Synapse serverless SQL pools using CREATE EXTERNAL TABLE AS SELECT statement
    • Operationalize data transformation with Azure Synapse serverless SQL pools using stored procedures
    • Use Azure Synapse serverless SQL pool stored procedures from Synapse Pipelines
    • Knowledge check
    • Summary
  • Module 5: Serve the data from Azure Synapse serverless SQL pool
    • Introduction
    • Use Synapse Studio to analyze and visualize data via Azure Synapse serverless SQL pool
    • Use Azure Synapse serverless SQL pools as a data source in Synapse Pipelines
    • Use Power BI to visualize the data from Azure Synapse serverless SQL pool
    • Issue queries programmatically on Azure Synapse serverless SQL pool
    • Knowledge check
    • Summary
  • Module 6: Secure data and manage users in Azure Synapse serverless SQL pools
    • Introduction
    • Choose an authentication method in Azure Synapse serverless SQL pools
    • Manage users in Azure Synapse serverless SQL pools
    • Manage user permissions in Azure Synapse serverless SQL pools
    • Knowledge check
    • Summary

Tags

Related Courses

Building Cloud Apps with Microsoft Azure - Part 1 (self-paced)
Microsoft via edX Building Cloud Apps with Microsoft Azure - Part 3
Microsoft via edX DEV202.2x: Building Cloud Apps with Microsoft Azure – Part 2
Microsoft via edX Architecting Microsoft Azure Solutions
Microsoft via edX Implementing Predictive Analytics with Spark in Azure HDInsight
Microsoft via edX