Introduction to Azure Synapse Analytics
- Identifying business problems addressed by Azure Synapse Analytics
- Describing core capabilities and determining when to use Azure Synapse Analytics
Lab: Exploring Azure Synapse Analytics
Use Azure Synapse Serverless SQL Pool to Query Files in a Data Lake
- Identifying capabilities and use cases for serverless SQL pools
- Querying CSV, JSON, and Parquet files
- Creating external database objects
Lab: Querying files using a serverless SQL pool
Analyze Data with Apache Spark in Azure Synapse Analytics
- Identifying core features and configuring a Spark pool
- Running code to load, analyze, and visualize data
Lab: Analyzing data with Spark
Use Delta Lake in Azure Synapse Analytics
- Describing core features and capabilities of Delta Lake
- Creating and using Delta Lake tables
- Using Delta Lake tables for streaming data and querying from a Synapse Analytics SQL pool
Lab: Using Delta Lake in Azure Synapse Analytics
Analyze Data in a Relational Data Warehouse
- Designing a schema for a relational data warehouse
- Creating fact, dimension, and staging tables
- Loading and querying data warehouse tables using SQL
Lab: Exploring a data warehouse