Tag: Databases
All the articles with the tag "Databases".
-
Database Deadlocks: Causes, Detection, and Prevention
Series: Backend Interview Mastery
Learn database deadlocks through transaction examples, wait-for cycles, retries, lock ordering, query design, and production prevention practices.
-
Optimistic vs Pessimistic Locking: How to Choose
Series: Backend Interview Mastery
Compare optimistic vs pessimistic locking with SQL examples, conflict handling, retries, deadlocks, and practical backend trade-offs.
-
Database Isolation Levels Explained With Real Transaction Examples
Series: Backend Interview Mastery
Learn database isolation levels through real transaction examples, including dirty reads, phantoms, write skew, retries, and SQL trade-offs.
-
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.
-
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.