What you'll learn

We need to start treating our database code, schema, and data the same way we treat our Services and UI Code, and create a modern and automated process to build, release, and write database tests using Microsoft Azure DevOps and Visual Studio Database projects, and proactively monitor that the changes made to our data or schema, does not break any of our functionalities. In this course, Microsoft Azure Developer: Performing Data Integrity Testing, you will learn how to create a modern architecture to build, release, process, and write database tests your database project to make sure your changes to your schema does not break anything. First, you will discover how to create a SQL Database project in Visual Studio, and how to import your existing database into a SQL Database project. Next, you will explore Microsoft Azure DevOps, use the Build and Release pipeline to build your SQL Database Project deploy the database to a SQL Azure Instance, and run database tests at the end of each deployment. Finally, you will discover how to investigate issues that are raised from your clients, find the root cause by running your database tests, fix the issue from your SQL Database project, and finally, release the data fix to your environment using the Azure DevOps build and release pipelines. By the end of this course, you'll know how to build a modern DevOps workflow for all your database developments, with automated build and release pipelines in Azure DevOps, proactive monitoring and implementing, and running database tests to verify your data integrity.