Category: SQL

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.

Link tables with foreign keys that reference primary keys.

Enforce uniqueness on columns that are not the primary key.

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

Start learning SQL — from tables and queries to joins, transactions, and a final database management project.

Define SQL as the standard language for relational databases.

Distinguish SQL the language from MySQL the database product.

Understand databases, schemas, and client/server database systems.