Introduction to Structured Query Language

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 …

More PDF Content

Introduction to Structured Query Language
Page 1
Introduction to Structured Query Language Version 4.66 Copyright 1996-2001, James Hoffman jhoffman@one.net
Page 2
SQL 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 Selection Relational Operators Compound Conditions IN & BETWEEN Using LIKE Joins Keys Performing a Join Eliminating Duplicates Aliases & In/Subqueries Aggregate Functions Views Creating New Tables Altering Tables Adding Data Deleting Data Updating Data Indexes GROUP BY & HAVING More Subqueries EXISTS & ALL UNION & Outer Joins Embedded SQL
Page 3
SQL Tutorial http://w3.one.net/jhoffman/sqltut.htm
Page 2
04/07/2001 Common SQL Questions Nonstandard SQL Syntax Summary Exercises Important Links Basics of the SELECT Statement In a relational database, data is s

Download Introduction to Structured Query Language pdf from www2.aao.gov.au, 33 pages, 94.87KB.
Related Books

Leave a Reply