SQL Tutorial

SQL -- pronounced sequel -- stands for Structured Query Language. It is the language used to access data stored in a SQL database. With SQL, you can query your database in a variety of ways, using English-like statements.

With SQL, data is stored in tables. A table is a set of columns and rows.  Each column is referred to as a field. Each value in a field represents a single type of data. For example, a table might have three fields: name, city, and state. The table will consist of three columns: one for name, one for city, and one for state.  For every row in the table, the name field contains the name, the city field contains the city, and the state field contains the state. A database is a collection of related data. It can also be viewed as a collection of related tables. This tutorial is on storing data in and retieving data from a SQL database. 

Table of Contents

Introduction
  SQL
  Tables
  Scalable SQL for Windows
  Definition of Database
  Tables used by Solomon IV
  Reading the Reports
  SQLScope
  The Menu Bar
  The View Option
  Database in Use
  Conventions Used in this Guide
  Errors
Creating Tables
Importing Data
Retrieving All Data
Retrieving a Single Column
Retrieving Multiple Columns
Formatting Numbers
Ordering Rows
Displaying Rows in Descending Order
Ordering Multiple Columns
Retrieving Specific Rows
Multiple Conditions
Joining Tables
Updating Tables
Deleting Rows
Inserting Rows