Entries Tagged 'Database Testing' ↓

ETL vs. DB Testing – A Closer Look at ETL Testing Need, Planning and ETL Tools

Software testing has the variety of areas to be concentrated. Major varieties are functional and non-functional testing. Functional testing is the procedural way to ensure so that the functionality developed works as expected. Non-functional testing is the approach by which the non-functional aspects like enhanced or performance at an acceptable level can be ensured.

There is another flavour of testing called DB testing. Data is organized in the database in the form of tables. For business, there can be flows where Continue reading →

All About Database Testing – Why to Test, How to Test, and What to Test?

Database Testing Guide:

Computer applications are more complex these days with technologies like Android and also with lots of smartphone apps. The more complex the front ends, the more intricate the back ends become.  So it is all the more important to learn about DB testing and be able to validate databases effectively to ensure security and quality databases.

In this article, you will learn all about Database Testing. Why test- How to test- What to test.

Why do we test a database?

Below, we will see why the following aspects of a DB should be validated:

Continue reading →

180+ Sample Test Cases for Testing Web and Desktop Applications – Comprehensive Testing Checklist

This is a Testing Checklist for both webs as well as desktop applications.

Note – This article is a little lengthy one (over 2700 words). However, my goal is to share one of the most comprehensive testing checklist ever written and this is not yet done. I’ll keep updating this post in the future as well with more scenarios. If you don’t have time to read it now, please feel free to share this with your friends and bookmark it for later.

Make testing checklist as an integral part of your test case writing process. Using this checklist, you can easily create hundreds of test cases for testing web or desktop applications. Continue reading →

ETL Testing / Data Warehouse Testing – Tips, Techniques, Process and Challenges

ETL Testing Process and Challenges:

Today let me take a moment and explain my testing fraternity about one of the much in demand and upcoming skills for my tester friends i.e. ETL testing (Extract, Transform, and Load).

This article will present you with a complete idea about ETL testing and what we do to test ETL process.

Continue reading →

Database Testing – Properties of a Good Test Data and Test Data Preparation Techniques

A couple of months ago, I wrote about database testing strategies. It covered the aspect that is entirely related to the execution of test cases. It was all about the black-box testing of a database. There is another important aspect of DB testing activity which we will cover in this article.

Let us take a scenario here:

As a tester, you have to test the ‘Examination Results’ module of the website of a university. Consider that the whole application has been integrated and it is in ‘Ready for Testing’ state. ‘Examination Module’ is linked with ‘Registration’, ‘Courses’ and ‘Finance’ modules.

Continue reading →