This is a draft cheat sheet. It is a work in progress and is not finished yet.
SQL Facts
SQL stands for Structured Query Language |
SQL is pronounced “sequel” |
SQL is declarative language |
SQL is used to access & manipulate data in databases |
Top SQL DBs are MS SQL Server, Oracle, DB2, and MySQL |
Types of SQL Statements
Data Definition Language (DDL) |
Data Manipulation Language (DML) |
Transaction Control Language (TCL) |
Data Control Language (DCL) |
CREATE |
INSERT |
COMMIT |
GRANT |
ALTER |
UPDATE |
ROLLBACK |
REVOKE |
DROP |
DELETE |
SAVEPOINT |
TRUNCATE |
MERGE |
RENAME |
|
|
|
|
|
