Results 1 to 6 of 6

Thread: SQL Queries for Database Testing

  1. #1
    diana15aug
    Guest

    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


  2. #2
    Junior Member
    Join Date
    Jun 2007
    Answers
    3

    Re: SQL Queries for 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


  3. #3

    Re: SQL Queries for Database Testing

    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.


  4. #4
    Junior Member
    Join Date
    May 2006
    Answers
    2

    Re: SQL Queries for Database Testing

    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?


  5. #5

    Re: SQL Queries for Database Testing

    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


  6. #6
    Junior Member
    Join Date
    Mar 2008
    Answers
    1

    Re: SQL Queries for Database Testing

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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact