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
SQL
Query relational databases with SQL: joins, indexes, transactions, and query optimization.
3 articles
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