Deploying Microsoft Azure Synapse Analytics 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
Rating
(19)
Level
Intermediate
Updated
Aug 20, 2020
Duration
1h 57m
Table of contents
Description
Course info
Rating
(19)
Level
Intermediate
Updated
Aug 20, 2020
Duration
1h 57m
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 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.

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 and welcome to my course, deploying Microsoft Azure Synapse Analytics Warehouse and Azure Sequel databases. I currently work as a software architect, designing and building software and services for a global electron ICS company. I have a long history of building cloud based applications, and I'm especially passionate about creating software that has a positive impact on people's lives. In this course, you'll be learning how to leverage Azure Dev ops capabilities to create continuous integration and continuous deployments of both Azure Sequel database or an azure Synapse Analytics warehouse resource. You'll be learning the basic concepts of how to create an azure Dev ops organization, Projects and Repositories. You will also be learning how to use Azure Dev ops to create and manage. See I CD releases for Azure Resource is especially for Azure sequel database as your Synapse Analytics in Azure Data Factory. Some of the major topics that will cover include managing data life cycles, using azure data factory and creating data ingestion systems for both data stores to an Azure sequel database or an azure Synapse Analytics warehouse. This is especially important when building complex applications or for your machine Learning or i o. T. Endeavors. By the end of this course, you will know enough about Azure Dev ops to confidently create in manager 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 have some familiarity with the basics of the Azure portal and also 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 automating database deployments in this course deploying Microsoft Azure Synapse Analytics Warehouse and Azure sequel database here at plural site.