Database Testing Tutorial : Why ,How and What With Sample Test Cases


 Database Testing Tutorial: How to Test Database?

What is Database Testing?
Database Testing is a type of software testing in which test engineers test the schema, tables, triggers, etc. of the Database under test. Database testing also includes performing data validity, data integrity testing, and performance checks related to the database.

Types of Database Testing
Below the list of database testing are given.
  • Structural Database Testing
  • Functional Testing
  • Nonfunctional Testing
Lets, Understand each type one by one.

Structural Database Testing
Structural Database Testing is a database testing technique that deals with table and column testing, schema testing, stored procedures and views testing, Checking triggers, etc.
  • Schema / Mapping Testing
  • Stored Procedures and Views Testing
  • Trigger Testing
  • Tables and Column testing
  • Keys and indexes testing
  • Database Server Check
Functional Testing
Functional Database Testing is a type of database testing that is used to validate the functional requirements of a database from the end-user’s perspective.
  • Check that the field is mandatory while allowing NULL values on that field? 
  • Check that the length of each field is of sufficient size?
  • Check that all similar fields have the same names across tables? 
  • Check that there are any computed fields present in the Database?

Non-functional Testing
Non-functional Testing is a database testing technique that load-testing, risk testing in the database, stress testing, minimum system requirements, and dealing with the performance of the database.

Here some of the important parts of non-functional database testing are listed below:
  • Load testing 
  • Stress Testing 
  • Security Testing 
  • Usability Testing 
  • Compatibility Testing

What to Test in Database Testing (checklist)?
  • Transaction 
  • Database Schema
  • Trigger
  • Stored Procedure (SP)
  • Constraints
  • Table and Column

How to Test Database?
General Steps for database testing are listed below.
  • Step 1) Prepare the environment 
  • Step 2) Run a test 
  • Step 3) Check test result 
  • Step 4) Validate according to the expected results 
  • Step 5) Report the findings to the respective stakeholders
Database Testing Tools
Some of the important database testing tools are listed below.

  • Database Benchmark 
  • Database Rider 
  • Db stress 
  • DbUnit 
  • DB Test Driven 
  • HammerDB 
  • JdbcSlim JDBC (Java DataBase Delta Testing) 
  • Nbi 
  • NoSQLMap 
  • NoSQLUnit 
  • ruby-plsql-spec 
  • SeLite 
  • sqlmap 
  • tSQLt 
  • Tsung 
  • utPLSQL
What is ACID properties validation in database testing?
  • Atomicity
  • Consistency
  • Isolation
  • Durability

Test Cases for Database Testing: Database Testing Scenarios

Here, Important Test cases for database testing are given...
  • Verify whether data getting saved in the database column properly or not when the user clicks on the save button.
  • Check that the data is saved in a defined column and table or not. 
  • Verify the database name.
  • Verify the name of the log file. 
  • Verify the disk space allocation for databases. 
  • Verify the names of all tables, columns, and their types. 
  • Verify the null value checks. 
  • Verify the keys (primary/foreign), indexes, and data types of columns used.
  • Verify the primary key for the table is created or not.
  • Data should be rolled back in case of failed transactions.

Hope!!! The above Tutorial on Database testing is helpful for you...

QA acharya

Tags: Database testing tutorial with example, Test case for database testing, Database testing test cases, tool for database testing.

Databases Testing Tutorials


Post a Comment