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

-3
votes
1answer
45 views

Sutable Tool For Quality Assurences [closed]

Please Tell Me Most sutable QA Tool for UI Testing
1
vote
1answer
662 views

Selenium webdriver java with jdbc

I am using selenium webdriver with Java jdbc. Below are my queries. First: I am trying to login to the application with username and password from database (Using SQL Query). I am getting the ...
0
votes
1answer
48 views

Need SQL Injection Document? [duplicate]

i am trying to study SQL Injection nowadays & i am searching for good tutorial . any recommendation for written or videos tutorial ?
0
votes
1answer
85 views

Pre-load database for testing

I'm a bit new to mocking data for testing. I'm using ruby in conjunction with watir-webdriver and I have a local version of the app. I'd like to run a script which empties the tables of the local ...
2
votes
1answer
1k views

Selenium WebDriver (Java) with database [closed]

I want to validate application output result with Database using selenium webdriver (Java). Please let me know how this can be achieved. Or could you please let me know how to use selenium webdriver ...
1
vote
1answer
147 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
3answers
94 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. ...
4
votes
4answers
298 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 ...
1
vote
1answer
167 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 ...
4
votes
3answers
3k 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 ...
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 ...
4
votes
3answers
1k 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 ...
2
votes
4answers
1k 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 ...
3
votes
1answer
454 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 ...
4
votes
2answers
2k 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 ...
2
votes
2answers
1k 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
6
votes
4answers
7k 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 ...