All IT Courses 50% Off
QA Tutorials

Database Testing

Every software very application is associated to the database. The database is maintained using a DBMS like MySQL, Oracle or any other DBMS to store all its data. Selenium Web Driver is used for testing web applications and operations are performed like submitting information, retrieving data and validating them. When there is a need of getting data from the database in selenium scripts, we may use API’s which help to interact with database like JDBC.

Database Testing:

Database is used for a long period data storage, standard and organised way of storing process. Parts of database are data and schema. 

What is data?

Data is information of an entity. Data is stored in table format as rows and columns. Eg: Here we can see the organized structure of data in the form of table ‘Customers’ in MySQL.

Database Testing

What is Schema?

Schema contains tables, columns, views, functions, triggers and stored procedures.

Database Testing

How to test the Schema?

We can test schema by selecting design in tables. The name of every column or field should be appropriate neither too short or neither too long and all the data should match the data type. Check if the primary key is unique.

Database Testing

How to test a view?

View is a section of data from a table. The below is a view which shows the order of the customers which can be tested by opening the view design. The name of the view is orderedProducts.

Database Testing
Database Testing

The design of view shows the products ordered by the customers with the help of information produced by two tables ‘Products’ and ‘Orderdetails’

The join in the query above shows the intersection of ‘Products’ table and ‘Orderdetails’ table and finds those products which are present in ‘Orderdetails’ table. When it is executed the result displayed as

Database Testing

For database testing we have to write queries. To test view we have to write a new query, use Select statement check.

Database Testing

Now check stored procedures

We have a name called  deletecustomer stored procedures.

Database Testing

Insert a customer details in the table using Insert query

Database Testing

Test the ‘deletecustomer’ stored procedure by providing the query of delete. Provide the customer id as 4, then execute the statement, the customer id 4 is deleted. Then check the table data using select statement.

Database Testing
Facebook Comments

