EasyEnv
PostgreSQL
IntermediateLesson 6 of 1435 min · hands-on

Joins

Part of the PostgreSQL course

Your data is not in one table, and it should not be. Users live in users, their posts live in posts, and the only thing tying a post to its author is a number sitting in a column. That split is the whole point of a relational database: each fact is written down exactly once.

Open the terminal, give this lesson a fresh database of its own, and connect to it as postgres (lesson 02 explains the sudo -u postgres) ...

Want to learn PostgreSQL Joins in a real environment?

Click below, get a fresh Linux box with PostgreSQL ready to go, and work through Joins hands-on with an AI tutor that knows your code.

Start this lessonJoins

What you'll learn

  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL OUTER JOIN
  • Self join
  • USING vs ON

Read this lesson in your language

All lessons in this course

14 lessons
  1. 1What is PostgreSQL20 min
  2. 2psql and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types25 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes35 min
  9. 9Transactions and Isolation35 min
  10. 10Functions and Triggers35 min
  11. 11JSONB and Arrays35 min
  12. 12EXPLAIN and Query Tuning35 min
  13. 13Backup and Restore25 min
  14. 14Capstone: Design a Schema60 min

Explore other courses

Joins - PostgreSQL (English) | Engineering Courses