SQL

The full form of SQL is Structured Query Language. It is a language which handles the database, Specially RDBMS (Relational Database Management System) like MySQL, MS Access, Sybase, Oracle, Informix, SQL Server and Postgres. We can manage the following task through SQL –

1. Create Database
2. Alter Database
3. Drop Database
4. Insert data
5. Update data
6. Delete data
7. Select data
8. Save the action
9. Revoke the action
10. Grand the permission to a selective user
11. Revoke the permission to a selective user

It is a ANSI(American National Standards Institute) standard language.

Types of SQL

Four types of SQL are available for doing different database related task

• DDL – DATA DEFINITION LANGUAGE
  1. CREATE - Create table
  2. ALTER - Alter the table structure
  3. DROP - Delete table
• DML - DATA MANIPULATION LANGUAGE
  1. INSERT - Insert tupple in a table
  2. UPDATE- Update the inserted tupple
  3. DELETE- Delete the inserted tupple
  4. SELECT- Select the tupple depend on the condition

• TCL
  1. COMMIT- save the action
  2. ROLLBACK- undo the action
• DCL
  1. GRANT - Grant the different permission to a user.
  2. REVOKE- Revoke the different permission to a user.