Writing my first SQL program

This was part of a Codecademy exercise in their intro to SQL course. Since I recently worked on my first story at work that required new SQL code to be written, I figured now is as good a time as any to start learning SQL.

 

Each step involves SQL "clauses" which are like keywords. They can also be referred to as "commands". The primary clauses here are:

• CREATE TABLE
• INSERT INTO
• UPDATE
• ALTER
• DELETE FROM
• SELECT

There are other helper commands being used like:

• SET
• WHERE
• FROM
• VALUES

These helper commands pair with the primary ones above to create SQL statements. Every statement ends in a ;. From experience, if you omit a semi-colon, the language will not run. This is much stricter than JavaScript.