What is backend testing, and is the knowledge of RDBMS like Oracle and SQL server a must for a tester.....Do let me know,
Thanks in advance.
Re: Backend Testing
Backend testing is simply database testing. In the simplist form the technique is: input data through the UI and check the DB to confirm.
An automated approach would be to have an automation tool such as WinRunner input data then programmatically perform an SQL statement on the DB to confirm. Same thing as mentioned first, only the method is automated.
There's also constraint testing which validates data integrity. Business logic can also be tested (assuming that this is occuring at the DB level and not within the code)
As far as knowing RDBMS or entity relationships, it's probably good to get a basic understanding of this since you my want to get data out of the database! Being able to read a ER Diagram and then writing the SQL would be a significant skill to obtain.
Hope this helps. I don't know of any books out there for this type of testing. Not sure if it's a taboo for some testers or if it's just a "no brainer" or if it just doesn't get done.
Soli Deo Gloria!
Re: Backend Testing
A lot of testers don't want to touch anything deeper than the GUI interface. I would consider being able to do simple queries and find information in a database to be an essential skill. If you learn how to insert, delete, update, simple joins, where, like, AND, OR, count and sum you should be ok. Simple stuff like that. This is really useful, here's an example. Suppose that you're on a GUI screen and you know that you should be looking at a list of companies in Texas. You would just run this statement in a query analyzer:
select count(*) from company where (State = 'Texas')
That would tell you how many you should be seeing on the screen. Of course, they can get a bit more complicated, too ;-D:
SELECT COUNT(*) AS Expr1, Tbl_LotSet_Label.Label_Type, Tbl_Tool.Fab_Id
FROM Tbl_LotRun INNER JOIN
Tbl_Tool ON Tbl_LotRun.Tool_Id = Tbl_Tool.Tool_Id INNER JOIN
Tbl_LotSet_Label ON Tbl_LotRun.LotRun_Gen_Key = Tbl_LotSet_Label.LotRun_Gen_Key
WHERE (Tbl_LotRun.Tool_Id = '3013')
GROUP BY Tbl_LotSet_Label.Label_Type, Tbl_Tool.Fab_Id
I did that last one using MSSQL Query analyzer. It took about 20 seconds to click on the boxes and select the data I wanted to see. There's not much to it if you can find someone to show you the basics.