Data CAP theorem Data schema migration SQL, NoSQL, NewSQL SQL ACID properties Database normalization Optimistic and pessimistic locking in SQL Transaction isolation levels