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 ...
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 ...
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
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 ...