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