Guided language path

Learn SQL

Querying relational data, from the PostgreSQL tutorial.

Novus Learn curates the order and cites the official docs for each step — it does not rewrite the material. Open each doc to read the real source, or turn any step into a source-grounded breakdown.

PostgreSQL Tutorial

0 of 7 steps done

Mark The SQL language done
The SQL languagebeginner
PostgreSQL — The SQL language
sql basics relational database concepts sql tables rows
Turn this doc into a breakdown →
Mark Creating and populating tables done
Creating and populating tablesbeginner
PostgreSQL — Creating a new table
sql create table sql insert sql data types
Turn this doc into a breakdown →
Mark Querying a table done
Querying a tablebeginner
PostgreSQL — Querying a table
sql select sql where sql order by
Turn this doc into a breakdown →
Mark Joins between tables done
Joins between tablesintermediate
PostgreSQL — Joins between tables
sql joins inner join left join sql foreign key
Turn this doc into a breakdown →
Mark Aggregate functions done
Aggregate functionsintermediate
PostgreSQL — Aggregate functions
sql group by sql count sum avg sql having
Turn this doc into a breakdown →
Mark Updates and deletes done
Updates and deletesintermediate
PostgreSQL — Updates
sql update sql delete sql set where
Turn this doc into a breakdown →
Mark Transactions done
Transactionsadvanced
PostgreSQL — Transactions
sql transactions commit rollback acid
Turn this doc into a breakdown →

Learn SQL

More

Cookie preferences