SQL-commands

SQL History

SQL commands

SQL Operators

SQL Functions

SQL Joins

Sub Queries

SQL Set Operations

SQL commands

SQL is divided into four types of Languages. They are

Data Definition Language commands (DDL) Data Manipulation Language commands (DML) Data Control Language commands (DCL) Transaction Control Language commands (TCL)

DDL commands :

1. CREATE TABLE
2. ALTER TABLE
3. DROP TABLE

DML commands :

1. INSERT INTO
2. DELETE
3. UPDATE
4. SELECT

DCL commands :

1. GRANT
2. REVOKE

TCL commands :

1. COMMIT
2. ROLLBACK
3. SAVEPOINT