810q

Here's why SQL is more preferred by people.Read through and get to know why!

1. SQL is a non- procedural language so it allows to process sets of records that one at time
2. It provides automatic navigation to the data.
3. It is used for all users of Database activity by all ranges of Users.
4. It provides statements for a variety of tasks which concerns all activities regarding a database.

SQL statements are classified as

1. Data Manipulation Language(DML)
The purpose of DML is to change the data in the database. The statements are
INSERT
DELETE
UPDATE

2. Data Definition Language(DDL)
The main purpose of DDL is to create, modify and drop the database objects namely relation, index, view, trigger etc

3. Data Control Language(DCL)
The DCL is used to provide privacy and security to the database. The data Control Language statements allow user to give, take privileges.