Agile methodologies have radically changed application development. Databases now need to continually evolve along with our applications, especially with the focus on highly iterative, micro-service driven architectures. In this course, Deploying Microsoft Azure Synapse Analytics and Azure SQL Database, you will learn foundational knowledge to create and deploy databases as part of a CI/CD process. First, you’ll learn to create new Azure SQL Databases, Azure Data Warehouses, and Azure Data Factory resources along with creating ARM templates for each resource. Next, you’ll learn how to set up build and release pipelines with Azure DevOps to automatically provision new resources using ARM templates and deploying data warehouse or SQL database using data-tier application packages (DACPAC). Finally, you’ll explore how to migrate existing on-premises SQL Server Databases to Azure using Azure Migrate Service, or keeping your on-premises databases automatically synchronized with Azure SQL Databases using Azure Data Sync. When you’re finished with this course, you will have the skills and knowledge to use Azure DevOps to deploy both Azure SQL Data Warehouses and Azure SQL Databases as part of your Agile processes.
Author Name: Robert Lindley
Author Description:
I have been in love with technology and all of the possibilities that technology provides since the day I first sat in front of a Tandy. It’s a relationship that has been going strong for more than 20 years. I can’t imagine a better career than being a developer creating software and services that have the ability to impact the lives of millions of people at a time.

Table of Contents

• Course Overview
  2mins
• Deploying the Modern Data Warehouse Environment
  30mins
• Choosing a Code Branching Strategy
  24mins
• Implementing a Data Warehouse Build and Release Pipeline
  33mins
• Managing Hybrid Azure SQL Data Warehouse Solutions
  28mins