Tag: db


Difference Between Database and Database Management System (DBMS)

What is the main difference between database and database management system (DBMS)? Let’s discuss a comparison between DB and DBMS (DB vs DBMS).


Select SQL Command | Aggregate Functions with Example

Select SQL commands syntax and example explained with different filters like ‘where’, ‘group by’, ‘having clause’ and ‘order by’ clause in MySQL database.


ACID Properties in DBMS with Examples

What are ACID properties in DBMS with examples (atomicity, consistency, isolation, durability)? How is it related to database transaction processing?