SQL commands. Codecademy SQL Syntax

SQL:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
CREATE TABLE, CREATE a NEW TABLE.
INSERT INTO, adds a NEW ROW TO a TABLE.
SELECT, queries DATA FROM a TABLE.
UPDATE, edits a ROW IN a TABLE.
ALTER TABLE, changes an existing TABLE.
DELETE FROM, deletes ROWS FROM a TABLE.

SELECT, IS the clause you every TIME you want query information FROM a DATABASE.
WHERE, IS a popular command that lets you FILTER the RESULT OF the query based ON conditions that you specify.
LIKE/BETWEEN, special operators that can be used IN a WHERE clause.
AND/OR, special operators that you can USE WITH WHERE TO FILTER the query ON two OR more conditions.
ORDER BY, lets you sort the RESULT OF the query IN either ascending(ASC) OR descending(DESC) ORDER.
LIMIT, lets you specify the maximum NUMBER OF ROWS that the query will RETURN. This IS especially important IN LARGE TABLES that have thousands OR even millions OF ROWS.

COUNT, IS a FUNCTION that the name OF a COLUMN(s) AS an argument AND counts the NUMBER OF ROWS WHERE the VALUE(s) IS NOT NULL.
GROUP BY, IS a clause used WITH aggregate functions TO combine DATA FROM one OR more COLUMNS.
SUM(), IS a FUNCTION that takes the COLUMN name AS an argument AND RETURNS the SUM OF ALL VALUES IN that COLUMN.
MAX(), IS a FUNCTION that takes the COLUMN name AS an argument AND RETURNS the largest VALUE IN that COLUMN.
MIN(), IS a FUNCTION that takes the COLUMN name AS an argument AND RETURNS the smallest VALUE IN that COLUMN.
AVG(), IS a FUNCTION that takes a COLUMN name AS an argument AND RETURNS the average VALUE FOR that COLUMN.
ROUND(), IS a FUNCTION that takes two arguments, a COLUMN name AND the NUMBER OF DECIMAL places TO round the VALUES IN that COLUMN.

INNER JOIN, will combine ROWS FROM different TABLES IF the JOIN condition IS TRUE.
LEFT OUTER JOIN, will RETURN every ROW IN the LEFT TABLE, AND IF the JOIN condition IS NOT met, NULL VALUES are used TO fill IN the COLUMNS FROM the RIGHT TABLE.
AS, IS a keyword IN SQL that allows you TO RENAME a COLUMN OR TABLE IN the RESULT SET USING an alias.

PRIMARY KEY, IS a COLUMN that serves a UNIQUE identifier FOR ROW IN the TABLE. VALUES IN this COLUMN must be UNIQUE AND cannot be NULL.
FOREIGN KEY, IS a COLUMN that contains the PRIMARY KEY TO another TABLE IN the DATABASE. It IS used TO identify a particular ROW IN the referenced TABLE.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=