SQL Queries for Database Testing

Do we have to write SQL queries in the test cases related to Database testing if yes give me an example and explain if no explain me the process of Database testing

We need to write the SQL queries in the test case document.

Suppose you have to test the Maturity date of a fixed deposit table.

Then the query would be
select dep_type, depstr_Name, deps_matu_date from deps_table

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, we have to pull the records from the database and validate it against the reports or the flat files generated. In this case, the records are retrieved by the Data Manipulation language in SQL. Hence, definitely we need to write SQL queries in order to perform database validation.

For example, you are entering the values in the front-end of the application and saves it. Then it will be automatically stored in the backend. You will also be generating reports for the data entered in the front end. There will set of guidelines for example, in an Insurance application you need to pull the report of the Policy information which were created after 2007. The report pulled is validated against the database by retrieving the records by the use of SQL queries. All the Policies created after 2007 will be pulled by the use of Select query and will be validated against the report generated.

Hi please help me the importance of data base testing and stored procedures?as a test engineer upto what level we should know the db 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, we have to pull the records from the database and validate it against the reports or the flat files generated.

As a Test engineer to validate the Database you should have very strong knowledge of using the Select statement. As most of the times you will be retriving the records from the data base to validate against the Report or the flat file generated, you should know how to use Joins, Union and other operators along with the Select statement. Since to validate the reports or flat file the data should be pulled from two or more tables, the usage of the join or union along with Select statement is more important.

Ganesan

s...............