All IT Courses 50% Off
QA Tutorials

Database Testing with Examples

Database is collection of information. The database application resides on database servers. The database development team. The database servers are setup and managed by database administrators. Sometimes, the role of database developers and database administrators is played by the same team. The concept of database testing includes processing of database connection, executing queries, fetching data and disconnecting database instances. The database testing is performed by QA team, usually alone with functional testing.

The technical implications which are associated with automated database testing considering few scenarios where the database testing is performed with automated testing. Database testing is performed precisely which is called as testing application in conjunction with database in order to ensure that the changes. We are required to make sure the data entered from the UI is consistently reflected in the database. Thus we retrieve the information from the database and the database retrieved is verified against the information supplied by the UI. 

Database testing: Example 1

Consider an example of filling the registration forms, user data and user profiles which updates and deletes the user data. Thus there is a test scenario to automate which can be verified by the user’s information that is successfully saved into the database as soon as the user registers in the  application. 

Database testing: Example 2

Another example of database testing, which performs the associative database testing. Assume that we performed an operation on the application’s UI and we want to test the reflection in the database that may be case which is impacted as data resides in various tables of the database due to the association. It is advisable to test, the data reflection at all the impacted areas. 

Database testing: Example 3:

To test the same bank money transfer:

step 1: check the balance of account A & B. e.g.: A = 500, B = 600

step 2: transfer money using the UI, account A to B, 200

step 3: again check the balance of account A & B. After successful transaction, account A is deducted by 200 and account B is credited by 200 e.g.: A = 300, B = 800

Language used to interact with the database while database testing: 

SQL : Structured Query Language

Tools used for viewing the data in the database:

eg: Toad data point, MS SQL server management studio, Oracle editors etc

Database testing is performed by Software testing team.

An automation testing tool, like Selenium, as said simulates the user interactions with the applications under test.it can simulate keyboard events, mouse actions etc. When the user desires to automate anything outside the vicinity of browser- web application interactions, then selenium can’t be of much help. We may require other tools for end-to-end database testing. 

Thus in all above scenarios, we may perform database testing along with the UI automation. The database testing is verification of values in database accepted through web or desktop application. As software industry gets more advanced, the applications gets more complex. So testing various parameters are required.

Facebook Comments
Tags

5 Comments

  1. Database is collection of information. The concept of database testing includes processing of database connection, executing queries, fetching data and disconnecting database instances. The database testing is performed by QA team, usually alone with functional testing.Database testing is performed precisely which is called as testing application in conjunction with database in order to ensure that the changes are required to make sure the data entered from the UI is consistently reflected in the database.
    Language used to interact with the database while database testing:
    SQL : Structured Query Language

    Tools used for viewing the data:
    Toad data point, MS SQL server management studio, Oracle editors etc.

    The database testing is verification of values in database accepted through web or desktop application. As software industry gets more advanced, the applications gets more complex. So testing various parameters are required.

  2. Database is collection of information. The database application resides on database servers. The database servers are setup and managed by database administrators. Sometimes, the role of database developers and database administrators is played by the same team. The concept of database testing includes processing of database connection, executing queries, fetching data and disconnecting database instances. The database testing is performed by QA team, usually alone with functional testing.
    Database testing is performed by Software testing team. Tools used for viewing the data in the database are Toad data point, MS SQL server management studio, Oracle editors etc.

  3. Database Testing is a type of software testing that checks the schema, tables, triggers, etc. of the Database under test. It also checks data integrity and consistency. It may involve creating complex queries to load/stress test the Database and check its responsiveness.

  4. Database is collection of information. The database application resides on database servers. The database development team. The database servers are setup and managed by database administrators. The concept of database testing includes processing of database connection, executing queries, fetching data and disconnecting database instances. The database testing is performed by QA team, usually alone with functional testing.
    Database testing is performed precisely which is called as testing application in conjunction with database in order to ensure that the changes. We are required to make sure the data entered from the UI is consistently reflected in the database. Thus we retrieve the information from the database and the database retrieved is verified against the information supplied by the UI.
    Language used to interact with the database while database testing: SQL : Structured Query Language
    Tools used for viewing the data in the database are Toad data point, MS SQL server management studio, Oracle editors etc

  5. Database is collection of information. The database application resides on database servers. The database development team.The database testing is performed by QA team, usually alone with functional testing.Database testing is performed by Software testing team. An automation testing tool, like Selenium, as said simulates the user interactions with the applications under test.it can simulate keyboard events, mouse actions etc. When the user desires to automate anything outside the vicinity of browser- web application interactions, then selenium can’t be of much help. We may require other tools for end-to-end database testing.
    Database testing: Example:
    To test the same bank money transfer:
    step 1: check the balance of account A & B. e.g.: A = 500, B = 600
    step 2: transfer money using the UI, account A to B, 200
    step 3: again check the balance of account A & B. After successful transaction, account A is deducted by 200 and account B is credited by 200 e.g.: A = 300, B = 800
    Language used to interact with the database while database testing:
    SQL : Structured Query Language
    Tools used for viewing the data in the database:
    eg: Toad data point, MS SQL server management studio, Oracle editors In Database testing mainly we cover 3 things :-
    1.We validate the existence of values in the database table.
    2.We validate the correctness of value in the database table.
    3.We validate completeness of value in the database table.
    Database testing is performed by Software testing team.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Articles

Back to top button
Close
Close