Database Testing:

What is a Database Test?

• It is a type of software testing that checks the schema, tables, triggers, etc. of the database.
• Testing involves validating:
  • Schema
  • Database tables
  • Rows/Columns
  • Keys and Indexes
  • Stored procedures
  • Triggers
  • Database server validations
  • Data duplication
• Also known as Back-end Testing or Data Testing

Function of Database Tests:

• Checks data integrity and consistency
• Checks data mapping
• Checks atomicity, consistency, isolation, and durability of the system
• Checks business rule conformity

The 3 types of Database Testing are [1]:

• Structural Testing
• Functional Testing
• Non-functional Testing

Steps for Database Testing Chart:

Test Results:

• Migration test results might look something like Table and Row comparisons of old DB and new DB
• For New databases Smoke, Integration and Regression tests must be run without error. Performance/Load tests must also be run.
• For simple changes or maintenance only changes Smoke, Integration and Regression test must be run without error.
• For more detailed test result reading: https://www.guru99.com/data-testing.html

Reference(s):

• [1] https://www.guru99.com/data-testing.html
• TestingAcronyms
• CommonTestingTerms