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.
Author Name: Aram Koukia
Author Description:
I have been building software since 2001 and Microsoft MVP since 2014. And when I am not creating software, I like hiking, playing soccer, tennis, reading and anything to do with TV shows. Currently living in the Canada’s west coast, Vancouver, beautiful British Columbia and living my dream life.

Table of Contents

• Course Overview
  2mins
• Writing a Data Integrity Test
  38mins
• Resolving Issues from Test Results
  13mins
• Resolving Escalations Related to Data Integrity Tests
  9mins