Implementing a Cloud Data Warehouse in Microsoft Azure Synapse Analytics
This course is foundational to learn Microsoft Azure Synapse Analytics. You'll create a working Synapse Analytics SQL data warehouse, loaded with data, that will let you play with all the new features of this new environment.
What you'll learn
Microsoft Azure Synapse Analytics is a new environment that merges all the Azure data resources into one shared space. In this course, Implementing a Cloud Data Warehouse in Microsoft Azure Synapse Analytics, you'll focus on building an SQL data warehouse in Synapse. First, you'll learn what Azure Synapse Analytics does. Next, you'll discover how to deploy a data warehouse. Finally, you'll explore how to load data into your warehouse and work with it, saving money in the process. By the end of this course, you’ll have a working Synapse Analytics SQL data warehouse, loaded with data, that will let you work with all the new features.
Table of contents
- Introduction 1m
- Deploying an SQL Pool in Azure Synapse Analytics with the Azure Portal 6m
- Setting a Firewall Rule and Connecting to an SQL Data Warehouse 5m
- Preparing an SQL Pool in Azure Synapse Analytics to Load Data 7m
- Loading NYC Taxi Data into an SQL Pool in Azure Synapse Analytics 4m
- Examining Configuration Options for an SQL Pool in Azure Synapse Analytics 7m
- Performing Common Tasks with Azure Synapse Analytics in the Portal 4m
- Introduction 1m
- Performing a Backup in Azure Synapse Analytics 2m
- Performing a Restore in Azure Synapse Analytics 4m
- Managing Costs in Azure Synapse Analytics 5m
- Managing Workloads in Azure Synapse Analytics 5m
- Securing an Azure SQL Data Warehouse 4m
- Implementing Azure Synapse Analytics Monitoring 4m
- Deleting an Azure Synapse Anyalytics SQL Pool 2m
About the author
Gary has been working in Information Technology for over 15 years. He has worked with Exchange Server since version 5.5 and has experience in both training and hands on implementations. His energetic delivery and passion for technology makes him a popular trainer. He has developed many online courses and delivers training all over the world.