In this post, I will explain What is SQL (Structured Query Language)?
SQL stands for
Structured Query Language. It is a standard language for managing relational
databases and performing various operations on data. SQL is used for building
database objects, manipulating objects, populating database tables with data,
updating existing data in tables, deleting data, performing database queries,
controlling database access, and overall database administration.
SQL is categorized into two main types,
1.
DDL (Data Definition Language)
2.
DML (Data Manipulation Language)
1. DDL (Data Definition Language)
DDL
(Data Definition Language) is the part of SQL that allows a database user to
create and restructure database objects, such as the creation or the deletion
of a table.
DDL
commands are,
CREATE
ALTER
DROP
2. DML (Data Manipulation Language)
DML
(Data Manipulation Language) is the part of SQL used to manipulate data within
objects of a database.
It
is used to retrieve, store, modify, delete, insert and update data in the database.
DML
commands are,
SELECT
INSERT
DELETE
UPDATE