Now we know the Database Testing which you can learn in my last article. In this article we will discuss about the steps that need to following to test any Database.
Database Tester should have some basic knowledge regarding SQL Command like DDL (create/drop), DML (Insert/Delete/Update) and DCL (Grant/Revoke).
DDL (Data Definition Language): DDL is the Computer language used to create and delete the Database object in the Database. Database Object like Tables, Indexes and Users. Common DDL statements are CREATE, ALTER, DROP
DML (Data Manipulation Language): DML Statement used to Create, Add, Update and Delete data in the Database. DML command Like SELECT, UPDATE, INSERT INTO and DELETE FROM.
DCL (Data Control Language): DCL Statements are useful to control access to data stored in Database means DCL statement create privilege to allow user access to perform modification in Database. DCL command is like GRANT(to provide permission) and REVOKE ( to remove permission).
Now below are the steps to test the Database
1. Create an Environment
Tester need to create the setup for testing the database. Tester can create a copy of production Database or create a new Test Database with exactly same information that have production Database. Hardware characteristics should be same and DBMS should be same version of production Database.
2. Run the Test Cases
A Database tester can check the Database from UI by insert, Update and Delete the Value from UI. Tester can also be check the database by performing CRUD operation in Database. Tester can also check the Triggers, Stored Procedure also to track the Operation, Databases changes and keep track on are change performing correct or not.
3. Verify Test Result
After performing all the Test cases, Tester can check the Fail Test cases.
4. Validate Test Result
Tester can validate that the performing Test cases impact on Right Tables or Not.
5. Reporting
At last gather all the results and prepare a report for your Manager, Company, Stakeholder and others who are connected with the software.
Database Tester should have some basic knowledge regarding SQL Command like DDL (create/drop), DML (Insert/Delete/Update) and DCL (Grant/Revoke).
DDL (Data Definition Language): DDL is the Computer language used to create and delete the Database object in the Database. Database Object like Tables, Indexes and Users. Common DDL statements are CREATE, ALTER, DROP
DML (Data Manipulation Language): DML Statement used to Create, Add, Update and Delete data in the Database. DML command Like SELECT, UPDATE, INSERT INTO and DELETE FROM.
DCL (Data Control Language): DCL Statements are useful to control access to data stored in Database means DCL statement create privilege to allow user access to perform modification in Database. DCL command is like GRANT(to provide permission) and REVOKE ( to remove permission).
Now below are the steps to test the Database
1. Create an Environment
Tester need to create the setup for testing the database. Tester can create a copy of production Database or create a new Test Database with exactly same information that have production Database. Hardware characteristics should be same and DBMS should be same version of production Database.
2. Run the Test Cases
A Database tester can check the Database from UI by insert, Update and Delete the Value from UI. Tester can also be check the database by performing CRUD operation in Database. Tester can also check the Triggers, Stored Procedure also to track the Operation, Databases changes and keep track on are change performing correct or not.
3. Verify Test Result
After performing all the Test cases, Tester can check the Fail Test cases.
4. Validate Test Result
Tester can validate that the performing Test cases impact on Right Tables or Not.
5. Reporting
At last gather all the results and prepare a report for your Manager, Company, Stakeholder and others who are connected with the software.
Comments
Post a Comment