Course Overview
This Bootcamp is designed by industry professionals to help you master Azure Synapse Analytics. As a part of this bootcamp, you get to work on multiple real-life projects.
Key Learning Areas
- Getting Started with Azure Synapse Analytics
- Exploring Components of Azure Synapse Analytics
- Design and Deploying a Data Warehouse in Azure Synapse Analytics
- Data Warehouse in Azure Synapse Analytics In-Depth
- Optimizing a Data Warehouse in Azure Synapse Analytics
- Exploring Azure Synapse Pipelines
- Data Flows in Azure Synapse Analytics
- Introduction to Azure Synapse Notebooks
- Visualization in Azure Synapse using Power BI
Course Outline
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
Prerequisites
- Familiarity with cloud computing concepts and Microsoft Azure
- Familiarity with fundamental data concepts