Microsoft Azure Synapse for Developers

Introduction

• Data warehouses in the cloud
• What you should know

1. Getting Started with Azure Synapse Analytics

• Azure Synapse Analytics overview
• Creating Azure Synapse Analytics workspaces
• Analyzing the architecture of dedicated SQL pools
• Provisioning dedicated Synapse Analytics pools
• Challenge: Create a Synapse Analytics workspace with a dedicated pool
• Solution: Create a Synapse Analytics workspace with a dedicated pool

2. Populating Dedicated Synapse Analytics Pools

• Data loading in Azure Data Warehouse
• Preparing your data
• Exploring Azure Synapse Studio
• Loading data using the copy tool
• Load data using the COPY command
• Load data with PolyBase
• Transform data using data flows
• Challenge: Loading data using the copy tool
• Solution: Loading data using the copy tool

3. Streaming Data into Azure Synapse Analytics

• Data streaming scenarios
• Creating a Stream Analytics job
• Testing data streaming using sample data

4. Querying Using Serverless SQL

• Understanding serverless pools
• Querying and discovering data using serverless pools
• Using file metadata in queries
• Building a logical data warehouse, part 1
• Building a logical data warehouse, part 2
• Manage statistics
• Cost management
• Challenge: Query partitioned data
• Solution: Query partitioned data

5. Querying and Best Practices in Dedicated SQL Pools

• Querying, labeling, and tracking data warehouse performance
• Transactions in dedicated SQL pool
• Optimizing queries with materialized views
• Connecting using external clients
• Creating and updating statistics
• Analyzing data distribution

Conclusion

• Next steps with Synapse Analytics