How are the SQL commands classified | UBIQ - Ubiq BI
                     
What is a database query?
A database query pertains to the process of acquiring data or 
query from a database. It is generally performed using a 
database query language that generates data of different 
formats according to function. SQL is the most popular 
language used for database queries.
Uses of SQL commands
SQL commands can be used not just for searching the database but 
also to execute various other functions.
Using SQL commands, you are able to create tables, add data to 
tables, or modify data, drop the table and even set aside 
permissions for users.
The 4 categories of SQL commands
● DDL (Data Definition Language)
● DML (Data Manipulation Language)
● TCL (Transaction Control Language)
● DCL (Data Control Language)
DDL commands
Data Definition Language consists of the SQL commands that are traditionally 
used to define the description of the database structure. The database then 
proceeds to automatically commit the current transaction before and after every 
DDL Command. ALTER, CREATE and DROP are among some of the DDL 
commands
DML Commands
Data Manipulation Language commands are generally used for retrieving, 
sorting, modifying and deleting data stored in the database. DML 
Commands are used to deal with the management of data present in the 
objects of a database. Notable DML commands include INSERT, UPDATE, 
DELETE & SELECT.
Thank You
Visit: 
https://ubiq.co/database-blog/how-are-the-sql-commands-classified-ubiq/