SQL

SQL Statements

INSERT statement
UPDATE statement
UPSERT statement
DELETE statement
TRANSACTION Statement
MATERIALISED VIEW statement

SQL Clauses

WHERE Clause
LIMIT clause
LIKE operator

JOIN

JOIN keywords allow you to connect tables based on a certain condition. Below is a list of different types of JOIN keywords that have different behaviours. The most commonly used is INNER JOIN.

INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN

SQL Tuning