0% read · 0 of 35 topics

DatabaseDatabase

Indexing, Transactions & Scaling

0% read0 of 35 topics

Indexing0/9

ESR Rule (Equality, Sort, Range)Soon

Index Types (unique, partial, covering, TTL, GIN, hash)Soon

When an Index Is NOT UsedSoon

Query Debugging WalkthroughSoon

Transactions0/7

Isolation Levels and Read AnomaliesSoon

MVCC and VACUUMSoon

DeadlocksSoon

MongoDB TransactionsSoon

Transactions in Node.js (pg pool bug, withTransaction)Soon

MongoDB vs PostgreSQL0/6

Mongo Schema Design (embed vs reference, 16 MB limit)Soon

Normalization and DenormalizationSoon

SQL and Aggregation Basics (JOINs, GROUP BY, window functions, $lookup)Soon

Scaling0/6

Range vs Hashed ShardingSoon

Node.js + Database0/7

ORM/ODM Trade-offsSoon

Soft Delete vs Hard DeleteSoon

Query Debugging Walkthrough

This lesson is coming soon. Browse the rest of the Database syllabus in the sidebar.