TrainingRite.
Enquire Now

Software Testing · Online training

Database for QA Training

SQL, joins, subqueries, CRUD, data validation, backend checks and test data verification.

Level: Beginner to IntermediateDelivery: Online8 modules

Who should attend

Manual testers, QA engineers, support analysts and professionals validating application data.

Prerequisites

Basic computer literacy. No prior SQL experience is required for the introductory path.

Learning outcomes

  • Understand relational database concepts and common data types.
  • Write SELECT queries with filters, sorting and aggregation.
  • Use joins, subqueries, CTEs and window functions for QA checks.
  • Validate inserts, updates, deletes and transaction behaviour safely.
  • Compare UI/API data with database records and identify inconsistencies.
  • Create SQL-based test evidence for application workflows.

Detailed curriculum

8 modules
01Database fundamentals
  • Database, DBMS, RDBMS, schema, table, row and column
  • Primary keys, foreign keys, unique and check constraints
  • Data types, NULL, default values and relationships
  • ER diagrams and one-to-one, one-to-many and many-to-many relationships
  • OLTP versus analytical databases at a high level
02SQL environment and SELECT
  • Connecting to a training database and understanding schemas
  • SELECT, DISTINCT, aliases and expressions
  • WHERE conditions, comparison operators, AND/OR/NOT and IN/BETWEEN/LIKE
  • ORDER BY, LIMIT/TOP and handling NULL values
  • Date, string and numeric functions
03Joins and relational validation
  • INNER, LEFT, RIGHT and FULL OUTER JOIN concepts
  • Self joins and joining multiple tables
  • Finding orphan records and missing relationships
  • Duplicate detection and referential-integrity checks
  • Join pitfalls that cause row multiplication
04Aggregation and advanced querying
  • COUNT, SUM, AVG, MIN and MAX
  • GROUP BY and HAVING
  • Subqueries and correlated subqueries
  • Common Table Expressions (CTEs)
  • Window functions: ROW_NUMBER, RANK, LAG and aggregate windows
05Data modification and transactions
  • INSERT, UPDATE and DELETE in controlled test environments
  • WHERE safety and previewing affected rows
  • COMMIT, ROLLBACK and transaction concepts
  • ACID properties and isolation-level overview
  • Stored procedures, views and triggers: QA perspective
06Database testing techniques
  • Validating data created through UI and APIs
  • Backend field mapping and transformation checks
  • Default, mandatory, nullable and calculated-field validation
  • Boundary, precision, rounding and date/time checks
  • Audit columns, soft deletes and status-history validation
07Data quality and reconciliation
  • Completeness, accuracy, consistency, uniqueness and validity
  • Source-to-target record counts and aggregate reconciliation
  • Duplicate, missing, invalid and outlier detection
  • Comparing datasets and sampling strategies
  • Test data masking and handling sensitive information
08Performance, security and project
  • Reading execution plans and basic index concepts
  • Query performance hygiene and avoiding unnecessary full scans
  • Least privilege, roles and SQL injection awareness
  • Creating repeatable SQL validation scripts
  • Project-based database testing and defect evidence

How you will practise

Learn through instructor-led sessions using realistic, live applications. Then apply each concept through guided assignments on a separate hands-on practice application, with feedback to help you build practical skills and confidence.

Practical exercises and labs

  • Write SQL for customer, order, product and payment tables.
  • Find duplicate customers, orphan orders and missing mandatory values.
  • Validate an order total and tax calculation across related tables.
  • Reconcile UI/API-created records with database state.

Capstone project

Create a database QA pack for a sample order-management system: schema understanding, SQL test scripts, data-quality checks, reconciliation evidence and defect log.

Tools and technologies

SQL Server or MySQL/PostgreSQL (one primary engine), SQL client and sample relational database.

Assessment approach

  • Module-wise knowledge checks or short practical tasks.
  • Hands-on exercise review using an agreed checklist or rubric.
  • Final project demonstration and explanation of design decisions, test evidence or outputs, as applicable.
  • Completion criteria, attendance requirements and any certificate conditions must be separately approved and published by TrainingRite.

Schedule and fees

Upcoming batch schedules are shared by our TrainingRite team. Please submit an enquiry and our team will contact you by email or phone with the latest schedule. TrainingRite does not publish course fees or discounts on the website. Our counselling team will share the applicable course fee and other details with you by email or phone after you submit an enquiry.

Frequently asked questions

Who should join this course?

Manual testers, QA engineers, support analysts and professionals validating application data.

Do I need prior experience?

Basic computer literacy. No prior SQL experience is required for the introductory path.

Is the training online?

TrainingRite programmes are delivered online.

Will I get hands-on practice?

Sessions are instructor-led and use realistic applications. You then apply each concept through guided assignments on a separate practice application.

How can I enquire about fees and the next batch?

Fees and batch schedules are not published on the website. Submit the enquiry form on this page and our counselling team will share them with you by email or phone.

Related courses