BECAUSE IN ORDER TO RETETRIVE THE FROM DATA BASE

For database testing. Tester has to use Select, insert, 
update and delete queries very often in testing

Hi

Database concepts

1. Database connectivity.
2. Access the data.
3. Data manipulations (Insert, Update, Delete)
4. Data Definition ( Create, Alter, Drop, Rename)
5. Grand Permission or Revoke the Permission.
6. Inter operatability between databases.
    e.t.c..

S.Ramprasad  sun_ramprasad@yahoo.com

Hi ramprasad 
not database concepts why tester should know database 
concepts
please read question carefully

Since every application deals with some kind of database 
operations. To test these operations, tester should have 
the knowledge on concepts

The main concept of Database testing is to validate the
records that are stored in the backend, is as per the
requirements. So in order to validate the records, test
engineer have to pull the records from the database and
validate it against the reports or the flat files generated. 
in short to check database integrity, redundancy etc. a
tester should know database concepts.

Every software product has a data base for saving the data 
whoch is the most important part of any s/w product.
The tester should be aware of the status of the database 
while testing any software product. 

The tester should be able to understand the following 
things :

Database connectivity, Access the data, Data manipulations 
(Insert, Update, Delete, edit), Data Definition ( Create, 
Alter, Drop, Rename), Grand Permission or Revoke the 
Permission, Inter operatability between databases if any.

regards, 
Anil Shinde
anil.shinde@rediffmail.com