Design schemas, constraints, indexes, joins, and transactions for relational databases. Use query plans and isolation levels to resolve correctness and performance problems.