Learn DBMS and MySQL

Our tutorial provides basic and advance concepts of database management and MySQL commands with detailed examples

DBMS Introduction
MySQL Database
MySQL Tables
MySQL Queries
MySQL Clauses
MySQL Conditions
MySQL Keys

What is DBMS ?

Database Management System (DBMS) is software for storing and retrieving users data while considering appropriate security measures. It consists of a group of programs that manipulate the database. The DBMS accepts the request for data from an application and instructs the operating system to provide the specific data. In large systems, a DBMS helps users and other third-party software store and retrieve data.

DBMS allows users to create their own databases as per their requirements. The term “DBMS” includes the user of the database and other application programs. It provides an interface between the data and the software application.

DBMS allows users the following tasks:

  1. Data Definition: It is used for creation, modification, and removal of definition that defines the organization of data in the database.

  2. Data Updation: It is used for the insertion, modification, and deletion of the actual data in the database.

  3. Data Retrieval: It is used to retrieve the data from the database which can be used by applications for various purposes.

  4. User Administration: It is used for registering and monitoring users, maintain data integrity, enforcing data security, dealing with concurrency control, monitoring performance and recovering information corrupted by unexpected failure.

Now that you know what is dbms, let's learn types of Database


Share this page on :