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.

Introduction

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