Read, change and combine data in PostgreSQL without guessing what a query does. This is for people who have never written SQL, or who copy queries without knowing why they work. You will set up PostgreSQL 18, ask a small shop database for rows, change data safely, summarise it, and join tables without losing or doubling rows. If you skip the NULL and join checks, your queries will return answers that look right and are not.
We value your privacy
We use cookies to keep this website working and, with your permission, enable additional features, measurement and advertising. Accept all, reject all optional cookies, or learn more to customize your choices. Necessary cookies stay active.