What is DBMS languages & its commands?

      

                                               DBMS languages

Database languages are used to read, update and store data in database. These database  languages that can be used for this purpose one of them SQL. There are Five  types of database languages
Types Database languages are

DDL :-   Data Definition Language

DML :-  Data Manipulation Language

DCL :-   Data Control Language

SQL :-   Structure Querying Language

TCL  :-   Transaction Control Language

         I.        1)DDL(Data Definition Language):-  Data Definition Language used for  specifying the data base ‘schema’. It is used for creating tables, schemas etc. in database.
            Commands of Data Definition Language(DDL) are given below

             CREATE: - to create database instances.

             DROP: - to drop database instances.

             COMMENT: - to comment.

          ALTER: -to alter structure of database

         2)DML(Data Manipulation Language): - Data Manipulation Language used for            accessing and manipulating data in database. 
          Commands of  Data Manipulation Language (DML) are

             INSERT: - to insert record(s) into the table.

             UPDATE: - to update data into table.

             DELETE: - to delete record(s) into the table.

            SELECT: -to read/retrieved record(s) from table.

   III.            3)DCL( Data Control Language): -  Data Control Language used for granting              and revoking user access on a database. 
                    Commands of  Data  Control Language(DCL) are given below

            GRANT: - to grant access to user.

           REVOKE: - to revoke access to user.

   4)TCL( Transaction Control Language): -  Transaction Control Languages are used to changes in the database that we made by using DML commands either performance or role backed by using TCL.  
Commands of  Transaction Control Language(TCL) are given below

             COMMIT: - to persist the changes made by DML command in database.

             ROLL BACK: - to roll back the changes made to the database.