Introduction to Database Testing


Introduction to Database Testing

1) What is Database Testing?

2) Functional Testing too 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 inwards which Data manipulations, Data Integrity, Data Comparison etc... Operations tin dismiss last verified.

2) Functional Testing too Database Testing

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

3) How to Conduct Database Testing?

We tin dismiss bear Database Testing Manually every moment good every moment using whatever Test tool (Ex: UFT/QTP, Selenium etc...)

Manual Testing, Automated Testing

a) Manual Testing

> Connect to Database
> Using SQL Commands bear Database Testing

SQL is a mutual linguistic communication to communicate whatever Database administration System
Ex: Oracle, SQL Server, MySQL, Sybase, DB2, DB/400 etc...

Database Test Scenarios

i) Add novel Record
ii) Update existing Record
iii) Delete Record
iv) Data Integrity
v) Data Authentication
vi) Data Comparison - Front-end information amongst Back-end
vii) Data Comparison - Two Resources (Two databases) /Database information amongst Excel file data
viii) Data backup 
ix) Data Recovery etc...
--------------------------------------------
b) Automated Testing (Using UFT)

Using UFT Tool characteristic DataTable you lot connect to Databases too using SQL Commands bear Database Testing
Or
Using VBScript Database Objects (Database Connection object too Database Recordset object) connect to whatever Database (using Database connectedness String),
and using SQL commands bear Database Testing.
-------------------------------------------------
Automated Testing (Using Selenium)

Using sql jolt communicate amongst Databases too using SQL Commands nosotros tin dismiss bear database testing.
---------------------------------------------------
 Functional Testing too Database Testing Introduction to Database Testing

Related Posts:

SQL Interview Questions too Answers

SQL Queries Examples

Sumber http://www.gcreddy.com/
Post a Comment (0)
Previous Post Next Post