Introduction to Database Testing

Introduction to Database Testing

Introduction to Database Testing, What is Database Testing?, What is SQL?, How to Conduct Database Testing?, and Functional Testing vs. Database Testing.

1) What is Database Testing?
2) Functional Testing and Database Testing
3) How to Conduct Database Testing?
4) Manual Database Testing
5) Automated Database Testing

1) What is Database Testing?

Database Testing is a Test Type in which Data manipulations, Data Integrity, Data Comparison etc… Operations can be verified.

2) Functional Testing and Database Testing

Database Testing is a subset of Functional Testing, also subset of Performance Testing.

3) How to Conduct Database Testing?

We can conduct Database Testing Manually as well as using any Test tool (Ex: UFT/QTP, Selenium etc…), We have three types of Database Testing, Functional Database Testing, Non Functional Database Testing, and Structural Database Testing.

4) Manual Database Testing

> Connect to Database
> Using SQL Commands conduct Database Testing

SQL is a common language to communicate any Database management System
Ex: Oracle, SQL Server, MySQL, Sybase, DB2, DB/400 etc…

Database Test Scenarios

i) Add new Record
ii) Update existing Record
iii) Delete Record
iv) Data Integrity
v) Data Authentication
vi) Data Comparison – Front-end data with Back-end
vii) Data Comparison – Two Resources (Two databases) /Database data with Excel file data
viii) Data backup
ix) Data Recovery etc…

5) Automated Database Testing (Using UFT)

Using UFT Tool feature DataTable you connect to Databases and using SQL Commands conduct Database Testing
Or
Using VBScript Database Objects (Database Connection object and Database Recordset object) connect to any Database (using Database connection String),
and using SQL commands conduct Database Testing.

SQL Tutorial
Database Testing Tutorial for Beginners

6) Automated Database Testing (Using Selenium)

Selenium Webdriver is limited to Testing your applications using Browser.

To use Selenium Webdriver for Database Verification you need to use the JDBC (Java Database Connectivity).

JDBC is a SQL level API that allows you to execute SQL statements. It is responsible for the connectivity between the Java Programming language and a wide range of databases.

you need to the following steps in order to test your Database using Selenium:

i. Make a connection to the Database

ii. Send Queries to the Database

iii. Process the results

Related Posts:

SQL Interview Questions and Answers

SQL Queries Examples

Follow me on social media: