Lesson 4. SQL (Advanced)

Lesson Objective

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

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.