SQL Tutorial
 |
SQL is a standard language for accessing databases.
Our SQL tutorial will teach you how to use SQL to access and manipulate data in:
MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems.
|
SQL Syntax
|
SELECT Company, Country FROM Customers WHERE Country <> 'USA'
|
SQL Result
| Company | Country |
| Island Trading |
UK |
| Galería del gastrónomo |
Spain |
| Laughing Bacchus Wine Cellars |
Canada |
| Paris spécialités |
France |
| Simons bistro |
Denmark |
| Wolski Zajazd |
Poland |
Try it yourself »
|
Start learning SQL now!
Learn by examples! With our editor, you can edit the SQL, and click on a button to view the result.
Try-It-Yourself!
Test your SQL skills at W3Schools!
Start SQL Quiz!
An SQL Quick Reference. Print it and put it in your pocket.
SQL Quick Reference
Data types and ranges for Microsoft Access, MySQL and SQL Server.
SQL Data Types
 |
W3Schools' Online Certification
The perfect solution for professionals who need to balance work, family, and career building.
More than 6000 certificates already issued!
Get Your Certificate »
|
The HTML Certificate documents your knowledge of HTML, XHTML, and CSS.
The CSS Certificate documents your knowledge of advanced CSS.
The JavaScript Certificate documents your knowledge of JavaScript and HTML DOM.
The jQuery Certificate documents your knowledge of jQuery.
The XML Certificate documents your knowledge of XML, XML DOM and XSLT.
The ASP Certificate documents your knowledge of ASP, SQL, and ADO.
The PHP Certificate documents your knowledge of PHP and SQL (MySQL).
Need an easy way to get data into XML, or transform XML to another format?
MapForce lets you map XML data to/from any combination of XML, database, flat file,
Excel 2007, XBRL, or Web services data. Then it transforms data instantly or
auto-generates royalty-free code for recurrent conversions.
New features in Version 2010!
- Easy-to-use, graphical data mapping interface
- Instant data transformation
- XSLT 1.0/2.0 and XQuery code generation
- Java, C#, and C++ code generation
- Advanced data processing functions
- Support for all major relational databases including SQL Server, IBM DB2, Oracle, and more
- Visual Studio & Eclipse integration
- Available in 32-bit and 64-bit versions
Download a fully-functional trial today!
|
|
|
|
