All Topics
›
SQL for Testers
SQL for Testers
SQL tutorials for testers: SELECT, joins, DDL and DML, subqueries, transactions and test data checks.
24
Articles
14
Beginner
5
Intermediate
5
Advanced
SQL Aggregate Functions & Grouping: COUNT, SUM, GROUP BY, HAVING
Learn SQL aggregate functions — COUNT, SUM, AVG, MIN, MAX — plus GROUP BY, HAVING, and WHERE vs HAVING, with clear examples for testers.
SQL Joins Explained: INNER, LEFT, RIGHT, FULL (With Examples for Testers)
SQL joins with examples: INNER, LEFT, RIGHT and FULL JOIN, LEFT vs RIGHT JOIN, finding matching and missing records, and FULL JOIN in MySQL.
SQL SELECT & Filtering: DISTINCT, LIKE, IN, BETWEEN & NULL
Learn to filter data in SQL — SELECT, DISTINCT, LIKE wildcards, IN, BETWEEN, IS NULL vs = NULL, and aliases — with clear examples for testers.
Basic SQL Commands: DDL, DML, DCL & TCL with Examples (For Testers)
Basic SQL commands with examples: DDL, DML, DCL and TCL, DELETE vs TRUNCATE vs DROP, keys and constraints, plus the queries testers use most.