SQL Tutorial

Learning SQL can be very rewarding. Once you have a basic understanding of SQL, you can start to develop more advanced websites, and you can (hopefully) charge more money for doing so!

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 program such as MySQL, SQL Server, or Oracle to be configured on your machine.

If you don't have a database program installed on your machine, don't despair, you will still learn what 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!

Table of Contents

This tutorial consists of the following lessons:

1. Introduction
2. SQL Syntax
3. SQL Select
4. SQL Where
5. SQL Order By
6. SQL Top
7. SQL Distinct
8. SQL In
9. SQL Alias
10. SQL Join
11. SQL Inner Join
12. SQL Outer Join
13. SQL Insert
14. SQL Update
15. SQL Delete
16. SQL Functions
17. SQL Count
18. SQL Create
19. SQL Create Database
20. SQL Create Table
21. SQL Create Index
22. SQL Alter Table
23. SQL Summary

• Start Tutorial >>