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!

• Database Tutorials
• Start Tutorial