SQL is an acronym for Standard Query Language, a standardised language for obtaining information from relational databases.

Here are two extremely useful resources:

below is some sample SQL code to give you an idea of what the SQL is/does:(note: all SQL reserved words are written in capital letters here for clarity)

CREATE TABLE mytable (itemid INTEGER, itemname CHAR(30), description CHAR(70), creationdate DATE)


this will create a new table with a column for an item id, name, description and date of creation.



INSERT INTO mytable VALUES (32,"scooter","two wheeled, foot powered conveyance.","2000-12-12")


this would enter the specified information (in parenthesis) into a new record in the table (which we have previously created(above)) named 'mytable'.



SELECT * FROM mytable


this will obtain a list of all records contained in the table 'mytable'.