1

mrahmedcomputing

KS3, GCSE, A-Level Computing Resources

Lesson 4. SQL (Advanced)


Lesson Objective

  1. Use SQL statements to search for data.
  2. Use SQL to enter data into relational databases using INSERT INTO and VALUES statements.
  3. Use SQL to edit and delete data using UPDATE, SET and DELETE FROM statements.

Lesson Notes

SQL Syntax

Advanced SQL Syntax:

Keyword Purpose in SQL Statments
INSERT INTO The INSERT INTO statement is used to insert new records in a table.
VALUES The VALUE statement specifies that data that will be inserted into the specified field.
UPDATE The UPDATE statement is used to modify the existing records in a table.
SET The SET statement specifies the data to be updated.
DELETE FROM The DELETE statement is used to delete existing records in a table.

3