SQL commands are the instructions that used to communicate with
the database and perform specific task for manipulating data.
SQL commands can be used for creating tables, adding data to
tables, or modifying data, dropping the tables, searching data
from tables, set authentication for users. In this tutorial we
learn about four major categories of MySQL commands depending
according to their functionality. Let’s go - We are using these
SQL commands for creating, modifying, and dropping the structure
of database objects. The commands are CREATE, ALTER, DROP,
RENAME, and TRUNCATE. These SQL commands are used for storing,
retrieving, modifying, and deleting data. These commands are
SELECT, INSERT, UPDATE, and DELETE. These SQL commands are used
for managing changes affecting the data. These commands are
COMMIT, ROLLBACK, and SAVEPOINT. These SQL commands are used for
providing security to database objects. These commands are GRANT
and REVOKE. In upcoming tutorial we learn more details about
each commands of SQL.