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

Analyze data with Apache Spark in Azure Synapse Analytics Introduction Get to know Apache Spark Use Spark in Azure Synapse Analytics Analyze data with Spark Visualize data with Spark Exercise – Analyze data with Spark Knowledge check

Use Delta Lake in Azure Synapse Analytics Introduction Understand Delta Lake Create Delta Lake tables Create catalog tables Use Delta Lake with streaming data Use Delta Lake in a SQL pool Exercise – Use Delta Lake in Azure Synapse Analytics Knowledge check

Analyze data in a relational data warehouse Introduction Design a data warehouse schema Create data warehouse tables Load data warehouse tables Query a data warehouse Exercise – Explore a data warehouse Knowledge check

Build a data pipeline in Azure Synapse Analytics Introduction Understand pipelines in Azure Synapse Analytics Create a pipeline in Azure Synapse Studio Define data flows Run a pipeline Exercise – Build a data pipeline in Azure Synapse Analytics Knowledge check