The fact is, you do really need to understand these tables.

Why?

Because without understanding the information each table is storing and how the tables relate to each other, you won’t be able to build sql queries for them easily.

So don’t skip this section! :)

The sample tables used throughout this course are part of an order management system used by me, a fictional distributor of kool keyboards !

These tables are used by my database engine and my staff to perform several tasks:

Manage vendors

Manage product catalogs

Manage customer lists

Enter customer orders

Managing all of this data takes up five tables.

These five tables are connected to each other through common shared columns.

Now let me introduce you to each table - one by one.