THE WORLD'S LARGEST WEB DEVELOPER SITE

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.



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

INSERT INTO table2
SELECT * FROM table1
WHERE condition;
INSERT INTO table2 (column1,
column2, column3, ...)
SELECT column1, column2, column3,
... FROM table1
WHERE condition;

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

Start learning SQL now!










SQL Quiz Test

Test your SQL skills at W3Schools!

Start SQL Quiz!





PHP/SQL Exam - Get Your Diploma!

w3schools

W3Schools' Online Certification

The perfect solution for professionals who need to balance work, family, and career building.

More than 10 000 certificates already issued!

TheHTML Certificatedocuments your knowledge of HTML

TheCSS Certificatedocuments your knowledge of advanced CSS.

TheJavaScript Certificatedocuments your knowledge of JavaScript and HTML DOM.

ThejQuery Certificatedocuments your knowledge of jQuery.

ThePHP Certificatedocuments your knowledge of PHP and SQL (MySQL).

TheXML Certificatedocuments your knowledge of XML, XML DOM and XSLT.

TheBooststrap Certificatedocuments your knowledge of the Bootstrap framework.

W3Schools is optimized for learning, testing, and training. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 1999-2018 by Refsnes Data. All Rights Reserved. Powered by W3.CSS.