This tutorial on SQL gets you up to speed quickly.
Each page comes with real-world SQL examples.
Once you know SQL you can query and maintain databases.
This tutorial is designed for you, and it's free.
All SQL examples in this tutorial solve a specific problem.
Here's an example.
| SUPPLIER |
|---|
| Id |
| CompanyName |
| ContactName |
| City |
| Country |
| Phone |
| Fax |
SELECT Id, CompanyName, ContactName, City, Country
FROM Supplier
ORDER BY CompanyName DESC
The answer to this problem is the given SQL query.
The table(s) on the right help with visualizing the query.
Each SQL example has a 'Try It live' button which opens the SQL Editor where you can change the SQL and run it against a live database.
Tip: The editor accepts SELECT, UPDATE, INSERT, DELETE, and other operations. Operations that change data or the data model will execute, but are then rolled back (undone) to maintain integrity of the database.
If you're a beginner, then this tutorial is for you.
It covers the basics in a simple and easy-to-understand way.
The SQL editor lets you run your SQL -- a great learning experience.
As an experienced developer, this tutorial is also for you.
Our tutorial covers all SQL clauses, keywords, functions and more.
It is easy to forget an SQL detail or syntax -- this Guide has you covered.
Each page ends with a 'You may also like' section with links to related topics, like so:
