SQL Tutorial

SQL

Tutorial

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 into your account, and start earning points!

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

mylearning

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 course

Get certified

w3schools CERTIFIED . 2022