SQL databases store structured rows with strict rules and ACID transactions; NoSQL databases trade some of that for flexible data and easy horizontal scaling.