DBMS7 min read
Database Indexing Concepts
Understand core database indexing concepts including clustered versus non-clustered indexes, index selectivity, and how indexes trade write speed for read sp...
Arjun Mehta
AM
Arjun Mehta
Backend & Systems Engineer
Arjun covers Node.js, databases, system design, and backend architecture. He specializes in building scalable APIs and explaining complex distributed systems in plain language.
Node.jsMongoDBSQLSystem DesignDBMS
Articles by Arjun Mehta
15 articles
DBMS7 min read
Database Normalization: A Practical Guide
A practical guide to database normalization covering 1NF, 2NF, and 3NF with real examples, plus when denormalization makes sense for performance reasons.
Arjun Mehta
System Design7 min read
Load Balancing Basics for System Design
Learn the fundamentals of load balancing in system design, including load balancing algorithms, health checks, layer 4 vs layer 7 balancing, and common failu...
Arjun Mehta
System Design7 min read
Caching Strategies for System Design
Explore common caching strategies used in system design, including cache-aside, write-through, write-back, and cache invalidation approaches, with trade-offs...
Arjun Mehta
System Design7 min read
System Design: Designing a URL Shortener
A step-by-step system design walkthrough for building a URL shortener like bit.ly, covering requirements, encoding strategies, database schema, and scaling c...
Arjun Mehta
SQL7 min read
SQL Transactions and ACID Properties
Understand SQL transactions and the ACID properties — atomicity, consistency, isolation, and durability — with practical examples of commit, rollback, and is...
Arjun Mehta
SQL7 min read
SQL Indexing for Performance
Learn how SQL indexes speed up queries, how B-tree indexes work internally, when composite indexes help, and how to avoid common indexing mistakes that hurt...
Arjun Mehta
SQL7 min read
SQL Joins Explained
A clear explanation of SQL joins including INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN, with example tables and queries showing exactly what each...
Arjun Mehta
MongoDB7 min read
MongoDB Aggregation Pipeline Tutorial
Learn how the MongoDB aggregation pipeline works with practical stages like match, group, sort, project, and lookup, building toward real reporting queries.
Arjun Mehta
MongoDB7 min read
MongoDB CRUD Operations Guide
A hands-on guide to MongoDB CRUD operations, covering insertOne, find with query operators, updateOne/updateMany, and deleteOne/deleteMany with practical exa...
Arjun Mehta
Express.js7 min read
Error Handling Best Practices in Express
Best practices for handling errors in Express applications, covering centralized error middleware, custom error classes, async error handling, and consistent...
Arjun Mehta
Express.js6 min read
Express.js Middleware Deep Dive
A deep dive into Express.js middleware: how the request-response cycle works, writing custom middleware, and ordering middleware correctly in real applications.
Arjun Mehta
Node.js7 min read
Node.js Event Emitter Patterns
Learn how Node.js's EventEmitter works and explore practical patterns for building event-driven modules, including error handling and avoiding memory leaks.
Arjun Mehta
Node.js7 min read
Node.js Streams and Buffers Explained
Learn how Node.js streams and buffers work, including readable, writable, and transform streams, backpressure, and practical examples for handling large file...
Arjun Mehta
Node.js7 min read
Building REST APIs with Node.js
A practical guide to building REST APIs with Node.js, covering routing, request parsing, status codes, validation, and structuring a maintainable backend pro...
Arjun Mehta