Database Transactions — PlanetScale

What are database transactions and how do SQL databases isolate one transaction from another?