role-iq-logo
Rock [Azure]
See all Azure roles

Microsoft Azure Developer: Performing Data Integrity Testing

This course teaches you how to build, release, and write database tests by Azure DevOps and Visual Studio. You will also learn how to proactively monitor that the changes made to your data or schema, does not break anything.
Course info
Level
Advanced
Updated
Nov 28, 2018
Duration
1h 3m
Table of contents
Description
Course info
Level
Advanced
Updated
Nov 28, 2018
Duration
1h 3m
Description

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.

About the author
About the author

TBD

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
(Music playing) Hi everyone, my name is Aram Koukia, and welcome to my course, Microsoft Azure Developer: Performing Data Integrity Testing. I am a Microsoft MVP, and a development team lead at LGM Financial Services. we should treat 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 just like any component in our system. In this course, we're going to start using Microsoft Azure DevOps and Visual Studio database projects and proactively test and monitor that the changes we make to our data or schema does not break any of our functionalities. Some of the major topics that we will cover include using SQL Server database projects, implementing database tests in SQL Server database projects, monitoring our SQL Azure database using SQL Azure Intelligent Insights, creating build and release pipelines in Azure DevOps for our database project, running database tests as part of our build and release pipeline. By the end of this course, you will 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. Before beginning the course, you should be familiar with Microsoft Azure, Visual Studio database projects, T-SQL and CI/CD concepts. I hope you will join me on this journey to learn modernize your database development process with Microsoft Azure Developer: Performing Data Integrity Testing course at Pluralsight.