Week 2 Designing
Schemas. Normalizing. Data Types. Storage Classes. Type Affinities. Table Constraints: PRIMARY KEY
, FOREIGN KEY
. Column Constraints: CHECK
, DEFAULT
, NOT NULL
, UNIQUE
. Altering Tables: DROP TABLE
, ALTER TABLE
, ADD COLUMN
, RENAME COLUMN
, DROP COLUMN
. Charlie.