teach-ict.com logo

THE education site for computer science and ICT

3. SQL

Short for 'Structured Query Language'.

SQL was created for use with an SQL database. It consists of a set of commands that can carry out the following tasks

  • Search records
  • Update records
  • Insert records
  • Delete records
  • Find related records

The table below shows the SQL statements you need to undestand

SQL commands
Command Description
SELECT This retrieves a record. Other commands can then be carried out on that record without affecting the whole database.
FROM The identifies the table where the data comes from
WHERE This sets out some condition with which to choose only certain records
AND The allows multiple conditions to be set all of which must be true
OR This allows multiple conditions to be set, any of which needs to be true
LIKE This allows data to be selected that are similar to the criteria set with like

These will de discussed over the next few pages.


Challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: What is SQL?