Praktischer QA-Kurs

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 LernsitzungenVollständiger Kurs · kostenlos

Kursübersicht

Woran Sie arbeiten werden

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

Lehrplan

Entdecken Sie den vollständigen Lernpfad.

Entdecken Sie hier Lektions- und Thementitel. Registrieren Sie sich und melden Sie sich an, um die Materialien zu lesen und kostenlos an den Wissensüberprüfungen teilzunehmen.

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

Theory, worked example, and practice

ArtikelDatabase systems and a tester’s data model
WissenscheckCheckpoint: Database systems and a tester’s data model

Lektion 22. SQL reading: SELECT, predicates, NULL, and ordering

Theory, worked example, and practice

ArtikelSQL reading: SELECT, predicates, NULL, and ordering
WissenscheckCheckpoint: SQL reading: SELECT, predicates, NULL, and ordering

Lektion 33. Joins, subqueries, sets, and duplicate semantics

Theory, worked example, and practice

ArtikelJoins, subqueries, sets, and duplicate semantics
WissenscheckCheckpoint: Joins, subqueries, sets, and duplicate semantics

Lektion 44. Aggregation, CTEs, and window functions

Theory, worked example, and practice

ArtikelAggregation, CTEs, and window functions
WissenscheckCheckpoint: Aggregation, CTEs, and window functions

Lektion 55. Schema, types, keys, and constraints

Theory, worked example, and practice

ArtikelSchema, types, keys, and constraints
WissenscheckCheckpoint: Schema, types, keys, and constraints

Lektion 66. CRUD, transactions, isolation, and anomalies

Theory, worked example, and practice

ArtikelCRUD, transactions, isolation, and anomalies
WissenscheckCheckpoint: CRUD, transactions, isolation, and anomalies

Lektion 77. Indexes, EXPLAIN, and query performance

Theory, worked example, and practice

ArtikelIndexes, EXPLAIN, and query performance
WissenscheckCheckpoint: Indexes, EXPLAIN, and query performance

Lektion 88. Migrations, seed data, and backward compatibility

Theory, worked example, and practice

ArtikelMigrations, seed data, and backward compatibility
WissenscheckCheckpoint: Migrations, seed data, and backward compatibility

Lektion 99. PostgreSQL JSON and JSONB

Theory, worked example, and practice

ArtikelPostgreSQL JSON and JSONB
WissenscheckCheckpoint: PostgreSQL JSON and JSONB

Lektion 1010. MongoDB modeling, CRUD, and validation

Theory, worked example, and practice

ArtikelMongoDB modeling, CRUD, and validation
WissenscheckCheckpoint: MongoDB modeling, CRUD, and validation

Lektion 1111. MongoDB aggregation, indexes, and explain

Theory, worked example, and practice

ArtikelMongoDB aggregation, indexes, and explain
WissenscheckCheckpoint: MongoDB aggregation, indexes, and explain

Lektion 1212. MongoDB transactions, replication, and sharding

Theory, worked example, and practice

ArtikelMongoDB transactions, replication, and sharding
WissenscheckCheckpoint: MongoDB transactions, replication, and sharding

Lektion 1313. CouchDB and Couchbase JSON documents

Theory, worked example, and practice

ArtikelCouchDB and Couchbase JSON documents
WissenscheckCheckpoint: CouchDB and Couchbase JSON documents

Lektion 1414. Redis data types, JSON, caching, and persistence

Theory, worked example, and practice

ArtikelRedis data types, JSON, caching, and persistence
WissenscheckCheckpoint: Redis data types, JSON, caching, and persistence

Lektion 1515. Elasticsearch documents, mappings, and search correctness

Theory, worked example, and practice

ArtikelElasticsearch documents, mappings, and search correctness
WissenscheckCheckpoint: Elasticsearch documents, mappings, and search correctness

Lektion 1616. Database QA strategy, security, recovery, and capstone

Theory, worked example, and practice

ArtikelDatabase QA strategy, security, recovery, and capstone
WissenscheckCheckpoint: Database QA strategy, security, recovery, and capstone