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

Advanced Features with Relational Database Tables Using SQLiteStudio
Coursera Project Network via Coursera Advanced Relational Database and SQL
Coursera Project Network via Coursera Advanced SQL
Kaggle Advanced SQL Retrieval Queries in SQLiteStudio
Coursera Project Network via Coursera Aggregate Data with LibreOffice Base Queries
Coursera Project Network via Coursera