Learning SQL - Basic Terms
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 regarding the correct pronunciation. Well, guess 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
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
Pseudo code needs you to actually write the SQL or other language code, it basically shows the framework of the code.