Interview Fundamentals
Core Java concepts, practical Q&A, and coding discussion topics asked in technical interviews.
-
Composite Index Column Order: How to Choose the Right SQL Index
Series: Backend Interview Mastery
Learn how to choose composite index column order for SQL queries using equality, range, sort, selectivity, and EXPLAIN plan trade-offs.
-
SQL vs NoSQL: How to Choose in System Design
Series: Database Fundamentals , Backend Interview Mastery
Compare SQL vs NoSQL for system design: data modeling, transactions, scale, trade-offs, and the right database for each workload.
-
Database Indexing Explained: SQL Examples and Interview Questions
Series: Database Fundamentals , Backend Interview Mastery
Learn database indexing with SQL examples: B-tree indexes, query plans, composite index order, write costs, and interview questions.
-
API Gateway vs Load Balancer vs Reverse Proxy
Series: Backend Interview Mastery
Compare API gateways, load balancers, and reverse proxies for backend interviews: responsibilities, request flow, overlap, and architecture trade-offs.
-
Offset vs Cursor vs Keyset Pagination for Backend Interviews
Series: Backend Interview Mastery
Compare offset, cursor, and keyset pagination for backend interviews: performance, consistency, indexes, API contracts, and trade-offs.
-
Webhooks Explained: Delivery, Retries, Security and Idempotency
Series: Backend Interview Mastery
Learn webhooks for backend interviews: delivery flow, retries, HMAC signatures, replay protection, idempotency, queues, and failure handling.
-
API Rate Limiting: Fixed Window, Sliding Window and Token Bucket
Series: Backend Interview Mastery
Learn API rate limiting for backend interviews: fixed and sliding windows, token bucket, Redis atomicity, 429 responses, and trade-offs.
-
Idempotency in REST APIs: How to Prevent Duplicate Payments
Series: Backend Interview Mastery
Learn idempotency in REST APIs for backend interviews: idempotency keys, retries, race conditions, response replay, and duplicate-payment prevention.
-
API Gateway Explained: Architecture, Responsibilities and Trade-offs
Series: Backend Interview Mastery
Learn API gateway architecture for backend interviews: routing, authentication, rate limiting, aggregation, failure handling, and trade-offs.
-
Stateless vs Stateful Architecture for Backend Interviews
Series: Backend Interview Mastery , System Design Foundations
Learn stateless vs stateful architecture for backend interviews: where state lives, scaling trade-offs, sessions, Redis, and failure recovery.