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.
Read more
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.
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
Read more
Syllabus
Good to know
Save this course
Save
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.
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.
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
Database Administrator
Data Engineer
Data Analyst
Software Developer
DevOps Engineer
Cloud Architect
Data Scientist
Business Analyst
Project Manager
Data Warehouse Architect
Database Designer
Software Tester
System Administrator
Network Administrator
Web Developer
Reading list
Save
Share
Similar courses
- Microsoft Azure Developer: Performing Load Testing
- Microsoft Azure Developer: Performing Unit Testing & Integration Testing
- Microsoft Azure Developer: Performing Automated End-to-end Testing
- Microsoft Azure Developer: Performing Data Integrity Testing (viewing)
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
