SQL Tutorial — One-Page Cheat Sheet
Talk to databases.
SQL Tutorial
- HOME
- Intro
- Syntax
- SELECT
- SELECT DISTINCT
- WHERE
- ORDER BY
- AND
- OR
- NOT
- INSERT INTO
- NULL Values
- UPDATE
- DELETE
- SELECT TOP
- Aggregate Functions
- MIN and MAX
- COUNT
- SUM
- AVG
- LIKE
- Wildcards
- IN
- BETWEEN
- Aliases
- Joins
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
- SELF JOIN
- UNION
- GROUP BY
- HAVING
- EXISTS
- ANY and ALL
- SELECT INTO
- INSERT INTO SELECT
- CASE
- NULL Functions
- Stored Procedures
- Comments
- Operators
SQL Database
- CREATE DATABASE
- DROP DATABASE
- BACKUP DATABASE
- CREATE TABLE
- DROP TABLE
- ALTER TABLE
- Constraints
- NOT NULL
- UNIQUE
- PRIMARY KEY
- FOREIGN KEY
- CHECK
- DEFAULT
- INDEX
- AUTO INCREMENT
- Dates
- Views
- Injection
- Hosting
- Data Types