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

7
votes
3answers
8k 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 ...
4
votes
3answers
3k 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 ...
3
votes
2answers
2k 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
3
votes
1answer
719 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 ...