SQL Tutorial - SQL reference and programming examples

This website teaches you about SQL through well organized examples and explanations.

SQL BASICS

The SQL BASICS tutorial section introduces SQL and databases. Learn how to use these SQL statements:

SQL SELECT Statement
SQL WHERE Clause
SQL INSERT Statement
SQL UPDATE Statement
SQL UPDATE Statement
more...

SQL ADMINISTRATION

The SQL ADMINISTRATION tutorial section shows how to administer key SQL objects (databases, tables, views, indexes) using the CREATE, ALTER and DROP commands. Learn to do the following:

SQL Database: CREATE | DROP
SQL Table: CREATE | ALTER | DROP
SQL Index: CREATE | DROP
SQL Foreign Key: ADD | DROP
SQL View: CREATE | DROP
more...

SQL ADVANCED

The SQL ADVANCED tutorial section shows how to use advanced features of SQL commands.

SQL IN
SQL AND & OR
SQL BETWEEN
SQL LIKE
SQL DISTINCT
SQL GROUP BY
SQL AGGREGATE
SQL CONCAT
SQL SUBSTRING
SQL TRIM
SQL HAVING
SQL ORDER BY
SQL JOIN
SQL OUTER JOIN
more...

SQL SYNTAX

The SQL SYNTAX tutorial section shows the format of many SQL commands. It is an excellent reference. more...

SQL BOOK REVIEWS

The SQL BOOK REVIEW contains news and reviews about books of interest to SQL learners. more...