A Visual Explanation of SQL Joins. Database Programming and Design. SQL Tutorial. Version 4.71 This page is a introductory tutorial of the Structured Query Language (also known as SQL) and is a pioneering effort on the World Wide Web, as this is the first comprehensive SQL tutorial available on the Internet. SQL allows users to access data in relational database management systems, such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, and others, by allowing users to describe the data the user wishes to see.
SQL also allows users to define the data in a database, and manipulate that data. This page will describe how to use SQL, and give examples. Also, you may be interested in joining the new SQL Club on Yahoo! Table of Contents Basics of the SELECT Statement In a relational database, data is stored in tables. Now, let's say you want to see the address of each employee. SELECT FirstName, LastName, Address, City, StateFROM EmployeeAddressTable; The following is the results of your query of the database: SELECT ColumnName, ColumnName, ...FROM TableName; Using LIKE. Allmusic.