Microsoft Azure Developer: Performing Data Integrity Testing from Pluralsight

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.

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.

What's inside

Syllabus

Course Overview

Writing a Data Integrity Test

Resolving Issues from Test Results

Resolving Escalations Related to Data Integrity Tests

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Suitable for database developers, database engineers, and other professionals who want to develop their skill in Microsoft Azure DevOps and Visual Studio Database projects

Develops Azure DevOps pipelines and Microsoft SQL Database, which are industry standard tools

Taught by Aram Koukia, an expert in database development and data integrity testing

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft Azure Developer: Performing Data Integrity Testing with these activities:

Create a simple SQL database and populate it with sample data.

Show steps

Reinforces understanding of core database concepts and provides hands-on experience in working with data.

Browse courses on SQL Database

Show steps

Create a new SQL database using your preferred database management system.
Design and create a table structure for your sample data.
Populate the table with sample data that represents real-world scenarios.

Create a Database Project in Visual Studio

Show steps

Apply your knowledge of Visual Studio by creating a database project.

Browse courses on Visual Studio

Show steps

Open Visual Studio.
Create a new SQL Database project.
Add a database to the project.
Build the project.

Participate in a Database Testing Study Group

Show steps

Enhance your understanding of database testing through collaboration and discussion with peers.

Browse courses on Database Testing

Show steps

Find a study group or create your own.
Meet regularly to discuss database testing topics.
Share knowledge and resources with each other.

Three other activities

Expand to see all activities and additional details

Show all six activities

Follow a Tutorial on Azure DevOps

Show steps

Gain a deeper understanding of Azure DevOps by following a guided tutorial.

Browse courses on Azure DevOps

Show steps

Find a reputable tutorial on Azure DevOps.
Follow the tutorial step-by-step.
Experiment with different features of Azure DevOps.

Practice Writing Data Integrity Tests

Show steps

Improve your ability to write effective data integrity tests by practicing regularly.

Browse courses on Database Testing

Show steps

Create a sample database.
Write a data integrity test for the database.
Run the test and verify that it passes.

Deploy a Database to Azure SQL Instance

Show steps

Gain hands-on experience in deploying a database to Azure SQL Instance.

Browse courses on Database Deployment

Show steps

Create an Azure SQL Instance.
Create a database in the instance.
Deploy the database to the instance.
Verify that the database is deployed successfully.

Career center

Learners who complete Microsoft Azure Developer: Performing Data Integrity Testing will develop knowledge and skills that may be useful to these careers:

Database Administrator

A Database Administrator is responsible for the installation, configuration, maintenance, and performance of database systems. They work with database developers to ensure that the database is designed and implemented to meet the needs of the business. Individuals in this role may find this course particularly useful as it will help them to develop the skills necessary to create and maintain a performant and reliable database system.

See salaries and explore the career path for Database Administrator

Data Engineer

Data Engineers design, build, and maintain data pipelines and systems. They work with data scientists and other data professionals to ensure that data is available and accessible in a timely and reliable manner. Individuals in this role will find this course useful as it will help them to develop the skills necessary to build and maintain a performant and reliable data pipeline.

See salaries and explore the career path for Data Engineer

Data Analyst

Data Analysts collect, analyze, interpret, and present data to help businesses understand their operations and make informed decisions. They use a variety of statistical and data analysis techniques to identify trends, patterns, and relationships in data. This course will provide Data Analysts with the skills they need to perform data integrity testing.

See salaries and explore the career path for Data Analyst

Software Developer

Software Developers design, develop, and test software applications. They work with a variety of programming languages and technologies to create software that meets the needs of users. This course may be useful for Software Developers who are interested in learning how to develop database applications.

See salaries and explore the career path for Software Developer

DevOps Engineer

DevOps Engineers work to bridge the gap between development and operations teams. They use a variety of tools and techniques to automate the software development and deployment process. This course may be useful for DevOps Engineers who are interested in learning how to perform data integrity testing.

See salaries and explore the career path for DevOps Engineer

Cloud Architect

Cloud Architects design and implement cloud computing solutions. They work with businesses to help them migrate their applications and data to the cloud. This course may be useful for Cloud Architects who are interested in learning how to perform data integrity testing in the cloud.

See salaries and explore the career path for Cloud Architect

Data Scientist

Data Scientists use a variety of statistical and data analysis techniques to extract insights from data. They work with businesses to help them make informed decisions.

See salaries and explore the career path for Data Scientist

Business Analyst

Business Analysts work with businesses to identify and solve business problems. They use a variety of analytical techniques to collect, analyze, and interpret data.

See salaries and explore the career path for Business Analyst

Project Manager

Project Managers plan, organize, and execute projects. They work with teams of people to achieve project goals.

See salaries and explore the career path for Project Manager

Data Warehouse Architect

Data Warehouse Architects design and implement data warehouse solutions. They work with businesses to help them manage and analyze their data.

See salaries and explore the career path for Data Warehouse Architect

Database Designer

Database Designers design and implement database systems. They work with businesses to identify and meet their data needs.

See salaries and explore the career path for Database Designer

Software Tester

Software Testers test software applications to ensure that they meet the needs of users. They use a variety of testing techniques to identify and fix software defects.

See salaries and explore the career path for Software Tester

System Administrator

System Administrators manage and maintain computer systems. They work with a variety of operating systems and software applications to keep systems running smoothly.

See salaries and explore the career path for System Administrator

Network Administrator

Network Administrators manage and maintain computer networks.

See salaries and explore the career path for Network Administrator

Web Developer

Web Developers design and develop websites. They use a variety of programming languages and technologies to create websites that meet the needs of users.

See salaries and explore the career path for Web Developer