It has been a widely questioned topic that what are the knowledge requirements for a tester to perform data base testing? Well, this depends largely on what the software system or product is.
– It is required that the testers should be savvy with using the product just like the real world users who are sometimes crazy maniacs or lay men who do not have specific knowledge about how to use the product.
– Being a tester, if you keep all this in mind, you should not hesitate to use black box testing techniques as well as white box testing techniques.
– Black box testing techniques does not call for more information than what a normal user has.
– On the other hand white box testing techniques make use of all the information including source code, documentation etc which is of course much greater than what a normal user has.
– You can even apply both in a combination but it is always better to have an understanding of how the implementation of the things actually takes place.
– This idea does not hold from the perspective of a promising development but it does gives hints regarding where the bugs can be, thus solving the complexity of the software system or application.
– There are many things that the testers need to determine on their own depending on what kind of developers have developed the product.
– If you know what you have to test and what your customers will be doing with the product, then you can decide if you need to have knowledge of procedures, SQL, triggers and so on.
– A little extra knowledge about the things can become very handy.
– Most of the people give preference to black box testing but at the same there are 100 arguments regarding the white box testing.
– Therefore, it is advisable to review the differences and determine the overall strategy.
– In most of the cases, skills regarding writing queries are enough and there is no need to know about the data base administration.
– SQL knowledge is not required until and unless it is required to test a data base implementation.
– Testers need to be at par with the users and a little more than that.
– Anything exact about this extra knowledge cannot be said since it based up on what kind of project is to be done. It can be one of the following:
1. A detailed knowledge of the business plan and program.
2. Edge case checking.
3. Experience of what users usually do.
4. Knowledge of various testing tools.
5. Knowledge of SQL.
Why is knowledge of SQL needed?
– SQL might be required for verifying work flow in systems which are automated.
– So, you should be in a state to execute simple SQL queries and read the results.
– When required, testers can be trained about writing and executing simple SQL queries.
– What knowledge is required depends on the situation itself since every software organization has a different way of doing business differently.
– If at the time of testing you start acquiring that extra knowledge you will lose most of your testing time.
– Therefore, it is good to be ready beforehand.
– There are testers who really don’t know anything regarding SQL; it is just that they are trained only for what is actually required.
– If the testers have a strong knowledge of SQL then they can very well write their own code for tests but this can lead to some arguments with the developers.
– There are few reasons why you should know SQL:
1. For writing simple queries.
2. For analyzing a bug without needing a developer at your hand.
3. Understanding what’s possible and what’s not.
4. Improving the quality of testing.