Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
- Use Azure Synapse serverless SQL pool to query files in a data lake
After the completion of this module, you will be able to:
- Identify capabilities and use cases for serverless SQL pools in Azure Synapse Analytics
- Query CSV, JSON, and Parquet files using a serverless SQL pool
- Create external database objects in a serverless SQL pool
- Use Azure Synapse serverless SQL pools to transform data in a data lake
After completing this module, you'll be able to:
- Use a CREATE EXTERNAL TABLE AS SELECT (CETAS) statement to transform data.
- Encapsulate a CETAS statement in a stored procedure.
- Include a data transformation stored procedure in a pipeline.
- Create a lake database in Azure Synapse Analytics
After completing this module, you will be able to:
- Understand lake database concepts and components
- Describe database templates in Azure Synapse Analytics
- Create a lake database
- 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
