A

B

C

• Column
• Name & various values for that column (field name) (int, decimal, bit/boolean, varchar(##)[string], date, etc. )
• Comment
• Ignored by SQL: --one-line comment; /* multi-line format */

D

• Database
• A usually large collection of data organized especially for rapid search & retrieval ( PostGRS, Microsoft SQL, etc.) ( tables, queries, results, etc. )
• Datetime
• Declare @birthDateAndTime; datetime = '1993-04-21 12:45:37.1237'; DECLARE @date date= '1993-04-21';

E F G H I J K L M N O P Q

• Query
• The R in CRUD; read, SELECT (keyword); SELECT extracts data from a database;
  SELECT columns FROM table name; SQL KEYWORDS aren't case-sensitive

R

• Row
• One record, one thing in that table

S T

• Tables
• Organized in a row-and-column format similar to a spreadsheet.

U V W

• Where
• Condition, more specific, uses: >, <, >=, <=, <>, =, IS NULL, BETWEEN
  Example: WHERE condition BETWEEN 5 AND 10 LIKE email '%gmail.com';

X Y Z