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

Structural Testing
Functional Testing
Non-functional Testing

Why Database Testing?

Data is an Important Corporate Asset.
Mission-critical business functionality is implemented in RDBMSs.
Current Approaches are not sufficient (Visually inspect by developers or formal test at the end of lifecycle)
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

Database synchronization
Database performance
Data integrity
Data field validations
Functionality
Constraints
Data transactions
Database security
Redundant data deletion
Data consistency
To check whether data does not go outside the table
Data compatibility
Data duplication check
Data migration ability
Backup and recovery

Previous Part Next Part