SQL Window Functions
Learn SQL window functions step by step: OVER(), PARTITION BY, ORDER BY in the window, aggregates without GROUP BY, named windows and frames, in MySQL 8.4.
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 12 of 140MySQL Users and Roles
Manage MySQL accounts: CREATE USER, user@host, passwords, ALTER and DROP USER, roles with CREATE ROLE and default roles, and least-privilege account design.
SQL UNION and UNION ALL
Combine query results with SQL UNION and UNION ALL: rules for columns, removing duplicates, sorting the combined result, and when UNION ALL is faster.
SQL Top N per Group
Get the top N rows per group in SQL: top earners per department, best-selling products per category, latest order per customer, with ties handled correctly.
SQL Subqueries
Learn SQL subqueries step by step: scalar and IN subqueries, derived tables in FROM, subqueries in SELECT, and when a JOIN or CTE is better.
SQL Running Totals and Moving Averages
Calculate running totals, cumulative counts, moving averages and percent of total in SQL with SUM() OVER, window frames ROWS and RANGE, in MySQL 8.
SQL Recursive CTE
Learn recursive CTEs in MySQL 8: WITH RECURSIVE, anchor and recursive parts, number and date series, employee hierarchies, org-chart paths and loop limits.
SQL ROW_NUMBER, RANK and DENSE_RANK
The difference between ROW_NUMBER, RANK and DENSE_RANK explained on real data with ties, plus NTILE, ranking per group and the Nth highest salary, in MySQL.
SQL Project: QA Test Results Tracker
A SQL project for QA engineers: pass rates per build, failing and flaky tests, regressions with LAG, slowest tests, automation coverage and defect metrics.
SQL Project: Library Management System
Build and query a library management database in MySQL: available copies, overdue loans, fines, popular books, members, a view and an issue-book procedure.
SQL Project: HR and Payroll Analytics
An HR analytics SQL project: headcount and attrition, current salaries from history, raises with LAG, top earners, org chart with a recursive CTE, tenure.
SQL Project: E-commerce Sales Analysis
A complete SQL portfolio project: analyse a year of online shop orders in MySQL. Revenue, monthly trend, top products, margins, repeat buyers, RFM, cohorts.
Preparing for a QA interview?
Take free timed mock tests with answers and explanations.