Home
Online Free Standard Query Language Course

Learning SQL online

SQL Database Tables

A database most often contains one or more tables. Each table is identified by a name (e.g. "Customers" or "Orders"). Tables contain records (rows) with data.

Below is an example of a table called "Persons":

LastName FirstName Address City
Tanveer Shah Petroman college DIKhan
Bukhari Syed Gomal University DIKhan
Amjad Rehman Gulsahan colony Lahore

The table above contains three records (one for each person) and four columns (LastName, FirstName, Address, and City).


SQL Queries

With SQL, we can query a database and have a result set returned.

A query like this:

SELECT LastName FROM Persons

Gives a result set like this:

LastName
Tanveer
Bukhari
Amjad

Note: Some database systems require a semicolon at the end of the SQL statement. We don't use the semicolon in our tutorials.


Administration

Tanvir Shah
S. Tavnir Hussain

Principal

Tauqeer Hussain
Tauqeer Hussain

Faculty Incharge

Safi Ullah
Safi Ullah Khurum

Admin