SQL Tutorial

Fundamentals

Introduction CREATE Database DROP Database BACKUP Database Data Types Overview Dates

Tables

CREATE Table DROP Table ALTER Table Constraints

Constraints

NOT NULL UNIQUE PRIMARY KEY FOREIGN KEY CHECK DEFAULT

Basic Queries

SELECT SELECT DISTINCT WHERE AND, OR, NOT ORDER BY SELECT TOP

Data Manipulation

INSERT INTO UPDATE DELETE NULL Values

Functions

MIN and MAX COUNT, AVG, SUM NULL Functions

Pattern Matching & Operators

LIKE Wildcards IN BETWEEN Operators Reference

Joins

Introduction INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN Self JOIN

Grouping & Aggregation

GROUP BY HAVING

Subqueries

EXISTS ANY and ALL

Advanced Techniques

Aliases UNION SELECT INTO INSERT INTO SELECT CASE CREATE INDEX AUTO INCREMENT Views Stored Procedures

Security & Documentation

SQL Injection Comments SQL Hosting