What is database testing and what we test in database testing?
Database testing is all about testing joins, views, inports and exports , testing the procedures, checking locks, indexing etc. Its not about testing the data in the database.
Usually database testing is performed by DBA. Database testing involves some in depth knowledge of the given application and requires more defined plan of approach to test the data.
Key issues include :
A) Data Integrity
B) Data Validity
C) Data Manipulation and updates
Tester must be aware of the database design concepts and implementation rules.
Data bas testing basically include the following.
A)Data validity testing.
B)Data Integritity testing
C)Performance related to data base.
D)Testing of Procedure,triggers and functions.
for doing data validity testing we should be good in SQL queries. For data integrity testing you should know about referintial integrity and different constraint. For performance related things you should have idea about the table structure and design. For testing Procedure triggers and functions we should be able to understand the same.