INSERT

One great thing about SQL is that the commands/statements are self describing. So in this case, the ‘insert’ command allows you to insert new data into a database.

SQL INSERT video tutorial.

SELECT

The ’select’ command allows you to select (pull out) specific pieces of information from a database.

SQL SELECT statement video tutorial.

UPDATE

The ‘update’ command allows you to update records/information already in the database.

SQL UPDATE statement video tutorial.

DELETE

The ‘delete’ command allows you delete information in the database. Like all the other commands you can tweak the command so as to target specific data in the database. Anyway, we will look at that a little later …

SQL DELETE statement video tutorial.