Tag: Tutorial

Protect data quality with PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, CHECK, and DEFAULT.

Choose appropriate types for numbers, strings, dates, and JSON/blob data.

Create and select databases for your projects.

Define tables with columns, types, and constraints.

Change existing table structure safely with ALTER TABLE.

Remove tables permanently with DROP TABLE.

Use multi-column keys when uniqueness spans more than one field.

Learn relations, tuples, attributes, and relational integrity ideas.

Model data as tables made of rows (records) and columns (fields).

Uniquely identify each row with a primary key.