We can do database testing in three ways(appraoch)
              1.From front end GUI  
              2.Purely on back end
              3.Using both front end and back end

In the case of  database testing frm front end,
            It is very easy no need of SQL querying skills, 
directly we will enter the data in to database and again
we will call them from front end.

Here the data which is entered into front end GUI should 
store properly in the back. 

if in the case there is no GUI for that software,no way we 
have go for pure back end database testing.

To conduct database testing one must know SQL knowledge
to write query for data insertion,updation,deletion...like
DML,DDL,DCL commands , Stored procedures,views knowledge
to test databse.
Third one is more reliable hybrid and time taking process.

Writing of tescases varies depending on the approach of 
database testing.

to write test cases on database input is 
          databse structure tables,
          constraints,
          relation betwee the tables we need.

ok friends byeeeee
rajendra
rajendra_penumalli@yahoo.com
hyderbad
+91-9885162742