#sql
Posts tagged with “sql”.
10 posts
ACID Transactions Explained With Examples
Atomicity, consistency, isolation and durability are the guarantees a transaction provides. Learn each one and the isolation levels.
Database Indexes Explained: B-Tree, Composite and Covering
An index trades write speed and space for read speed. Learn the B-tree, the composite index, the covering index and the query plan.
Database Indexing Explained With Examples
An index trades write speed and space for read speed. Learn how a B-tree works, when an index is used, and the common mistakes.
Database Migrations: A Practical Guide
A migration changes a schema without losing data. Learn the safe patterns, the zero-downtime approach, and how to roll back.
Database Normalization Explained: 1NF to 3NF
Normalization removes redundancy and update anomalies. Learn the normal forms, the trade-offs, and when to denormalize deliberately.
ORM vs Raw SQL: Choosing a Data Access Layer
An ORM trades control for convenience. Learn the trade-offs, the N+1 trap, and the hybrid approach most teams settle on.
PostgreSQL Basics: Queries, Indexes and Transactions
Postgres is a relational database with a rich feature set. Learn the query, the index, the transaction, and the JSON support.
SQL Injection: How It Works and How to Prevent It
SQL injection happens when user input becomes SQL code. Learn how it works and why parameterised queries are the definitive fix.
SQL Joins Explained With Visual Examples
Inner, left, right, full and cross joins each return a different set of rows. Learn the difference and the mistakes that cause duplicates.
SQL vs NoSQL: Choosing a Database
Relational and non-relational databases make different trade-offs. Learn the categories, the guarantees, and how to choose.