Databases and tables

Learn more about structuring and organizing your data

Databases

A database is a collection of data structured so that you can easily search for and retrieve items.

If you take a closer at our logo, you might recognize the standard symbol for databases in it. At least, that’s the idea behind it…

Tables

Tables contain data. A table is a database object that stores data in records (rows) and fields (columns).

The data usually relates to a specific category of people or things, such as employees or orders. You’re probably familiar with this from using Excel spreadsheets.

A database can consist of various tables.

Table structure

Tables are really important when it comes to databases. That’s why we would like to take a look at their structure. But don’t worry, we’ll come back to them again when we work through an example in a moment.

  Horizontal = Row and 1 row contains 1 record. Vertical = Column, data of the same type, e.g. last name