Course Process

What is Database Testing?

Database testing is a process of checking an impact of back-end database operation when operations are performed by connected front-end applications, rest services, or application software.

The 3 types of Database Testing are

  1. Structural Testing
  2. Functional Testing
  3. Non-functional Testing
Why Database Testing?
  1. Data is an Important Corporate Asset.
  2. Mission-critical business functionality is implemented in RDBMSs.
  3. Current Approaches are not sufficient (Visually inspect by developers or formal test at the end of lifecycle)
  4. Testing provides the concrete feedback required to identify defects.


Types of Database Testing (Specific to Relational databases like MySQL, Oracle, etc. )

Data validity testing

For doing data validity testing one should be good in SQL queries

Data Integrity testing

For data integrity testing one should know about referential integrity and different constraint

Performance-related to database

For performance-related things, one should have an idea about the table structure and design

Event-Driven Item Test

Testing of Procedure, triggers, functions, and views

For testing Procedure triggers functions and views you should be able to understand the same

Data Size and Quality test

Validating the database storage occupancy and efficiency

Validating the quality of the data with respect to format, validity, and lengths


Database Testing Checklist

  1. Database synchronization
  2. Database performance
  3. Data integrity
  4. Data field validations
  5. Functionality
  6. Constraints
  7. Data transactions
  8. Database security
  9. Redundant data deletion
  10. Data consistency
  11. To check whether data does not go outside the table
  12. Data compatibility
  13. Data duplication check
  14. Data migration ability
  15. Backup and recovery