SQL Project: Banking Transactions
A banking SQL project in MySQL: reconcile balances, running-balance statements, fraud patterns with window frames, an ACID transfer procedure and a trigger.
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 13 of 140SQL Stored Procedures
Learn MySQL stored procedures step by step: CREATE PROCEDURE, DELIMITER, IN and OUT parameters, variables, IF and loops, error handling and transactions.
Database Normalization (1NF, 2NF, 3NF)
Database normalization step by step: anomalies, 1NF, 2NF, 3NF and BCNF, normalizing a messy orders table into related tables, and when to denormalize.
SQL LAG and LEAD Functions
Compare a row with the previous or next row using SQL LAG and LEAD: month-over-month change, gaps between orders, defaults, offsets, FIRST_VALUE and LAST_VALUE.
SQL Joins Explained
SQL joins explained visually and step by step: INNER, LEFT, RIGHT, FULL OUTER, CROSS and SELF JOIN on the same two tables, with real MySQL results.
SQL INTERSECT and EXCEPT
Find rows common to two queries with INTERSECT and rows in one but not the other with EXCEPT, supported in MySQL 8.0.31+, plus the JOIN and EXISTS alternatives.
SQL Injection and Prepared Statements
How SQL injection works, shown on a demo login table, and how to prevent it with prepared statements in MySQL and Python, plus a QA testing checklist.
SQL Indexes
Learn SQL indexes in MySQL: how a B-tree index speeds up queries, CREATE INDEX, composite indexes, the leftmost-prefix rule, and when an index is not used.
SQL User-Defined Functions
Create your own MySQL functions with CREATE FUNCTION: parameters, RETURNS, DETERMINISTIC, using functions in queries, and function vs stored procedure.
SQL EXPLAIN and Query Optimization
Read MySQL EXPLAIN output column by column, use EXPLAIN ANALYZE and EXPLAIN FORMAT=TREE, and apply 10 practical SQL query optimization tips with real examples.
SQL EXISTS, ANY and ALL
Learn SQL EXISTS and NOT EXISTS for checking related rows, why NOT EXISTS beats NOT IN with NULLs, and how ANY and ALL compare a value with a…
SQL CTE (WITH Clause)
Learn Common Table Expressions (CTE) with the SQL WITH clause: simple and multiple CTEs, chaining steps, reusing a CTE, and CTE vs subquery vs view, on MySQL 8.
Preparing for a QA interview?
Take free timed mock tests with answers and explanations.