SQL Code Snippets

---

SQL Basics

• SQL Syntax
• SQL Numeric Data Types & Functions
• SQL String Data Types & Functions
• SQL Data and Time Data Types & Functions
• SQL Wildcards
• SQL Constraints
• SQL Aggregate Functions

Data Definition Language (DDL)

• The CREATE statement
• The ALTER statement
• The DROP statement
• The RENAME statement
• The TRUNCATE statement

Data Manipulation Language (DML)

• The SELECT statement
• The INSERT statement
• The UPDATE statement
• The DELETE statement

Data Control Language (DCL)

• The GRANT statement
• The REVOKE statement
• List of Privileges

Transaction Control Language (TCL)

• The COMMIT statement
• The ROLLBACK statement
• The SAVEPOINT statement
• The SET TRANSACTION statement

SQL Constraints

• The NOT NULL constraint
• The UNIQUE constraint
• The PRIMARY KEY constraint
• The FOREIGN KEY constraint
• The CHECK constraint
• The DEFAULT constraint
• The ON DELETE CASCADE constraint

SQL Aggregate Functions

• The COUNT() function
• The AVG() function
• The SUM() function
• The MIN() function
• The ROUND() function
• The COALESCE function
• The IFNULL() function

Advanced SQL

• SQL Joins
• SQL subqueries
• SQL Views
• The CASE statement