Entries Tagged 'Database Testing' ↓

How to Test Oracle Database

Oracle Database Testing – This shall be one of the 3 parts of Oracle Database testing series. We will cover following 3 parts in this database testing series:

#1) Introduction to Oracle Database Testing
#2) Testing the database with respect to Memory, Space and CPU processing
#3) Oracle Real Database Application Testing
Bonus Part #4) How to Test and Validate Your Oracle Database Backup and Recovery?

Let’s start with the Introduction to Oracle Database Testing:
Continue reading →

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 →

Database Testing Guide (Why, How, and What About Database Testing)

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.  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 Tutorial (A Complete Guide)

ETL Testing / Data Warehouse 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 tutorial will present you with a complete idea about ETL testing and what we do to test ETL process.

Complete List Tutorials in this series:  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 →

Database Testing – Practical Tips and Insight on How to Test Database

The database is one of the inevitable parts of a software application these days. It does not matter at all whether it is the web, desktop or mobile, client-server or peer to peer, enterprise or individual business; the database is working everywhere at the backend. Similarly, whether it is healthcare or finance, leasing or retail, mailing application or controlling a spaceship; a database is always in action behind the scene.

Moreover, as the complexity of application increases, the need of stronger and secure database emerges. In the same way, for the applications with a high frequency of transactions (e.g. banking or finance application), the necessity of fully featured DB Tool is coupled. Nowadays, we have big data which is large and complex that the traditional databases can’t handle them.

Continue reading →

How to Test Banking Applications

Banking applications are one of the most complex applications in today’s software development and testing industry.

What makes Banking application so complex? What approach should be followed to test the complex workflows involved in banking applications?

In this article, we will be highlighting different stages and techniques involved in testing Banking applications.

Continue reading →