1. Share:
Table of Contents

SQL is a standard language for storing, manipulating and retrieving data in databases.

Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.

Start learning SQL now »

Examples in Each Chapter

With our online SQL editor, you can edit the SQL statements, and click on a button to view the result.

Example

SELECT * FROM Customers;
Try it Yourself »

Click on the "Try it Yourself" button to see how it works.


SQL Exercises

Test Yourself With Exercises

Exercise:

Insert the missing statement to get all the columns from the Customers table.

 * FROM Customers;

Start the Exercise



SQL Examples

Learn by examples! This tutorial supplements all explanations with clarifying examples.

See All SQL Examples


SQL Quiz Test

Test your SQL skills at W3Schools!

Start SQL Quiz!


My Learning

Track your progress with the free "My Learning" program here at W3Schools.

Log in to your account, and start earning points!

This is an optional feature. You can study W3Schools without using My Learning.


SQL References

At W3Schools you will find a complete reference for keywords and function:

SQL Keyword Reference

MYSQL Functions

SQLServer Functions

MS Access Functions

SQL Quick Reference


SQL Data Types

Data types and ranges for Microsoft Access, MySQL and SQL Server.

SQL Data Types

 

Kickstart your career

Get certified by completing the SQL course

Get certifiedw3schoolsCERTIFIED.