Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Writing User-Defined Functions in PostgreSQL

Custom logging
Loading Customers
4. The dim_customer table
Subscriptions
Congratulations

Instruction

Now, let's review two more tables we're going to work with in the next exercises: dim_customer and stg_customer.

Let's start with the first table – dim_customer. It is the main table that contains all the customers we have in our system. This table is updated regularly based on the new data we receive weekly via the stg_customer table.

Exercise

Let's review the structure of the table – select the top five customers from the dim_customer table, sorted by date_of_first_purchase in ascending order.