SQL & Database Testing for QA Engineers

About this course

A practical, lab-driven SQL course built for Indian QA job seekers and working testers. You build one realistic MySQL 8 e-commerce database with nine planted data defects and use it in every lesson to find test data, verify UI and API results, validate migrations, test transactions, stored procedures and triggers, and automate checks in Java and Python. The course ends with a portfolio capstone and covers the SQL questions asked in service and product company interviews.

What you will be able to do

• Set up MySQL 8 with DBeaver (or DB Fiddle/SQLite) and load a realistic e-commerce test database.
• Write precise SELECT, aggregation, JOIN, subquery, CTE and window-function queries to verify application data.
• Solve the classic SQL interview questions: Nth highest salary, duplicates, latest record per group, anti-joins.
• Test constraints, transactions, rollback and isolation, and verify ACID behaviour with negative tests.
• Validate data integrity, referential integrity, migrations/ETL, UI-vs-DB values, stored procedures and triggers.
• Automate database checks with JDBC + TestNG and Python + pytest, integrated with UI/API tests and GitHub Actions.
• Diagnose slow queries with EXPLAIN and indexes, and validate MongoDB documents with queries and schema validation.
• Publish a portfolio-ready DB testing project with a test plan, 30-check validation suite and defect reports.

Syllabus

1. ▶
   1. Databases for Testers: MySQL 8, DBeaver & the Practice Shop DB Understand how relational databases back every application you test, install MySQL 8 with DBeaver (or use DB Fiddle/SQLite), and load the e-commerce practice schema used throughout the course. Hands-on Lab · 60 min · 6 lab tasks · 5-question quiz · Free preview
2. 🔒
   2. SELECT Essentials: Filtering, Sorting, Patterns & NULLs Write precise SELECT queries with WHERE, ORDER BY, LIMIT, LIKE, IN, BETWEEN, REGEXP and correct NULL handling to find test data and verify records. Hands-on Lab · 75 min · 7 lab tasks · 5-question quiz
3. 🔒
   3. Aggregations, GROUP BY, HAVING & CASE for Report Testing Use COUNT, SUM, AVG, MIN, MAX with GROUP BY, HAVING and CASE to recompute dashboard numbers, build data-quality scorecards and detect duplicate records. Hands-on Lab · 70 min · 7 lab tasks · 5-question quiz
4. 🔒
   4. JOINs for Data Validation: Inner, Left, Right & Self Joins Combine tables with INNER, LEFT, RIGHT and self joins to verify UI pages against the database and to find missing, orphaned and mismatched records. Hands-on Lab · 80 min · 7 lab tasks · 5-question quiz
5. 🔒
   5. Subqueries, CTEs & Window Functions — Interview Classics Solve the classic SQL interview problems (Nth highest salary, duplicates, latest record per group) and advanced validations using subqueries, EXISTS, CTEs and window functions. Hands-on Lab · 90 min · 7 lab tasks · 5-question quiz
6. 🔒
   6. DML, DDL, Constraints & Transactions: Testing ACID and Rollback Change data safely with INSERT/UPDATE/DELETE inside transactions, prove constraints with negative tests, and verify atomicity, rollback, savepoints and isolation in MySQL 8. Hands-on Lab · 80 min · 7 lab tasks · 5-question quiz
7. 🔒
   7. Database Testing Techniques: Integrity, Migration, UI-vs-DB, Procedures & Triggers Apply professional database testing techniques — schema checks, data and referential integrity rules, migration/ETL reconciliation, UI-vs-DB verification, and stored procedure and trigger testing. Lesson + Lab · 90 min · 7 lab tasks · 5-question quiz
8. 🔒
   8. Automating DB Checks with JDBC (Java) and Python Build a reusable database validation layer with JDBC + TestNG and Python + pytest, integrate DB assertions with UI/API tests, and run the checks in GitHub Actions. Hands-on Lab · 100 min · 7 lab tasks · 5-question quiz
9. 🔒
   9. Query Performance with Indexes & EXPLAIN + MongoDB Testing Intro Generate realistic data volumes, read EXPLAIN/EXPLAIN ANALYZE output, prove the impact of indexes, and validate document data in MongoDB with queries, aggregation and schema validation. Hands-on Lab · 75 min · 7 lab tasks · 5-question quiz
10. 🔒
    10. Capstone: Order Management DB Test Plan, 30-Check Suite & Automation Deliver a complete, portfolio-ready database testing project for the order-management scenario: test plan, 30-check SQL validation suite, automated pytest/CI execution and defect reports. Capstone Project · 120 min · 7 lab tasks · 5-question quiz