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