SQL - Structured Query Language.
SQL provides sufficient knowledge to query and manage database. The SQL Server database engine provides a platform that allows building and managing data applications. its also used to manipulate data in a database server.
The SQL Statements can be categorized as
Data Definition language (DDL): It is used by to define the database, datatypes, structures, and constrains on the data.
Some of the DDL commands are:
CREATE: used to create a new database object, such as a table
ALTER : used to modify the database objects
DROP : used to delete the objects.
Data Manipulation Language (DML) : It is used to manipulate the data in the database objects.
Some of the DML commands are:
INSERT : Used to insert a new data record in a table.
UPDATE: used to modify an existing record in a table.
DELETE: used to delete a record from a table.
Data Control Language (DCL) : It is used to control the data access in the database.
Data Query Language (DQL): It is used to query data from the database objects.