Get PostgreSQL installed on any operating system and learn to connect with the psql client, create your own databases and users, and navigate the object hierarchy with confidence. You walk away able to install, connect to and move around a real PostgreSQL database — the foundation every later skill builds on.
Watch the free preview
What PostgreSQL is and why teams choose it — free to watch, no account needed.
What you'll learn
- Install, connect to and navigate a PostgreSQL database on any operating system
- Explain what PostgreSQL is and when it is the right tool for the job
- Drive the psql client fluently using its meta-commands
- Create databases and roles and connect from external tools
- Describe the cluster, database, schema and table object hierarchy
Syllabus
Meet PostgreSQL and Get It Installed
What PostgreSQL is and why teams choose itFree preview
Installing PostgreSQL on Windows, macOS and Linux
Driving the psql Client
Connecting with psql and running your first queries
Essential psql meta-commands
Databases, Users and Connecting from Tools
Creating databases, roles and users
Connecting from tools and applications
The PostgreSQL Object Hierarchy
Cluster, database, schema and table
Navigating and organising with schemas
Lab — 10 Exercises & Solutions
Exercises 1–5
Exercises 6–10