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
#sql
4 articles tagged with sql.
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