SQL optimisation, high-availability architectures, NoSQL with MongoDB. Designing production-ready hybrid databases, monitoring and security.
EXPLAIN, reading execution plans, B-Tree, Hash and Fulltext indexes.
Composite indexes, covering indexes, slow queries, caching strategies.
Master/slave and master/master replication, automatic failover.
Sharding, horizontal partitioning, advanced backup and restore strategies.
When to choose NoSQL? Types: document, key-value, column, graph.
MongoDB in practice: CRUD operations, indexes, aggregation pipeline.
MongoDB replication, configuring a Replica Set, sharded clusters.
Advanced indexes (text, geo, partial), profiling and optimising aggregations.
Designing and deploying a hybrid database (SQL + MongoDB).
Security: authentication, roles, TLS encryption, monitoring, project presentation.
Ready to master high-performance databases?