Skip to main content
QA
EN

Glory to Ukraine!

Back to all courses

Practical QA course

Database Testing: SQL, MongoDB, and JSON Stores

From SQL and transactions to MongoDB, JSONB, CouchDB, Couchbase, Redis, Elasticsearch, migrations, recovery, and evidence-based database QA.

16 learning sessionsFull course · free

Course overview

What you will work on

From SQL and transactions to MongoDB, JSONB, CouchDB, Couchbase, Redis, Elasticsearch, migrations, recovery, and evidence-based database QA.

Course curriculum

Explore the full learning path.

Explore lesson and topic titles here. Register and sign in to read the materials and take the knowledge checks for free.

Lesson 11. Database systems and a tester’s data model

Theory, worked example, and practice

  • ArticleDatabase systems and a tester’s data model
  • Knowledge checkCheckpoint: Database systems and a tester’s data model
Lesson 22. SQL reading: SELECT, predicates, NULL, and ordering

Theory, worked example, and practice

  • ArticleSQL reading: SELECT, predicates, NULL, and ordering
  • Knowledge checkCheckpoint: SQL reading: SELECT, predicates, NULL, and ordering
Lesson 33. Joins, subqueries, sets, and duplicate semantics

Theory, worked example, and practice

  • ArticleJoins, subqueries, sets, and duplicate semantics
  • Knowledge checkCheckpoint: Joins, subqueries, sets, and duplicate semantics
Lesson 44. Aggregation, CTEs, and window functions

Theory, worked example, and practice

  • ArticleAggregation, CTEs, and window functions
  • Knowledge checkCheckpoint: Aggregation, CTEs, and window functions
Lesson 55. Schema, types, keys, and constraints

Theory, worked example, and practice

  • ArticleSchema, types, keys, and constraints
  • Knowledge checkCheckpoint: Schema, types, keys, and constraints
Lesson 66. CRUD, transactions, isolation, and anomalies

Theory, worked example, and practice

  • ArticleCRUD, transactions, isolation, and anomalies
  • Knowledge checkCheckpoint: CRUD, transactions, isolation, and anomalies
Lesson 77. Indexes, EXPLAIN, and query performance

Theory, worked example, and practice

  • ArticleIndexes, EXPLAIN, and query performance
  • Knowledge checkCheckpoint: Indexes, EXPLAIN, and query performance
Lesson 88. Migrations, seed data, and backward compatibility

Theory, worked example, and practice

  • ArticleMigrations, seed data, and backward compatibility
  • Knowledge checkCheckpoint: Migrations, seed data, and backward compatibility
Lesson 99. PostgreSQL JSON and JSONB

Theory, worked example, and practice

  • ArticlePostgreSQL JSON and JSONB
  • Knowledge checkCheckpoint: PostgreSQL JSON and JSONB
Lesson 1010. MongoDB modeling, CRUD, and validation

Theory, worked example, and practice

  • ArticleMongoDB modeling, CRUD, and validation
  • Knowledge checkCheckpoint: MongoDB modeling, CRUD, and validation
Lesson 1111. MongoDB aggregation, indexes, and explain

Theory, worked example, and practice

  • ArticleMongoDB aggregation, indexes, and explain
  • Knowledge checkCheckpoint: MongoDB aggregation, indexes, and explain
Lesson 1212. MongoDB transactions, replication, and sharding

Theory, worked example, and practice

  • ArticleMongoDB transactions, replication, and sharding
  • Knowledge checkCheckpoint: MongoDB transactions, replication, and sharding
Lesson 1313. CouchDB and Couchbase JSON documents

Theory, worked example, and practice

  • ArticleCouchDB and Couchbase JSON documents
  • Knowledge checkCheckpoint: CouchDB and Couchbase JSON documents
Lesson 1414. Redis data types, JSON, caching, and persistence

Theory, worked example, and practice

  • ArticleRedis data types, JSON, caching, and persistence
  • Knowledge checkCheckpoint: Redis data types, JSON, caching, and persistence
Lesson 1515. Elasticsearch documents, mappings, and search correctness

Theory, worked example, and practice

  • ArticleElasticsearch documents, mappings, and search correctness
  • Knowledge checkCheckpoint: Elasticsearch documents, mappings, and search correctness
Lesson 1616. Database QA strategy, security, recovery, and capstone

Theory, worked example, and practice

  • ArticleDatabase QA strategy, security, recovery, and capstone
  • Knowledge checkCheckpoint: Database QA strategy, security, recovery, and capstone