End of Summer - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
2. The data model
Customer cohorts
Summary

Instruction

The data model we'll be using throughout the course was created by our team. It's based on Microsoft's "Northwind" data model. You can find the original database here.

Our modified database consists of eight tables. You can see the entire database diagram below. Don't worry if you don't understand everything – we'll introduce and explain each new table as we come to it.

Let's start by taking a look at the customers table.

Exercise

Select all the information from the customers table.

The table contains basic information about each customer, such as their name and email address. Pay attention to the registration_date column – we'll use it in a second.

Stuck? Here's a hint!

Use:

SELECT *
FROM customers;