Passer au contenu principal
QA
FR

Gloire à l'Ukraine !

Retour à tous les cours

Cours pratique d'assurance qualité

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.

Séances d'apprentissage 16Cours complet · gratuit

Aperçu du cours

Sur quoi vous travaillerez

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

Programme du cours

Explorez le parcours d’apprentissage complet.

Explorez les titres des leçons et des sujets ici. Inscrivez-vous et connectez-vous pour lire les documents et passer les contrôles de connaissances gratuitement.

Leçon 11. Database systems and a tester’s data model

Theory, worked example, and practice

  • ArticlesDatabase systems and a tester’s data model
  • Contrôle des connaissancesCheckpoint: Database systems and a tester’s data model
Leçon 22. SQL reading: SELECT, predicates, NULL, and ordering

Theory, worked example, and practice

  • ArticlesSQL reading: SELECT, predicates, NULL, and ordering
  • Contrôle des connaissancesCheckpoint: SQL reading: SELECT, predicates, NULL, and ordering
Leçon 33. Joins, subqueries, sets, and duplicate semantics

Theory, worked example, and practice

  • ArticlesJoins, subqueries, sets, and duplicate semantics
  • Contrôle des connaissancesCheckpoint: Joins, subqueries, sets, and duplicate semantics
Leçon 44. Aggregation, CTEs, and window functions

Theory, worked example, and practice

  • ArticlesAggregation, CTEs, and window functions
  • Contrôle des connaissancesCheckpoint: Aggregation, CTEs, and window functions
Leçon 55. Schema, types, keys, and constraints

Theory, worked example, and practice

  • ArticlesSchema, types, keys, and constraints
  • Contrôle des connaissancesCheckpoint: Schema, types, keys, and constraints
Leçon 66. CRUD, transactions, isolation, and anomalies

Theory, worked example, and practice

  • ArticlesCRUD, transactions, isolation, and anomalies
  • Contrôle des connaissancesCheckpoint: CRUD, transactions, isolation, and anomalies
Leçon 77. Indexes, EXPLAIN, and query performance

Theory, worked example, and practice

  • ArticlesIndexes, EXPLAIN, and query performance
  • Contrôle des connaissancesCheckpoint: Indexes, EXPLAIN, and query performance
Leçon 88. Migrations, seed data, and backward compatibility

Theory, worked example, and practice

  • ArticlesMigrations, seed data, and backward compatibility
  • Contrôle des connaissancesCheckpoint: Migrations, seed data, and backward compatibility
Leçon 99. PostgreSQL JSON and JSONB

Theory, worked example, and practice

  • ArticlesPostgreSQL JSON and JSONB
  • Contrôle des connaissancesCheckpoint: PostgreSQL JSON and JSONB
Leçon 1010. MongoDB modeling, CRUD, and validation

Theory, worked example, and practice

  • ArticlesMongoDB modeling, CRUD, and validation
  • Contrôle des connaissancesCheckpoint: MongoDB modeling, CRUD, and validation
Leçon 1111. MongoDB aggregation, indexes, and explain

Theory, worked example, and practice

  • ArticlesMongoDB aggregation, indexes, and explain
  • Contrôle des connaissancesCheckpoint: MongoDB aggregation, indexes, and explain
Leçon 1212. MongoDB transactions, replication, and sharding

Theory, worked example, and practice

  • ArticlesMongoDB transactions, replication, and sharding
  • Contrôle des connaissancesCheckpoint: MongoDB transactions, replication, and sharding
Leçon 1313. CouchDB and Couchbase JSON documents

Theory, worked example, and practice

  • ArticlesCouchDB and Couchbase JSON documents
  • Contrôle des connaissancesCheckpoint: CouchDB and Couchbase JSON documents
Leçon 1414. Redis data types, JSON, caching, and persistence

Theory, worked example, and practice

  • ArticlesRedis data types, JSON, caching, and persistence
  • Contrôle des connaissancesCheckpoint: Redis data types, JSON, caching, and persistence
Leçon 1515. Elasticsearch documents, mappings, and search correctness

Theory, worked example, and practice

  • ArticlesElasticsearch documents, mappings, and search correctness
  • Contrôle des connaissancesCheckpoint: Elasticsearch documents, mappings, and search correctness
Leçon 1616. Database QA strategy, security, recovery, and capstone

Theory, worked example, and practice

  • ArticlesDatabase QA strategy, security, recovery, and capstone
  • Contrôle des connaissancesCheckpoint: Database QA strategy, security, recovery, and capstone