DBMS

Showing 10 articles in this directory.

Primary Key vs Foreign Key: The Glue of Relational Databases

Jun 11, 2026•Venkata Lokesh P

Understanding primary and foreign keys — what they are, how they're different, and how they work together to keep your relational database structured and consistent.

DBMSPrimary KeyForeign KeyRelational DatabaseConstraints

Normalization (1NF – BCNF): Cleaning Up Your Database Design

Jun 11, 2026•Venkata Lokesh P

A clear walkthrough of database normalization — from the basics of 1NF all the way to BCNF — and why structuring your tables well matters.

DBMSNormalization1NF2NF3NFBCNFDatabase Design

ACID Properties: Why Your Database Doesn't Lose Your Data

Jun 11, 2026•Venkata Lokesh P

A simple breakdown of ACID properties — the four rules that make database transactions reliable and trustworthy.

DBMSACIDTransactionsDatabase

Transactions: Grouping Operations That Must Succeed Together

Jun 11, 2026•Venkata Lokesh P

What database transactions actually are, how they work, what isolation levels mean, and why they're essential for reliable data operations.

DBMSTransactionsACIDConcurrencyDatabase

Indexing: How Databases Find Your Data Fast

Jun 11, 2026•Venkata Lokesh P

Indexes are one of the most impactful things you can add to a database. Here's how they work, what types exist, and when (and when not) to use them.

DBMSIndexingPerformanceQuery OptimizationDatabase

Clustered vs Non-Clustered Index: What's the Difference?

Jun 11, 2026•Venkata Lokesh P

A clear breakdown of clustered and non-clustered indexes — how they're different, how they're stored, and when to use each one.

DBMSIndexingClustered IndexNon-Clustered IndexPerformance

B+ Trees: The Data Structure Powering Your Database Indexes

Jun 11, 2026•Venkata Lokesh P

Most database indexes run on B+ trees under the hood. Here's how they actually work — nodes, leaves, traversal, and why they're so good at what they do.

DBMSB+ TreeIndexingData StructuresDatabase Internals

Denormalization: When Breaking the Rules Makes Sense

Jun 11, 2026•Venkata Lokesh P

Normalization is great — but sometimes you deliberately undo it for performance. Here's what denormalization is, when to use it, and what trade-offs you're making.

DBMSDenormalizationPerformanceDatabase Design

Locks (Shared & Exclusive): How Databases Handle Concurrent Access

Jun 11, 2026•Venkata Lokesh P

An approachable guide to database locking — shared locks, exclusive locks, deadlocks, and how databases keep concurrent transactions from corrupting each other.

DBMSLocksConcurrencyShared LockExclusive LockDeadlockDatabase

Joins (All Types): Combining Tables the Right Way

Jun 11, 2026•Venkata Lokesh P

A complete guide to all SQL join types — INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF joins — with clear examples and when to use each one.

DBMSSQLJoinsINNER JOINLEFT JOINRIGHT JOINFULL JOINCROSS JOIN