All notes, in reading order
963 published notes across every category.
What is SQL: Databases, DBMS and RDBMS
SQL is the declarative language used to define and query relational data. Start here to see what a database, a DBMS and an RDBMS actually are.
The Relational Model: Tables, Rows, Columns and Schemas
Tables hold typed columns and unordered rows, schemas hold tables, and every value obeys the type its column declares.
SQL Syntax, Keywords, Identifiers and Comments
How a SQL statement is built: clause order, keywords versus identifiers, quoting rules, statement terminators and the two comment styles.
SQL Data Types Explained
Numeric, string, date and boolean types across the major dialects, and how to pick the type that stops bad data at the door.
SQL Operators and Expressions
Arithmetic, comparison, logical, string and set operators, how precedence works, and where an expression may legally appear.