Introduction to Database Testing


Introduction to Database Testing

1) What is Database Testing?

2) Functional Testing and Database Testing

3) How to Conduct Database Testing?
a) Manual Testing
b) Automated 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...)

Manual Testing, Automated Testing

a) Manual 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...
--------------------------------------------
b) Automated 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.
-------------------------------------------------
Automated Testing (Using Selenium)

Using sql jar communicate with Databases and using SQL Commands we can conduct database testing.
---------------------------------------------------
SQL Tutorial

Related Posts:

SQL Interview Questions and Answers

SQL Queries Examples

0 comments:

Post a Comment