Introduction to Structured Query Language

Short Description
Using the example tables in the tutorial, write a SQL statement to: …. Manas Tungare’s SQL Tutorial at FindTutorials.com. A Gentle Introduction to SQL …

Website: magnum.anu.edu.au | Filesize: 94kb

Content
Introduction to Structured Query Language
Version 4.66
Copyright 1996-2001, James Hoffman
jhoffman@one.netSQL Tutorial
http://w3.one.net/~jhoffman/sqltut.htm Page 1
04/07/2001
Introduction to Structured Query Language
Version 4.66
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. The SQL used in this document is “ANSI”, or standard SQL, and no SQL
features of specific database management systems will be discussed until the “Nonstandard SQL” section. It is
recommended that you print this page, so that you can easily refer back to previous examples.
Also, you may be interested in joining the new SQL Club on Yahoo!, where you can read or enter messages in
a SQL forum.
Table of Contents
Basics of the SELECT Statement
Conditional…