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.
1
vote
1answer
81 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 ...
3
votes
3answers
379 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
717 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 ...
3
votes
3answers
326 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
2answers
181 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 ...
4
votes
2answers
909 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
1answer
481 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
2k 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 ...
