Build data analytics solutions using Azure Synapse serverless SQL pools

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

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

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

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

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

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