SQL ACID properties Database normalization Optimistic and pessimistic locking in SQL Transaction isolation levels