ADevGuide Tag: Database
All the articles with the tag "Database".
-
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.
-
What Is Hashing? Why It Matters in Modern Software Architecture
Series: Database Scalability Series
Learn hashing in software architecture: data distribution, cache keys, security, consistency, and performance trade-offs used in real production systems.
-
Vertical vs Horizontal Sharding: Key Differences Explained
Series: Database Scalability Series
Compare vertical vs horizontal database sharding with clear examples, trade-offs, and guidance on when each scaling strategy fits best.
-
What Is Database Connection Pooling and Why It Matters
Series: Database Fundamentals
Learn what database connection pooling is, how it works under the hood, and why it is essential for building performant, scalable backend applications.
-
How ORMs Work Internally: A Simple Explanation
Series: Database Fundamentals
Learn how Object-Relational Mappers work under the hood - from query building and identity maps to lazy loading and the N+1 problem.
-
What Is a Database Transaction? Step-by-Step Guide
Series: Database Fundamentals
Learn what a database transaction is, how BEGIN, COMMIT, and ROLLBACK work, and when to use savepoints with clear SQL examples.
-
ACID Properties Explained: Atomicity, Consistency, Isolation, and Durability
Series: Database Fundamentals
Learn what ACID properties mean in databases. Understand atomicity, consistency, isolation, and durability with simple examples and real-world use cases.
-
Database Normalization Explained: 1NF, 2NF, and 3NF with Examples
Series: Database Fundamentals
Learn database normalization step by step. Understand 1NF, 2NF, and 3NF with clear table examples and how each normal form reduces redundancy.
-
Basic SQL Queries Every Developer Must Know
Series: Database Fundamentals
Learn the essential SQL queries every developer needs: SELECT, WHERE, JOIN, GROUP BY, INSERT, UPDATE, and DELETE with real examples.