SQL Tutorial

SQL (Structured Query Language) is a standard language for managing and working with relational databases.

In this tutorial you will learn how to use SQL to access and process data in systems such as MySQL, SQL Server, Access, Oracle, Sybase, and DB2. The examples here were tested with MySQL.

Learning path

Basics

1. SQL Intro
2. SQL Syntax
3. SELECT · DISTINCT · WHERE
4. AND & OR · ORDER BY
5. INSERT · UPDATE · DELETE

Queries

6. TOP / LIMIT · LIKE · Wildcards
7. IN · BETWEEN · Aliases
8. JOIN · INNER · LEFT · RIGHT · FULL
9. UNION · SELECT INTO · INSERT INTO SELECT

Schema & constraints

10. CREATE DATABASE · CREATE TABLE
11. Constraints · NOT NULL · UNIQUE · PRIMARY KEY · FOREIGN KEY · CHECK · DEFAULT
12. CREATE INDEX · DROP · ALTER · AUTO INCREMENT

Functions & more

13. Views · Dates · NULL · ISNULL etc.
14. Data Types · Engine Types
15. Functions · AVG · COUNT · MAX · MIN · SUM
16. GROUP BY · HAVING · EXISTS
17. Quick Reference · Hosting · Summary

Example

SELECT * FROM Websites;

TIP

Continue with a specific engine: MySQL · SQLite · PostgreSQL

Next: SQL Intro