Database for Digital Marketers — 1.1 (filters, aggregates & joins)

Filters and Aggregates

To represent the data sets (discussed in the previous article) in the database, we will need to create 3 tables:
Customers — Holds customer Information
Products — Holds Product Information
Orders — Hold information about orders of customers that bought the Company Products.
Once the tables are created, create a database diagram and drag all the three tables to get an overview of all tables (above).