Passa al contenuto principale
QA
IT

Gloria all'Ucraina!

Torna a tutti i corsi

Corso pratico di QA

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 sessioni di apprendimentoCorso completo · gratuito

Panoramica del corso

Su cosa lavorerai

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

Programma del corso

Esplora il percorso di apprendimento completo.

Esplora i titoli delle lezioni e degli argomenti qui. Registrati e accedi per leggere i materiali e sostenere gratuitamente le verifiche conoscitive.

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

Theory, worked example, and practice

  • ArticoloDatabase systems and a tester’s data model
  • Verifica della conoscenzaCheckpoint: Database systems and a tester’s data model
Lezione 22. SQL reading: SELECT, predicates, NULL, and ordering

Theory, worked example, and practice

  • ArticoloSQL reading: SELECT, predicates, NULL, and ordering
  • Verifica della conoscenzaCheckpoint: SQL reading: SELECT, predicates, NULL, and ordering
Lezione 33. Joins, subqueries, sets, and duplicate semantics

Theory, worked example, and practice

  • ArticoloJoins, subqueries, sets, and duplicate semantics
  • Verifica della conoscenzaCheckpoint: Joins, subqueries, sets, and duplicate semantics
Lezione 44. Aggregation, CTEs, and window functions

Theory, worked example, and practice

  • ArticoloAggregation, CTEs, and window functions
  • Verifica della conoscenzaCheckpoint: Aggregation, CTEs, and window functions
Lezione 55. Schema, types, keys, and constraints

Theory, worked example, and practice

  • ArticoloSchema, types, keys, and constraints
  • Verifica della conoscenzaCheckpoint: Schema, types, keys, and constraints
Lezione 66. CRUD, transactions, isolation, and anomalies

Theory, worked example, and practice

  • ArticoloCRUD, transactions, isolation, and anomalies
  • Verifica della conoscenzaCheckpoint: CRUD, transactions, isolation, and anomalies
Lezione 77. Indexes, EXPLAIN, and query performance

Theory, worked example, and practice

  • ArticoloIndexes, EXPLAIN, and query performance
  • Verifica della conoscenzaCheckpoint: Indexes, EXPLAIN, and query performance
Lezione 88. Migrations, seed data, and backward compatibility

Theory, worked example, and practice

  • ArticoloMigrations, seed data, and backward compatibility
  • Verifica della conoscenzaCheckpoint: Migrations, seed data, and backward compatibility
Lezione 99. PostgreSQL JSON and JSONB

Theory, worked example, and practice

  • ArticoloPostgreSQL JSON and JSONB
  • Verifica della conoscenzaCheckpoint: PostgreSQL JSON and JSONB
Lezione 1010. MongoDB modeling, CRUD, and validation

Theory, worked example, and practice

  • ArticoloMongoDB modeling, CRUD, and validation
  • Verifica della conoscenzaCheckpoint: MongoDB modeling, CRUD, and validation
Lezione 1111. MongoDB aggregation, indexes, and explain

Theory, worked example, and practice

  • ArticoloMongoDB aggregation, indexes, and explain
  • Verifica della conoscenzaCheckpoint: MongoDB aggregation, indexes, and explain
Lezione 1212. MongoDB transactions, replication, and sharding

Theory, worked example, and practice

  • ArticoloMongoDB transactions, replication, and sharding
  • Verifica della conoscenzaCheckpoint: MongoDB transactions, replication, and sharding
Lezione 1313. CouchDB and Couchbase JSON documents

Theory, worked example, and practice

  • ArticoloCouchDB and Couchbase JSON documents
  • Verifica della conoscenzaCheckpoint: CouchDB and Couchbase JSON documents
Lezione 1414. Redis data types, JSON, caching, and persistence

Theory, worked example, and practice

  • ArticoloRedis data types, JSON, caching, and persistence
  • Verifica della conoscenzaCheckpoint: Redis data types, JSON, caching, and persistence
Lezione 1515. Elasticsearch documents, mappings, and search correctness

Theory, worked example, and practice

  • ArticoloElasticsearch documents, mappings, and search correctness
  • Verifica della conoscenzaCheckpoint: Elasticsearch documents, mappings, and search correctness
Lezione 1616. Database QA strategy, security, recovery, and capstone

Theory, worked example, and practice

  • ArticoloDatabase QA strategy, security, recovery, and capstone
  • Verifica della conoscenzaCheckpoint: Database QA strategy, security, recovery, and capstone