Vocabulary

Tables = columns for data like excel, series of columns and rows

Entity = an object in the database

Fields = columns

“ - - “ to take note inside sql

In sql, uppercase all keywords (even if sql doesnt mind casing), snake lowercase everything im naming myself

Name tables as singular items ! Lot of languages can generate code if we use this convention like Rails and Ruby

Double quotes are for referencing columns and tables, simple quotes is for insertion syntax

CREATE
SELECT (name or nb of columns or * for all)
UPDATE (remember to use WHERE to specify which entities to updates ! Without it evreything will be updated
DELETE (use WHERE !)
CONSTRAINT
fk = FOREIGN KEY

KEYWORDS