There are two mainly two types in the world of databases: SQL and NoSQL (or relational databases and non-relational databases). Both are different in terms of how they are built, what kind of and how they store the information and kind of storage method they use.
Read MoreCategory: Relational databases
ACID properties
ACID properties are very useful in relational database. It gives you confidence that your data will always be consistent no matter how many transactions will occur at a time or in case of system failure.
ACID stands on
A: Atomic
C: Consistent
I: Isolate
D: Durable