SQL CROSS JOIN
Learn SQL CROSS JOIN: the Cartesian product of two tables, generating combinations and calendars, filling report gaps, and the accidental cross join.
SQA Tools Blog
Learn testing and automation, one article at a time
Free tutorials, solved practice problems and interview prep for QA and automation engineers: Python, Playwright, Selenium, SQL, Git and more.
1,677Articles
1,141Solved Python problems
7Topics
100%Free
Latest articles
1,677 articles · page 14 of 140SQL Correlated Subqueries
Learn correlated subqueries in SQL: how the inner query runs once per outer row, top salary per department, latest order per customer, faster alternatives.
SQL Constraints and DEFAULT
Learn SQL constraints in MySQL: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK and DEFAULT, column vs table constraints, naming and listing them.
SQL CAST and CONVERT
Convert data types in SQL with CAST and CONVERT: text to number, number to text, strings to dates, DECIMAL precision and implicit conversion pitfalls in MySQL.
SQL IFNULL, COALESCE and NULLIF
Replace and create NULLs in SQL: COALESCE, IFNULL, NULLIF and IF in MySQL, defaults for missing values, safe division by zero, and COALESCE vs IFNULL.
SQL Date and Time Functions
MySQL date and time functions with examples: NOW, CURDATE, YEAR, MONTH, DATE_FORMAT, DATEDIFF, TIMESTAMPDIFF, DATE_ADD, LAST_DAY, and grouping by month.
SQL Numeric Functions
MySQL numeric functions with examples: ROUND, TRUNCATE, CEIL, FLOOR, ABS, MOD, POWER, SQRT, integer division, percentages and RAND, step by step.
SQL String Functions
MySQL string functions with examples: CONCAT, CONCAT_WS, LENGTH, UPPER, LOWER, SUBSTRING, LEFT, RIGHT, INSTR, REPLACE, TRIM, LPAD and SUBSTRING_INDEX.
SQL HAVING Clause
Filter groups with the SQL HAVING clause: HAVING COUNT, SUM and AVG conditions, HAVING vs WHERE explained step by step, and finding duplicates, in MySQL.
SQL GROUP BY
Learn SQL GROUP BY step by step: group rows and aggregate each group, group by several columns, expressions and joins, ROLLUP subtotals and ONLY_FULL_GROUP_BY.
SQL Upsert: INSERT ON DUPLICATE KEY UPDATE and REPLACE
Insert a row or update it if it exists. Learn MySQL INSERT ... ON DUPLICATE KEY UPDATE, INSERT IGNORE and REPLACE INTO, with real results and pitfalls.
SQL CASE Expression
Learn SQL CASE WHEN step by step: searched and simple CASE, labels, CASE in ORDER BY, conditional counts and pivots with SUM(CASE), on real MySQL data.
Preparing for a QA interview?
Take free timed mock tests with answers and explanations.