Structured Query Language (SQL) is a language for managing data in relational database management systems. This tag is for general SQL programming questions; it is not for Microsoft SQL Server, nor does it refer to specific dialects of SQL on its own.

learn more… | top users | synonyms

6
votes
4answers
5k views

What proficiency should a software tester have in SQL?

Both in my current job and in my previous job, there are a number of areas of the application to test that require mining data from a relational database, specifically Microsoft SQL Server of various ...
4
votes
4answers
188 views

Is it necessary to verify databases for functional automation testing?

Currently, after every action that adds or changes data, we verify that that data was successfully added/changed in the database by querying the tables directly. I feel this is redundant because that ...
4
votes
3answers
916 views

MS-SQL server sql test automation

I'm looking to create a batch of automated tests in SQL on MS-SQL server, these will include tests like - insert some records, call stored procedure, check certain conditions in various tables. There ...
4
votes
2answers
1k views

What resources will help me understand the data model for QC 10.0 in order to write my SQL queries?

I am a fresher in Quality Center 10.0 HP software testing tool. As per my understanding in order to generate reports from QC and to troubleshoot the scenarios, we need to write SQL queries in the QC ...
3
votes
3answers
1k views

What does a Sofware QA Person Need to Know to Perform Their Job (Essentially)?

I'm doing everything I can to learn about Software QA and Software Testing. I've got a decent understanding of SQL and I'm applying that to MySql as that seems to be the most popular. I understand ...
3
votes
1answer
347 views

How to test an Excel macro that selects, groups, and counts data using SQL query?

This is the first time I encountered such a problem. There is an Excel table with a macro that selects data from the database using SQL query according to specific criteria. Data is grouped in ...
2
votes
2answers
745 views

Comparing Sqlite databases

I would like to compare Sqlite databases with each other, both schema and data. I know that a rather crude method exists by comparing the database dumps with each other. But are ther any other methods ...
2
votes
2answers
795 views

data warehouse testing checklist

what are some best practice approaches such as: SCD type 1/2/3 nulls duplicates missing data extra data special characters FK/PK referential integrity.etc
1
vote
2answers
2k views

Find the bugs related to test a run in Quality Center via database query

I'm able to query a HPQC database to retrieve execution information from the TEST and STEP tables. I'm also able to query for defect information from the BUG tab. But, I'm struggling to find a way ...
1
vote
1answer
34 views

Simulating realistic latency to a WAN SQL server

Context: Our desktop application communicates with a SQL server, some clients use a WAN connection to reach this SQL server. When they complain something is very slow we ask a list of ping times to ...
1
vote
2answers
45 views

Tool for verifying MySQL data matches source file

I'm looking for an automated way to test an API to ensure incoming data is stored correctly in a MySQL db. Starting with an empty db I send large amounts of XML to the API which populates the db. ...
1
vote
1answer
128 views

Loading test data from MySQL database

I use Ruby with Selenium to do test automation on a web application that has a MySQL DB behind it. I need a good way to load data into the DB from a Ruby script. So far in my research I have found ...