Database Testing checklist

Check list for database testing :

First understand what is there in a Database

·         Tables

·         Views

·         Procedures

·         Triggers

·         Indexes

·         Cursors

·         Constraints

1. Verify Data stored in Tables (Data integrity)

The complete data in the database is stored in the tables. Depending on the database design, the data may be present in a single table or multiple related tables.

Verify the data in the tables is correct and also validate the data is stored correct with respect to Front End updated data.

Verify the data is present in the correct table and correct field within the table.

2. Constraints

       Verify all the required constraints are created on the Tables, likes Primary key, Foreign key, rules…etc 

       Verify valid references are done for foreign key.

3. Procedures :

Verify the procedures will run correct and validate the data updates after the procedure is executed

4. Triggers :

            Verify the triggers are executed for the DML transactions and verify the data updates after the trigger is fired.

5.  Indexes :

             Verify the required indexes are created on the tables like Clustered index, non clustered index…etc

6. Transactions :

             Verify the transactions are done correct and check the data is commited only if the transaction is successfully executed else rollback

7. Security :

           Verify the security for database,,, like who is given access and what are the permissions

8. Performance

                Check the performance of the database in retrieving the data

 Correctness and completeness of data migration (in case some or all the original data has come from another source)

Check the performance  of query execution times, throughput etc.

 
verify the performance when multiple users access same data..etc

Additionally you can also check

Data Replications

Data Migrations