What is SQL (Structured Query Language)?

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