Monday, December 01, 2014

DATA BASE TESTING

DATA BASE TESTING

What is Database Testing?

Database testing involves the retrieved values from the database by the web or desktop application. Data in the User Interface should be matched as per the records are stored in the database.

Database Testing Validations

The following verifications are carried out during database testing:

  • Checking the data mapping.
  • ACID (Atomicity, Consistency, Isolation, Durability) properties validation.
  •  Data Integrity
  •  Business rule conformance

User-Interface testing
Database or Data testing
This type of testing is also known as Graphical user Interface testing or Front-end Testing.
This type of testing is also known as Back-end Testing or data testing.
This type of testing chiefly deals with all the testable items which are open to the user for viewership and interaction like Forms, Presentation, Graphs, Menus, and Reports etc. (created through VB, VB.net, VC++, Delphi - Frontend tools )
This type of testing chiefly deals with all the testable items which are generally hidden from the user for viewership. These include internal process and storage like Assembly, DBMS like Oracle, SQL Server, MYSQL etc.
This type of testing include validating the
  • text boxes,
  • select dropdowns,
  • calendars and buttons,
  • navigation from one page to another,
  • display of images as well as
  • Look and feel of the overall application.

This type of testing involve validating
  • the schema ,
  • database tables ,
  • columns ,
  • keys and indexes ,
  • stored procedures ,
  • triggers ,
  • database server validations ,
  • validating data duplication ,

The tester must be thoroughly knowledgeable about the business requirements as well as the usage of the development tools and the usage of automationframework and tools.
The tester in order to be able to perform back end testing must have strong background in database server and Structured Query Language concepts.

DEMO 


Try Our Free Demo Today! call +91-9494646355

ON JOB SUPPORT:


We provide technical assistance for six months. So, if you have any query even while working you can always get back to us.


No comments:

Post a Comment