How to Test Foreign Key Constraints in Your Database

After explaining how to automate data quality tests and how to test primary key constraint in your database, in this article we’ll focus on tests related to foreign key constraints. Foreign keys (FKs) are used to establish relations between data stored...

Continue reading


Likes0 Comments10 Minutes

How to Test SQL Primary Key Constraints

Following the previous article on how to automate data quality tests in your database, this article is about how to optimally establish your database controls to automatically check a SQL primary key constraint. Let's mention few prerequisites...

Continue reading


Likes0 Comments5 Minutes

How to Automate Data Quality Tests in Your Database?

In this article, I will be focusing on implementing test automation on data quality, meaning testing the data structure and the data already stored in the database. Rather than, terms such as primary, unique and foreign key constraints. To understand...

Continue reading


Likes0 Comments6 Minutes