Azure Synapse Analytics Bootcamp

Get Started with Azure Synapse Analytics

• Introduction to Azure Synapse Analytics
• Exploring Use of Synapse Analytics
• Understanding Massively Parallel Processing
• Getting started with Data Distribution for an SQL Data Warehouse
• Lab: Getting started with Azure Synapse Analytics

Exploring Components of Azure Synapse Analytics

In this module, you will take a tour of the core application used to interact with the various components of Azure Synapse Analytics.

• Create Azure Synapse Analytics workspace
• Describe Azure Synapse Analytics SQL
• Explain Apache Spark in Azure Synapse Analytics
• Orchestrate data integration with Azure Synapse pipelines
• Lab: Create and manage Azure Synapse Analytics workspace
• Lab: Create pools in Azure Synapse Analytics
• Lab: Identifying Azure Synapse pipeline component

Design and Deploying a Data Warehouse in Microsoft Azure Synapse Analytics

• Describe a modern data warehouse
• Define a modern data warehouse architecture
• Understand data storage for a modern data warehouse
• Understand file formats and structure for a modern data warehouse
• Lab: Define a modern data warehouse architecture
• Lab: Understand data storage for a modern data warehouse
• Lab: Understand file formats and structure for a modern data warehouse

Data Warehouse in Microsoft Azure Synapse Analytics In-depth

• Deploying an SQL Pool in Azure Synapse Analytics with the Azure Portal
• Setting a Firewall Rule and Connecting to an SQL Data Warehouse
• Preparing an SQL Pool in Azure Synapse Analytics to Load Data
• Loading NYC Taxi Data into an SQL Pool in Azure Synapse Analytics
• Examining Configuration Options for an SQL Pool in Azure Synapse Analytics
• Performing Common Tasks with Azure Synapse Analytics in the Portal
• Lab: Define a modern data warehouse architecture
• Lab: Understand data storage for a modern data warehouse
• Lab: Understand file formats and structure for a modern data warehouse

Optimizing a Data Warehouse in Microsoft Azure Synapse Analytics

• Deploying an SQL Pool in Azure Synapse Analytics with the Azure Portal
• Performing a Backup in Azure Synapse Analytics
• Performing a Restore in Azure Synapse Analytics
• Managing Costs in Azure Synapse Analytics
• Managing Workloads in Azure Synapse Analytics
• Securing an Azure SQL Data Warehouse
• Implementing Azure Synapse Analytics Monitoring
• Deleting an Azure Synapse Analytics SQL Pool

Exploring Azure Synapse pipelines

• Deleting an Azure Synapse Analytics SQL Pool
• Introduction to Azure Synapse pipelines
• Create a pipeline and add a notebook activity
• Schedule the pipeline to run on schedule
• Forcing a pipeline to run immediately
• Monitor pipeline execution

Data Flows in Azure Synapse Analytics

• Deleting an Azure Synapse Analytics SQL Pool
• Introduction to Data flows in Azure Synapse Analytics
• Create a create a data flow
• Authoring data flows
• Managing the mapping data flow graph
• Parameterizing mapping data flows
• Transformation and Optimize data flows performance
• Monitoring data flows

Introduction to Azure Synapse Notebooks

• Introduction to Azure Synapse Notebooks
• Create notebooks
• Run Spark SQL statements
• Bring data to a notebook
• Use multiple languages using magic commands and temporary tables
• Use cell magic commands
• Clean up resources

Visualization in Azure Synapse Analytics using Power BI

• Introduction to Visualization in azure synapse
• Create a Power BI workspace
• Connecting Azure Synapse workspace to your new Power BI workspace
• Create a Power BI dataset using Azure Synapse workspace data
• Create and configure authentication for dataset
• Generating and editing reports Synapse Studio