Relational modeling, joins, indexes, transactions, normalization, and query performance.
An index is an auxiliary data structure that lets the database find rows without scanning the whole table — trading extra storage and slower writes for much faster reads.