Introduction CI-CD for Database - Microsoft Azure Tutorial

Introduction CI-CD for Database is a free tutorial by Houssem Dellai from Microsoft Azure course
Link to this course(Special Discount):
https://www.udemy.com/course/azure-devops-ci-cd-pipelines/?ranMID=39197&ranEAID=Gw%2FETjJoU9M&ranSiteID=Gw_ETjJoU9M-P2mJLIareMpOnNMstjf.zQ&LSNPUBID=Gw%2FETjJoU9M&utm_source=aff-campaign&utm_medium=udemyads
This is the best Microsoft Azure Course
Course summary:
What is DevOps and CI/CD
Creating CI/CD pipelines for Web, Mobile and Container apps
Including the Database into the pipelines
Configure deployment to Azure Cloud
Run unit, functional and load tests as part of the pipeline
Analyse source code using Sonar
Use Infrastructure as Code (IaC) from CI/CD with ARM templates
Use Configuration as Code (CaC) in Azure DevOps
Create Dev-Test-Prod environments
Secure the pipelines sensitive data
Use Infrastructure as Code (IaC) from CI/CD with Terraform
English [Auto]
Let's learn how to create the CIC D pipeline for a sequel server database for applications that uses a database. We can either use entity framework to manage the database migrations but lots of users are actually using as dirty tools secret server that are tools. This means they use the database project type and Visual Studio are available also on SS M S equal server management studio because this project gives them more flexibility and more control over the scripts that will run on the database creating this UI and Cindy pipelines for the database now means building the. This project type this database project in order to generate the deck back file then deploying that DAC back from this 2D pipeline the deck black file is a package that contains the sequel scripts and also the stored procedures for the new schema of the database. So in each time we want to add a table that should go to and do a sequel script and the script will be included. And to this attack back. File so from our CIA pipeline will get that database project then we'll build it using s build task because it won't build with botnet so we'll be using a mis built so we generate the deck back file. Now later from this 2D pipeline will take that that back file from the artifact then we deploy it and 2 is equal Asia database or we can also connect to any sequel server database and to deploy that file to update the schema of that database.
Introduction CI-CD for Database Create CI/CD pipelines for Java, .NET, NodeJs, Docker, Terraform, Nuget, Xamarin, SQL Server and ARM templates