12 Comments

  1. Database Testing: Database is used for a long period data storage, standard and organised way of storing process.
    Parts of database are data and schema.
    Data is information of an entity. Data is stored in table format as rows and columns. Schema contains tables, columns, views, functions, triggers and stored procedures.

  2. Data is information of an entity. Data is stored in table format as rows and columns. Schema contains tables, columns, views, functions, triggers and stored procedures. Database is used for a long period data storage, standard and organised way of storing process. Parts of database are data and schema.

  3. Database testing includes performing data validity, data integrity testing, performance check related to database and testing of procedures, triggers and functions in the database.

  4. Database Testing:
    Database is used for a long period data storage, standard and organised way of storing process. Parts of database are data and schema.
    Data:
    Data is information of an entity. Data is stored in table format as rows and columns.
    Schema:
    Schema contains tables, columns, views, functions, triggers and stored procedures.
    How to test the Schema?
    We can test schema by selecting design in tables. The name of every column or field should be appropriate neither too short or neither too long and all the data should match the data type. Check if the primary key is unique.

    What is a view?
    View is a section of data from a table.

  5. – Database is used for a long period data storage, standard and organised way of storing process. Parts of database are data and schema.
    1. Data: Data is information of an entity. Data is stored in table format as rows and columns.
    2. Schema: Schema contains tables, columns, views, functions, triggers and stored procedures.

  6. Database is used for a long period data storage, standard and organised way of storing process. Parts of database are data and schema.
    Data is information of an entity. Data is stored in table format as rows and columns. Eg: Here we can see the organized structure of data in the form of table ‘Customers’ in MySQL.
    Schema contains tables, columns, views, functions, triggers and stored procedures.

  7. Every software application is associated to the database. The database is maintained using a DBMS like MySQL, Oracle or any other DBMS to store all its data .Database is used for a long period data storage, standard and organised way of storing process. Parts of database are data and schema.
    Selenium Web Driver is used for testing web applications and operations are performed like submitting information, retrieving data and validating!

  8. Every software very application is associated to the database. The database is maintained using a DBMS like MySQL, Oracle or any other DBMS to store all its data. Selenium Web Driver is used for testing web applications and operations are performed like submitting information, retrieving data and validating them. When there is a need of getting data from the database in selenium scripts, we may use API’s which help to interact with database like JDBC.

  9. Database is used for a long period data storage, standard and organised way of storing process. Parts of database are data and schema.
    What is data?
    Data is information of an entity. Data is stored in table format as rows and columns.
    Eg: Here we can see the organized structure of data in the form of table ‘Customers’ in MySQL.
    What is Schema?
    Schema contains tables, columns, views, functions, triggers and stored procedures.
    How to test the Schema?
    We can test schema by selecting design in tables. The name of every column or field should be appropriate neither too short or neither too long and all the data should match the data type. Check if the primary key is unique.
    How to test a view?
    View is a section of data from a table. The below is a view which shows the order of the customers which can be tested by opening the view design. The name of the view is ordered Products.
    1. The design of view shows the products ordered by the customers with the help of information produced by two tables ‘Products’ and ‘Orderdetails’
    2. The join in the query above shows the intersection of ‘Products’ table and ‘Orderdetails’ table and finds those products which are present in ‘Orderdetails’ table. When it is executed the result displayed as
    For database testing we have to write queries. To test view we have to write a new query, use Select statement check.
    Now check stored procedures
    We have a name called deletecustomer stored procedures.
    1. Insert a customer details in the table using Insert query
    2. Test the ‘deletecustomer’ stored procedure by providing the query of delete. Provide the customer id as 4, then execute the statement, the customer id 4 is deleted. Then check the table data using select statement.

  10. Database is used for a long period data storage, standard and organized way of storing process. Parts of database are data and schema.
    Data is information of an entity. Data is stored in table format as rows and columns. Eg: Here we can see the organized structure of data in the form of table ‘Customers’ in MySQL.

  11. Database is used for a long period data storage, standard and organized way of storing process. Parts of database are data and schema. Every software application is associated to the database. The database is maintained using a DBMS like MySQL, Oracle or any other DBMS to store all its data. Selenium Web Driver is used for testing web applications and operations are performed like submitting information, retrieving data and validating them. When there is a need of getting data from the database in selenium scripts, we may use API’s which help to interact with database like JDBC.
    What is data?
    Data is information of an entity. Data is stored in table format as rows and columns. Eg: Here we can see the organized structure of data in the form of table ‘Customers’ in MySQL.
    What is Schema?
    Schema contains tables, columns, views, functions, triggers and stored procedures.
    How to test the Schema?
    We can test schema by selecting design in tables. The name of every column or field should be appropriate neither too short or neither too long and all the data should match the data type. Check if the primary key is unique.
    How to test a view?
    View is a section of data from a table. The below is a view which shows the order of the customers which can be tested by opening the view design. The name of the view is ordered Products The design of view shows the products ordered by the customers with the help of information produced by two tables ‘Products’ and ‘Order details’
    The join in the query above shows the intersection of ‘Products’ table and ‘Order details’ table and finds those products which are present in ‘Order details’ table. When it is executed the result displayed as For database testing we have to write queries. To test view we have to write a new query, use Select statement check. Now check stored procedures
    We have a name called delete customer stored procedures.

  12. Every software very application is associated to the database. The database is maintained using a DBMS like MySQL, Oracle or any other DBMS to store all its data. Selenium Web Driver is used for testing web applications and operations are performed like submitting information, retrieving data and validating them. When there is a need of getting data from the database in selenium scripts, we may use API’s which help to interact with database like JDBC.
    Database Testing:
    Database is used for a long period data storage, standard and organized way of storing process. Parts of database are data and schema.
    What is data?
    Data is information of an entity. Data is stored in table format as rows and columns. Eg: Here we can see the organized structure of data in the form of table ‘Customers’ in MySQL.

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

Get Python Course
worth 499$ for FREE!

Offer valid for 1st 20 seats only, Hurry up!!

You have successfully subscribed to the newsletter

There was an error while trying to send your request. Please try again.

H2kinfosys Blog will use the information you provide on this form to be in touch with you and to provide updates and marketing.