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
- 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