Databases Deep Dive
Schema design, indexes, query tuning, replication topologies and how to choose between relational, document, wide-column, search, graph, time-series and vector databases.
5 lessons1 hIntermediate
0/5
What you'll learn
0 of 5 lessons complete
Who this is for and what you will be able to do
Who this is for
Developers who use databases daily and want to design schemas, read query plans and choose the right store with confidence.
After this course you will be able to
- Design schemas with normalisation, and denormalise deliberately
- Choose and order indexes, including composite and covering indexes
- Read a query plan and fix common slow-query causes
- Compare replication topologies and their conflict behaviour
- Match a workload to the right type of database
Topics it coversDatabasesReplicationAll topics
How a lesson works
Interactive diagram
See how each component connects, then run a request through it.
Plain-words toggle
Switch between the technical explanation and a plain-language one.
Practice design
Change a design of your own in the builder and see how it holds up.
Quiz and exercise
Test your understanding before moving on.
Go deeper
These lessons are written from scratch. The books below are excellent next reads.
- Use The Index, Lukeby Markus Winandfree online guide to SQL indexing
- Designing Data-Intensive Applicationsby Martin Kleppmannstorage, replication and data models
- PostgreSQL documentation: performance tipsby PostgreSQLquery planning and EXPLAIN