Database testing is a procedure of validating data stored in a database and its RELATED functionality and objects controlling database entities like tables, stored procedures, views, triggers and functions. This testing is widely used in applications that USE databases. With MODERN technologies and advancements in software development, databases are widely used to store data which is why checking the correctness and quality of data matters. It is divided into 4 categories such as:

• Data Validity Testing: In this testing, testers NEED to know SQL queries to retrieve data from the database and validate it.
• Data Integrity Testing: Here, the testers need to validate data against various constraints and referential integrity in the database.
• Database Performance Testing: Here, the testers need to validate the performance of various triggers, indices, procedures to see how effectively the operations occur. The system also needs to execute database TRANSACTIONS efficiently. Good knowledge of database structures needs to be there while doing this.
• Testing triggers, functions and procedures present in the database to validate the logic associated with them.