THE education site for computer science and ICT
Structured Query Language (SQL)
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
| Command | Description |
|---|---|
| SELECT | This retrieves a record or a set of records. Other commands can then be carried out on that record set 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 |
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?