Skip to main content

Databases

Database concepts, query patterns, and practical tips across SQL and NoSQL.

Topics in this section​

  • Indexing strategies and when to use them
  • Transaction isolation levels explained
  • Query optimisation basics (EXPLAIN, N+1 problem)
  • Schema design principles
  • Choosing between SQL and NoSQL

This section is growing. Contribute an article if you know something worth sharing.