Build data analytics solutions using Azure Synapse serverless SQL pools
- Offered byMicrosoft
Build data analytics solutions using Azure Synapse serverless SQL pools at Microsoft Overview
Duration | 3 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Build data analytics solutions using Azure Synapse serverless SQL pools at Microsoft Course details
- Use Azure Synapse serverless SQL pool to query files in a data lake
- Create a lake database in Azure Synapse Analytics
- Use Azure Synapse serverless SQL pools to transform data in a data lake
- Serve the data from Azure Synapse serverless SQL pool
- Secure data and manage users in Azure Synapse serverless SQL pools
- Azure Synapse Analytics enables you to apply the SQL skills you use in a relational database to files in a data lake
- By using a serverless SQL pool in Azure Synapse Analytics, you can use the ubiquitous SQL language to transform data in files in a data lake
- Learn how to serve and make use of the data that is queried or transformed by Azure Synapse serverless SQL pool
Build data analytics solutions using Azure Synapse serverless SQL pools at Microsoft Curriculum
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
Create a lake database in Azure Synapse Analytics
Introduction
Understand lake database concepts
Explore database templates
Create a lake database
Use a lake database
Exercise - Analyze data in a lake database
Knowledge check
Summary
Use Azure Synapse serverless SQL pools to transform data in a data lake
Introduction
Transform data files with the CREATE EXTERNAL TABLE AS SELECT statement
Encapsulate data transformations in a stored procedure
Include a data transformation stored procedure in a pipeline
Exercise - Transform files using a serverless SQL pool
Knowledge check
Summary
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
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
Build data analytics solutions using Azure Synapse serverless SQL pools at Microsoft Entry Requirements
- Consider completing the Explore data analytics in Azure and Get started querying with Transact-SQL learning paths before starting this learning path. You will need knowledge of:Analytical data workloads in Microsoft AzureQuerying data with Transact-SQL
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?
ManagementBusiness AnalyticsData AnalysisBuild data analytics solutions using Azure Synapse serverless SQL pools