Learning SQL - Preparation

Before we can go to school we need to know what some stuff means.


Structured Query Language, that's what you are going to learn.

It is pronounced 'Sequel' NOT 'ess queue ell' I have had some 'discussions' on various forums reagarding the correct pronunciation. Wel, geuss what? This is MY website and you are a visitor and you WILL pronounce SQL as 'sequel' or you can leave now! Only joking! I don't really mind if you want to look like an amateur in discussions with 'real' database folks.


A computer file where we store our data


These are like the drawers in a filing cabinet, holding related bits of information

Relational Database

Lots of tables linked together by keys


Individual bits of information in a table ie: Name, Date Of Birth


A complete set of data for one record ie: one person

Throughout these lessons there is example code. Yellow boxed code can be executed, if you skip lessons then some code may be dependent on previous code.

This code could be run against your database

Grey boxed code is pseudo code

This code cannot be run without you doing some work to it