Topic
databases
The ACID Principle
ACID ensures database transactions are Atomic (all or nothing), Consistent (valid state maintained), Isolated (independent execution), and Durable (permanent after commit).
Optimized file formats
File formats like Avro, Optimized Row Columnar (ORC) and Parquet
SQL statement types
SQL statements are categorized into three main types: DDL (Data Definition Language), DCL (Data Control Language), and DML (Data Manipulation Language).