AZURE DATA SERVICES BOOT CAMP
Microsoft Azure is an ever-expanding set of cloud services to help your organization meet your business challenges, but where do you start? Transitioning from on-prem development to working in Azure can seem a daunting task. This course will take a deep dive into the Azure architecture and you will learn how to build an end to end solution entirely in the cloud through extensive hands on labs.
The course begins with an overview of the Azure architecture and quickly transitions into the vast Azure storage offerings available. Next you learn how to provision Azure SQL DB, how to perform database migrations and how to properly scale up and scale down resources as necessary. You will also learn when Azure SQL DB Managed Instance could be leveraged in place of Azure SQL DB. Next, you will learn how to extract data, apply business rules and transformations and load data using Azure Data Factory. With Azure Logic Apps you will learn how to extend the capabilities of other resources in Azure and build automated workflows. Finally, you will learn how to use Power BI to build reports, dashboards and live streaming datasets from Azure.
Please note, our On-Demand Learning members, get an extra 25% off in any Boot Camp. Please contact training@pragmaticworks.com to complete your registration.
Prerequisites
No prior experience is required.
System Requirements
+ Azure Subscription (Trial or Paid)
(Optional)
+ SQL Server Management Studio v17.5 or Later
Course Outline
Module 1
Azure Architecture Overview
Module 2
Getting Started with Azure PowerShell
Module 3
Data Modeling in Azure
Module 4
Understanding Azure Storage
Module 5
Apache Spark
Module 6
Azure SQL DB
Module 7
Azure SQL DB Managed Instance
Module 8
Azure Data Factory
Module 9
Azure Logic Apps
Module 10
Power BI for Reporting