Posts

Showing posts from September, 2023

DBMS - Database Management System

Image
  DBMS - Database Management System Database Management System (DBMS)  is a software used to manage data from a database. A database is a structured collection of data that is stored in an electronic device. The data can be text, video, image or any other format. A relational database stores data in the form of tables and a NoSQL database in the form of key-value pairs. SQL (Structured Query Language) is a standard language for accessing and manipulating data in a relational database. A DBMS is a software that allows to create, update and retrieval of data in an organized way. It also provides security to the database. Examples of relational DBMS are MySQL, Oracle, Microsoft SQL Server, Postgre SQL and Snowflake. Examples of NoSQL DBMS are MongoDB, Cassandra, DynamoDB and Redis. In this  Database Management System tutorial , you’ll learn basic to advanced topics like the ER model, Relational Model, Relation Algebra, Normalization, File Organization, etc. Aiming for a top ...