SQL Tutorials Get link Facebook X Pinterest Email Other Apps SQL Tutorials SQL Tutorials Basics Introduction CREATE ALTER DROP SELECT INSERT UPDATE DELETE Constraints PRIMARY KEY FOREIGN KEY UNIQUE NOT NULL Data Types VARCHAR CHAR TEXT INT TINYINT BIGINT FLOAT REAL DATE TIME DATETIME Clauses Basics WHERE ORDER BY GROUP BY HAVING Aggregate Functions SUM AVG COUNT MIN MAX Joins Basics INNER JOIN LEFT JOIN RIGHT JOIN FULL JOIN CROSS JOIN Subqueries Basics Single-row Multiple-row Correlated Indexes Basics Single-Column Composite Unique Clustered Non-Clustered Triggers Basics BEFORE AFTER INSTEAD OF Transactions Basics Atomicity Consistency Isolation BEGIN COMMIT ROLLBACK Concurrency Basics Locking Timestamp Ordering Optimistic Control Multiversion Control Miscellaneous Views