Day 1 of 14 30 minRDBMSClient/serverpsql
What PostgreSQL is, how the server handles your queries, and running your first query in psql.
By the end of today you can
- Explain what a relational database is and why teams choose PostgreSQL
- Describe how a client talks to the PostgreSQL server
- Understand the cluster → database → schema → table hierarchy
- Connect with psql and run your first query
What's inside
- 6 sections
- 3 diagrams and mind maps
- 2 code examples you can run
- 4-question quiz
- 1What is PostgreSQL?
- 2How the server works
- 3How data is organised
- 4Getting PostgreSQL running
- 5Your first query
- 6psql meta-commands
Sign in free to read this lesson
Get the full lesson with diagrams, runnable code and the quiz. Your progress is saved across devices.
Sign in free