SQL for QA: Tutorial#14 – Triggers
Triggers are nothing but action / set of actions performed on Tables or Views when Insert / Delete / Update or Truncate queries are executed. What kind of Actions , Table or View Name and on which
Software Testing Archive
SQL for QA: Tutorial#13 – Stored Functions
Testing team uses Stored Functions very often to test complex functionalities, mainly where lot of calculations are involved. It is easier to use functions for it than writing long query every time. Banking domain is the one
SQL for QA: Tutorial#12 – Stored Procedure
A Stored Procedure can be used like a modular programming where we must create procedure once, store it and call for several times whenever it is needed. Execution time is fast in stored procedures. Procedures reduce network
SQL for QA: Tutorial#11 – Views
In simple words, View is a ‘Subset’ of one or multiple tables. A View can be a Virtual Table which contains all OR some of the rows and columns of the given table. To create a View one
SQL for QA: Tutorial#10 – Sub Queries
Sub Query is nothing but a nested query or we can say query within a query. Frankly speaking, I have not used sub queries that often in my 10 years of career in Testing / QA. But
SQL for QA: Tutorial#9 – JOIN Clause
JOIN clause is used to combine data from two or more tables, after joining it comes as a single set of data and we can call it Result set. Tables are combined using JOIN clause by using
SQL for QA: Tutorial#8 – UNION Clause
QAs also use UNION clause frequently if need to do through testing of application functionalities with data. By using the UNION operator, we can combine the results of 2 or more SELECT statements and at the same
SQL for QA: Tutorial#7 – GROUP BY Clause
The GROUP BY clause is used to organize identical data into groups often with the help of 5 Aggregate functions ie. COUNT, MIN, MAX, AVG, SUM. GROUP BY clause is used with SELECT statement and it group
SQL for QA: Tutorial#6 – ORDER BY Clause
In SQL, ORDER BY clause is used to sort the records of the table. It is used with SELECT statement. Using this clause, we can sort the data by Ascending or Descending order. By default, ORDER BY
SQL for QA: Tutorial#5 – DELETE Statement
DELETE Statement is used to permanently removes existing records from a given table. Most of the time QAs won’t have permission to perform this command on Development or Production environment. But they can do it on their
SQL for QA: Tutorial#4 – UPDATE Statement
UPDATE Statement is also frequently used by Testers and QAs. UPDATE is used to modify already existing records from the database table. In this article we will see how we can modify single as well as multiple
10 Practical Reasons Why Software Testing / QA is a Good Career Option
If you are fresher and thinking which career to choose? Software Development or Software Testing / QA? Why Software Testing / QA is a good career option? Does Testing have a future? Do Testers get decent Salary?