It is important to treat your database code, schema and data in the same way as our Services and UI Code. We must create a modern, automated process to build and release database tests using Microsoft Azure DevOps, Visual Studio Database projects, and monitor that any changes to our data or schema do not cause any functionalities to be broken. This course, Microsoft Azure Developer - Performing Data Integrity testing, will teach you how to build, release and process a database project. You'll also learn how to write database tests to ensure that any changes to your schema are not broken. You will first learn how to create a SQL Database Project in Visual Studio and how to import an existing database into a SQL Database Project. Next, you'll learn how to use Microsoft Azure DevOps to create your SQL Database Project, deploy it to a SQL Azure Instance and then run database tests after each deployment. You will also learn how to resolve issues raised by clients. Run your database tests to find the root cause, then fix it using your SQL Database Project. Finally, use the Azure DevOps pipelines to release the data fix to your environment. This course will teach you how to create a modern DevOps workflow to manage all your database development projects. It includes automated build and release pipelines in Azure DevOps as well as proactive monitoring and implementing. You'll also learn how to run database tests to ensure your data integrity.
