Skip to main content
Toggle sidebar
Back to courses
4/30
·
SQL Fundamentals for QA Cheatsheet
Database and SQL Testing
0%
Previous lesson
Next lesson
AI Tutor
Toggle theme
My Courses
Database and SQL Testing
0/30 lessons
0%
Module 1
SQL Fundamentals for QA
SELECT, WHERE, and Filtering Data and JOINs Explained (INNER, LEFT, RIGHT, FULL)
Aggregate Functions (COUNT, SUM, AVG, GROUP BY) and Subqueries and Common Table Expressions
INSERT, UPDATE, DELETE for Test Data and Reading and Understanding Database Schemas
SQL Fundamentals for QA Cheatsheet
Lab: SQL Fundamentals for QA in Practice
Quiz: SQL Fundamentals for QA
Module 2
Data Integrity and Validation Testing
Data Type and Constraint Validation and Referential Integrity Testing
NULL Handling and Default Values and Unique Constraint and Duplicate Detection
Data Transformation Verification and Audit Trail and Timestamp Testing
Data Integrity and Validation Testing Cheatsheet
Lab: Data Integrity and Validation Testing in Practice
Quiz: Data Integrity and Validation Testing
Module 3
Database Migration Testing
Types of Database Migrations and Migration Testing Strategy
Data Migration Verification Queries and Rollback Testing
Backward Compatibility Checks and Zero-Downtime Migration Validation
Database Migration Testing Cheatsheet
Lab: Database Migration Testing in Practice
Quiz: Database Migration Testing
Module 4
API-to-Database Verification
Testing CRUD Operations End-to-End and Verifying API Responses Match Database State
Testing Cascade Deletes and Soft Deletes and Concurrent Write Testing
Transaction Isolation Testing and Testing With Database Fixtures
API-to-Database Verification Cheatsheet
Lab: API-to-Database Verification in Practice
Quiz: API-to-Database Verification
Module 5
Database Performance for QA
EXPLAIN and Query Plan Analysis and Index Effectiveness Testing
N+1 Query Detection and Connection Pool Monitoring
Large Dataset Testing Strategies and Database Monitoring and Alerting Basics
Database Performance for QA Cheatsheet
Lab: Database Performance for QA in Practice
Quiz: Database Performance for QA
Reading
6 min read
SQL Fundamentals for QA Cheatsheet
Loading content...
On this page
Key SQL Commands Quick Reference
Decision Flowchart for JOIN Types
Patterns and Anti-Patterns
Patterns
Anti-Patterns
SQL Checklist for QA
Summary
Practice Task
Patterns and Anti-Patterns
Sign in to track progress
Sign In