SQL
Structured Query Language

DQL
Data Query Language

SELECT

COLUMN(S)

ALL TABLE(*)

FROM

TABLE(S)_NAME

JOIN

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL JOIN

CROSS JOIN

WHERE

Operatory

<, >, <=, >=, =

IS NULL

IS NOT NULL

Logiczne

AND

OR

NOT

Specjalne

BETWEEN

LIKE

IN

ANY

ALL

EXISTS

GROUP BY

COLUMN_NAME

HAVING

ORDER BY

COLUMN ASC

COLUMN DESC

LIMIT

OFFSET

ALIAS

AS

Funkcje agregujące

AVG()

SUM()

COUNT()

MIN()

MAX()

Typy danych

INT

VARCHAR

DATE

BOOLEAN

JSON

TIMESTAMP

DDL
Data Definition Language

CREATE

DATABASE

TABLE

VIEW

CONSTRAINTS

PRIMARY KEY

FOREIGN KEY

UNIQUE

CHECK

DEFAULT

ALTER

ADD

DROP

MODIFY

RENAME

DROP

DATABASE

TABLE

VIEW

INDEX

TRUNCATE

TABLE

DML
Data Manipulation Language

INSERT

INSERT INTO TABLE_NAME

VALUES(...)

UPDATE

SET COLUMN_NAME = VALUE

WHERE CONDITION

DELETE

FROM TABLE_NAME

WHERE CONDITION

DCL
Data Control Language

GRANT

SELECT

INSERT

UPDATE

DELETE

ALL PRIVILEGES

REVOKE

SELECT

INSERT

UPDATE

DELETE

TCL
Transaction Control Language

COMMIT

ROLLBACK

TO SAVEPOINT

SAVEPOINT

RELEASE SAVEPOINT