SQL

Style guides

Gitlab
IBM
Mozilla
Simon Holywell

DDL (Data Definition Language)

• CREATE
• ALTER
• DROP
• RENAME
• TRUNCATE
• COMMENT

DML (Data manipulation Language)

• SELECT
• INSERT
• UPDATE
• DELETE
• MERGE
• CALL
• EXPLAIN PLAN
• LOCK TABLE

DCL (Data Control Language)

• GRANT
• REVOKE

TCL (Transaction Control Language)

• COMMIT
• ROLLBACK
• SAVE POINT
• SET
• TRANSACTION

Basic querying

SELECT *
FROM table_a
WHERE 1=1
  AND condition

Joins

SQL injections