Преглед на курса
Върху какво ще работите
From SQL and transactions to MongoDB, JSONB, CouchDB, Couchbase, Redis, Elasticsearch, migrations, recovery, and evidence-based database QA.
Назад към всички курсове
Практически 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 учебни сесииПълен курс · безплатно
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