Menu

git commit●fetch()●SELECT *●HTTP 200●localhost:3000●branch●flexbox●POST /api●INDEX●status 404●merge●JSON●git commit●fetch()●SELECT *●HTTP 200●localhost:3000●branch●flexbox●POST /api●INDEX●status 404●merge●JSON●

PostgreSQL

M1Meet PostgreSQLFree

What is PostgreSQL?
Tables, columns & types
Connecting with psql

M2Reading dataLocked

SELECT & WHERE
Sorting & limiting
Aggregates, GROUP BY & HAVING

M3Writing data safelyLocked

INSERT, UPDATE & DELETE
Transactions & ACID
Concurrency & isolation

M4Relationships & joinsLocked

Primary & foreign keys
JOINs
Constraints
Normalization

M5Making it fastLocked

Indexes
Reading a query plan
When not to index

M6Beyond the basicsLocked

JSONB
Views
Where to go next

Courses/PostgreSQL/Tables, columns & types

Meet PostgreSQL · Lesson 2 of 19

Tables, columns & types

Loading lesson…

Learners.Center

Learn by doing.

A product by DreamyHook Digital Media.