Database is a place where data is stored in an organized way. Table is a data structure that holds data in rows and columns, much like a spreadsheet. You can think of each row as one record, and each column as one type of data.
Throughout this tutorial we'll use the Customers table and the Orders table as examples. Getting a good look at the tables first makes the queries much easier to follow later on.
You should see
Customers Table example +------------+--------------------+----------------+----------+-------------+ | CustomerID | CustomerName | ContactName | City | Country | +------------+--------------------+----------------+----------+-------------+ | 1 | Alfreds Futterkiste| Maria Anders | Berlin | Germany | | 2 | Ana Trujillo | Ana Trujillo | Mexico City | Mexico | | 3 | Antonio Moreno | Antonio Moreno | Mexico City | Mexico | | 4 | Around the Horn | Thomas Hardy | London | UK | +------------+--------------------+----------------+----------+-------------+ Learner note: CustomerID is like a unique identifier used to tell each record apart. Later on, when you do JOINs, ID columns like this become essential.