Skip to main content

Courses About Pricing Educators

Sign in Get started

Courses About Pricing Educators

Get started Sign in

Loading courses

Loading lessons

Building Tables: PostgreSQL: Uncharted

Courses PostgreSQLBuilding Tables

Building Tables

Create and evolve PostgreSQL tables with suitable types, constraints, primary keys, and foreign keys.

PostgreSQL
Unit 7 of 12
11 lessons
105 min
240 XP

Every lesson is open. Sign in when you are ready to begin.

Sign in to start

Lessons

11 total

1CREATE Your First TableCreate a PostgreSQL table with three deliberately named columns.CodeConcept8 min20 XPOpen
2Picking Real TypesChoose PostgreSQL types for text, counts, money, states, dates, and timestamps.CodeConcept9 min20 XPOpen
3NOT NULL and UNIQUERequire a value and prevent the same value from being stored twice.CodeConcept9 min20 XPOpen
4Primary KeysCreate an identity column that PostgreSQL generates and uses as a primary key.CodeConcept8 min20 XPOpen
5Default ValuesDefine timestamps and boolean values that PostgreSQL supplies when omitted.CodeConcept8 min20 XPOpen
6CHECK ConstraintsProtect numeric ranges with CHECK constraints.CodeConcept9 min20 XPOpen
7Foreign KeysCreate a foreign key that rejects references to missing parent rows.CodeConcept10 min20 XPOpen
8What Happens on DELETEChoose RESTRICT, CASCADE, and SET NULL behavior for foreign keys.CodeConcept11 min20 XPOpen
9Changing Tables with ALTERAdd, drop, and rename columns on an existing table.CodeConcept9 min20 XPOpen
10Build the Cafe SchemaTurn the normalized four-table cafe design into DDL with keys and constraints.CodeProject12 min20 XPOpen
11Tables Mastery CheckBuild and evolve a related schema with types, constraints, keys, and ALTER TABLE.CodeMastery check12 min40 XPOpen

Designing Schemas Changing Data