Search
Cancel
Sign In

Build data analytics solutions using Azure Synapse serverless SQL pools

Go to class
Write Review

Free Online Course: Build data analytics solutions using Azure Synapse serverless SQL pools provided by Microsoft Learn is a comprehensive online course, which lasts for 2-3 hours worth of material. The course is taught in English and is free of charge.

Microsoft via Microsoft Learn
2-3 hours worth of material
Self Paced
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

← Prev Next →
0, based on 0 Course votes at GetYourEducation

Start your review of Build data analytics solutions using Azure Synapse serverless SQL pools

Add review ->
Related courses by Level

Accounting for Mergers and Acquisitions: Foundations

Intermediate
Provider: Coursera
Language: English

Advanced Topics in Derivative Pricing

Intermediate
Provider: Coursera
Language: English

Assisting Public Sector Decision Makers With Policy Analysis

Intermediate
Provider: Coursera
Language: English

Creating and Capturing Mixed Reality

Intermediate
Provider: Kadenze
Language: English

Docker. Basics

Intermediate
Provider: Coursera
Language: English

Natural Language Processing and Capstone Assignment

Intermediate
Provider: Coursera
Language: English
Browse by subject
Browse by provider
Browse by university
Browse by institution
College Rankings