On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
1. Welcome
Referring to other tables
INSERT, UPDATE, and DELETE with subqueries


Welcome to Part 4 of "PostgreSQL INSERT, UPDATE, and DELETE Commands." Today, we will learn about using INSERT, UPDATE, and DELETE operations that refer to other tables. Knowing how to use these structures will enhance your PostgreSQL skills.

First, let's familiarize ourselves with the database we will be working with. The database of an online store has four main tables: customer, employee, product, and purchase. The store wants to add a reporting and archiving system. In this part, you'll be helping the staff fill in new reporting and archiving tables.


Click Next exercise to continue.