About SQL

What is Sql?

Sql is the Core Language used to perform the operations on the data.Sql pronounced as "Sequel",is a
Language that is used to manage data in an RDMS.


The SQL Statements can be categorized as

Data Definition Language(DDL):is Used by to define the database,data types,structures,and contraints on the data,Some of DDL commands are

Create:Used to create a new data base object such as a table.

ALTER:Used to Modify the database objects.

Drop:Used to delete the objects

Data Manipulation Language: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 insert a new data record in a table

DELETE:Used to delete a record from a table

Data Control Lanaguage:is used to control the data access in the database

GRANT:Used to assign permissions to users to access a database object

REVOKE:Used to deny permissions to users to access a database object

Data Query language:is used to query data from the data base objects

SELECT is a DQL command that is used to select data from the
database in different ways and formats.