Manual testing 25 - What is Database testing? Types of Database testing | Tools for database testing

What is Database testing?

Database Testing.
Database Validations.
How to test the Database.
Steps to do Database testing
Types of Database Testing
Tools for Database Testing
Advantages of Database Testing
Possible interview questions on database testing

Database Testing
Database testing is retrieved values from the database by the web or desktop application
Database testing is one of the major testing which requires tester to expertise in checking tables, writing queries and procedures.

Database validation

• Data mapping.
Data mapping is a part of the database testing. It focuses on validating the data traversing backend forth from the application to the backend database.

• ACID (Atomicity, Consistency, Isolation, Durability) properties validation.
ACID is an acronym for Atomicity, Consistency, Isolation, and Durability.

• Data Integrity. This means that any of the create, retrieve, upgrade and delete operations, the updated and most recent values of shared data should appear on all the screens.

• Business Rule Conformance: The complexity in databases means more complicated components like relational constraints, triggers, stored procedures, etc. So, testers will have to come up with appropriate SQL queries in order to validate these complex objects.

How to test the Database

A tester should have a basic level of understanding of database concepts like SQL commands like
DDL: Uses CREATE, ALTER, RENAME, DROP and TRUNCATE to handle tables.
DML: Includes statements to add, update and delete records.
DCL: Grant and Revoke are the two statements used.

The following are the steps to do database testing

1) Prepare the environment
2) Run a test
3) Check test result
4) Validate according to the expected results
5) Report the findings to the respective stakeholders

Types of Database Testing
• Functional Testing: It is used to check the functionality of database from user point of view. The types of Functional testing are White box and black box testing.
• Non-Functional Testing: It is used to test load-testing, risk testing in database, stress testing and deals with the performance of the database.
• Structural Testing: It deals with table and column testing, schema testing, stored procedures and views testing, checking triggers, etc.
Tools for Database testing
• Test Data Generator
• Data Generator
• Data Factory
• TurboData
• SQLUnit
• DBUnit

Advantages of Database testing
1. Several issues or bugs can be efficiently discovered in the initial development position.
2. Database testing on the other hand in black box testing we test the functionality of the software or application without any code review.

Possible interview questions on database testing

What is Database Testing.
What are Database Validations.
How to test the Database.
Which are the Steps to do Database testing
Which are the Types of Database Testing
Which are the tools for Database Testing
What are Advantages of Database Testing

ankpro
ankpro training
C#
C sharp
Bangalore
Rajajinagar
Selenium
Coded UI
Mobile automation testing
Mobile testing
JQuery
JavaScript
.Net
C
C++
Components of the .Net framework
Hello World
Literal
Keywords
Variable
Data types
Operators
Branching
Loops
Arrays
Strings
Structures
Enums
Functions