SQL Tutorial

• Database Tutorials
• Start Tutorial

SQL is the standard query language used for working with relational databases.

This SQL tutorial consists of the following lessons:

• Introduction
• SQL Syntax
• SQL Select
• SQL Where
• SQL Order By
• SQL Top
• SQL Distinct
• SQL In
• SQL Alias
• SQL Join
• SQL Inner Join
• SQL Outer Join
• SQL Insert
• SQL Update
• SQL Delete
• SQL Functions
• SQL Count
• SQL Create
• SQL Create Database
• SQL Create Table
• SQL Create Index
• SQL Alter Table
• SQL Summary

This free SQL tutorial covers the SQL (Structure Query Language) syntax and its various SQL commands. It assumes a basic knowledge of databases and database design.

Although not essential, you will benefit most from practicing the examples on your own computer — this would require a database management system such as MySQL, SQL Server, or Oracle to be configured on your machine.

If you don't have a database management system installed on your machine, don't despair, you can still learn SQL is and its syntax. Then, when you do find yourself a database system, you will know just what to do!

If you don't have a basic understanding of databases, start with the database tutorial, which steps through the fundamental concepts of databases. Once you've completed that tutorial, come back and breeze through this one!

If you prefer having a whole tutorial on a single page, check out my SQL tutorial for beginners over at database.guide.

• Database Tutorials
• Start Tutorial