Software Testing Times - Tutorials, QTP, Manual Testing Automation Testing, Load Runner

(An Article for beginners and fresher testers)

The myths revolving around the field of Software testing that it is a field which does not require any specialisation of any sort as far as skill or talent is concerned has proved to be wrong. It is has in fact become the backbone of every organization now and it is the tester who brings out the maximum portion of revenue to the business due to its capability to find bugs at a stage where if left uncaught could prove really expensive for the business.

Typically, you can find two category of software testers- Black Box and White Box Testers. Being a Black Box tester keeps you away from all the hassles of programming language and you seem to enjoy your work and playing with the application just like the end user does. So it gives you more insight to think about the way the end user can perform his actions and accordingly find the bugs.

White Box testers on the other hand have a life which plays around the programming techniques as well as their capability to analyse more into coding and can be helpful to the development team. There is no difference in the salary anyways as far as differentiating between their categories is concerned. A tester earns the same as any other developer does since they equally play a vital role in the enhancement of the organization.

Life as a Software tester does not seem to be as easy as it appears for the reason that they act as a foundation to any product for their ability to find hidden bugs even under the circumstances when the product appears to be free of bugs. In case, it gets missed by the testers, it the organization who has to borne the losses in terms of money as well as reputation. So as a tester, you need to make sure that you get yourself familiar in depth on the application you intend to work.

With capability of finding bugs at an early stage, a tester if often appreciated for his work without which there would have been thousands of dollars spent unnecessary on doing something which could have been caught by the expertise of the testers. Working for 8-9 hours in an office is as much essential for a tester as it is for a developer.

It can be figured out from above the importance of a Software Tester in an IT industry and his life does not seem to be that much easy as it appears to be.

Guest article by Varun Arora.

Also Read - Why Software Testing is a challenging job?

[Note – This post is for beginners. More details on DB Testing are available here -

More on Database Testing -

• http://goo.gl/GIY7w

• http://goo.gl/ReHsk ]

What is Database Testing?

Database testing involves the tests to check the exact values which have been retrieved from the database by the web or desktop application. Data should be matched correctly as per the records are stored in the database.

How to Test Database?

Database testing is one of the major testing which requires tester to expertise in checking tables, writing queries and procedures. Testing can be performed in web application or desktop and database can be used in the application like SQL or Oracle. There are many projects like banking, finance, health insurance which requires extensive database testing. Below is the discussed point that how to test database:

• First of all, tester should make sure that he understands all the application totally and which database is being used with the testing application.
• Figure out all the tables which exist for the application and try to write all the database queries for the tables to execute since there are many things which are really complex, so you can take the assistance of developers and figure out the queries. Test each and every table carefully for the data added. This is the best process for the testers to perform the DB testing, it can be done for any application and it does not matter application is small or big.
• If things are really complex then tester can obtain the query from the developer to test the appropriate functionality.

Database is the spine of the application and tester should make sure to test very carefully. It requires skill, proficiency and sound knowledge.

What to Test in a Database?

• Check all the functionality which is happening on every action performed in the application. Actions can include deletion, addition or save options. Check whether the added record is added in the DB with the exact value. Check the deleted record gets removed from the database. These are major roles which need to be monitored seriously.
• Nowadays database is getting more complex due to the business logic which plays an important role for the applications. Tester should make sure that values have been added correctly after the implementation of the business rules.

Hence, these are the above mentioned basic things that how and what to test in a database. Database testing is really a complex task and it should always be performed if tester is much experienced in this field.

- Article by Mandeep Singh

More on Database Testing -

• http://www.onestopsoftwaretesting.com/database-testing-tutorials-sql-tutorial-for-testers-backend-testing/
• http://www.softwaretestingtimes.com/2010/04/tutorial-database-testing-using-sql-sql.html