Deploying Microsoft Azure SQL Data Warehouse and Azure SQL Database

In an agile world, employing the same evolutionary approaches to databases as is applied to the application is more necessary than ever. This course brings an agile methodology to databases using Azure DevOps to create agile database deployments.
Course info
Level
Intermediate
Updated
Sep 17, 2019
Duration
1h 60m
Table of contents
Description
Course info
Level
Intermediate
Updated
Sep 17, 2019
Duration
1h 60m
Description

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 SQL Data Warehouse 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.

About the author
About the author

Software architect by day. Dad and husband all year long. I am a lover of technology, future possibilities, and frequent chaser of latest gadgetry.

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hello, My name is Robert Lindley. It welcome to my course deploying Microsoft Azure Data Warehouse and Azure Sequel databases. I currently work as a software architect for a global body camera and in Car Police Video Security Solutions company. I have a long history of building cloud based applications, and I am especially passionate about creating software that has a positive impact on people's lives. In this course, you'll be learning how to leverage the Azure Dev ops capabilities to create continuous integration and continuous deployment. Setups of Azure Sequel database and Azure sequel data Warehouse Resource is you will be learning the basic concepts of how to create Azure Dev ops organizations, projects and repositories. You will also be learning how to use Azure Dev ops to create and manage C I and CD releases for Azure Resource is specifically Azure sequel database as your sequel Data Warehouses and Azure Data Factory. Some of the major topics will cover include managing data lifecycle, using the Azure data factory and creating data ingestion systems from data stores to sequel database or sequel warehouse. This is especially important when building complex applications or for your machine learning or coyote endeavors By the end of this course, you will know enough about Azure Dev ops to confidently create and manage your own source control systems, and you'll be able to create released pipelines for modern data warehousing solutions. Before beginning this course, you should probably be familiar with the basics of the Azure portal and have an active azure subscription. I really hope you'll join me on this journey toe. Learn how to use Azure Dev ops to create and manage modern data warehouses, along with automated data deployments in this course, deploying Microsoft Azure Data Warehouse and Azure sequel database here at Plural site.