Sql Statements

SQL is pronounced as "sequel", is a language that is used to manage the database to store, access, and modify data

Data Definition Language (DDL)
It is used to define the database,  data types, structures, and constraints on the data.

Some of the DDL Commands are

• CREATE is used to create a new database objects such as table
• ALTER is used to modify the database objects
• DROP is 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 is used to insert a new data record in a table 
• UPDATE is used to modify an existing record in a table
• DELETE is used to delete a record from a table 

Data Control Language (DCL)
It is used to control the data access in the database

Some of the DCL Commands are

• GRANT is used to assign permissions to user to access a database object
• REVOKE is used to deny permission to users to access a database object

Data Query Language (DQL)
It is used to query data from the database objects SELECT is the DQL command that is used to select data from the database in different ways abd formats