Kursa genel bakış
Ne üzerinde çalışacaksınız
From SQL and transactions to MongoDB, JSONB, CouchDB, Couchbase, Redis, Elasticsearch, migrations, recovery, and evidence-based database QA.
Tüm kurslara geri dön
Pratik QA kursu
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 öğrenme oturumlarıTam kurs · ücretsiz
Kurs müfredatı
Öğrenme yolunun tamamını keşfedin.
Ders ve konu başlıklarını burada keşfedin. Materyalleri okumak ve bilgi kontrollerini ücretsiz almak için kaydolun ve oturum açın.
Ders 11. Database systems and a tester’s data model
Theory, worked example, and practice
- MakaleDatabase systems and a tester’s data model
- Bilgi kontrolüCheckpoint: Database systems and a tester’s data model
Ders 22. SQL reading: SELECT, predicates, NULL, and ordering
Theory, worked example, and practice
- MakaleSQL reading: SELECT, predicates, NULL, and ordering
- Bilgi kontrolüCheckpoint: SQL reading: SELECT, predicates, NULL, and ordering
Ders 33. Joins, subqueries, sets, and duplicate semantics
Theory, worked example, and practice
- MakaleJoins, subqueries, sets, and duplicate semantics
- Bilgi kontrolüCheckpoint: Joins, subqueries, sets, and duplicate semantics
Ders 44. Aggregation, CTEs, and window functions
Theory, worked example, and practice
- MakaleAggregation, CTEs, and window functions
- Bilgi kontrolüCheckpoint: Aggregation, CTEs, and window functions
Ders 55. Schema, types, keys, and constraints
Theory, worked example, and practice
- MakaleSchema, types, keys, and constraints
- Bilgi kontrolüCheckpoint: Schema, types, keys, and constraints
Ders 66. CRUD, transactions, isolation, and anomalies
Theory, worked example, and practice
- MakaleCRUD, transactions, isolation, and anomalies
- Bilgi kontrolüCheckpoint: CRUD, transactions, isolation, and anomalies
Ders 77. Indexes, EXPLAIN, and query performance
Theory, worked example, and practice
- MakaleIndexes, EXPLAIN, and query performance
- Bilgi kontrolüCheckpoint: Indexes, EXPLAIN, and query performance
Ders 88. Migrations, seed data, and backward compatibility
Theory, worked example, and practice
- MakaleMigrations, seed data, and backward compatibility
- Bilgi kontrolüCheckpoint: Migrations, seed data, and backward compatibility
Ders 99. PostgreSQL JSON and JSONB
Theory, worked example, and practice
- MakalePostgreSQL JSON and JSONB
- Bilgi kontrolüCheckpoint: PostgreSQL JSON and JSONB
Ders 1010. MongoDB modeling, CRUD, and validation
Theory, worked example, and practice
- MakaleMongoDB modeling, CRUD, and validation
- Bilgi kontrolüCheckpoint: MongoDB modeling, CRUD, and validation
Ders 1111. MongoDB aggregation, indexes, and explain
Theory, worked example, and practice
- MakaleMongoDB aggregation, indexes, and explain
- Bilgi kontrolüCheckpoint: MongoDB aggregation, indexes, and explain
Ders 1212. MongoDB transactions, replication, and sharding
Theory, worked example, and practice
- MakaleMongoDB transactions, replication, and sharding
- Bilgi kontrolüCheckpoint: MongoDB transactions, replication, and sharding
Ders 1313. CouchDB and Couchbase JSON documents
Theory, worked example, and practice
- MakaleCouchDB and Couchbase JSON documents
- Bilgi kontrolüCheckpoint: CouchDB and Couchbase JSON documents
Ders 1414. Redis data types, JSON, caching, and persistence
Theory, worked example, and practice
- MakaleRedis data types, JSON, caching, and persistence
- Bilgi kontrolüCheckpoint: Redis data types, JSON, caching, and persistence
Ders 1515. Elasticsearch documents, mappings, and search correctness
Theory, worked example, and practice
- MakaleElasticsearch documents, mappings, and search correctness
- Bilgi kontrolüCheckpoint: Elasticsearch documents, mappings, and search correctness
Ders 1616. Database QA strategy, security, recovery, and capstone
Theory, worked example, and practice
- MakaleDatabase QA strategy, security, recovery, and capstone
- Bilgi kontrolüCheckpoint: Database QA strategy, security, recovery, and capstone