Lesson 2: Tables

SQL and Tables

What is a Table?

A table is an arrangement of data in rows and columns, or possibly in a more complex structure. Columns form the table’s structure, and rows form the content. Table rows are the table’s actual data elements.

You can think of a table in SQL as a type of an entity (ie. Movies), and each row in that table as a specific instance of that type (ie. ‘Fast and Furious, ‘Black Panther’, etc). This means that the columns would then represent the common properties shared by all instances of that entity (ie. title, release year, genre).

Example:

The following table has 2 rows and 3 columns:

Column 1 Name	Column 2 Name	Column 3 Name
Row 1 Column 1 Data	Row 1 Column 2 Data	Row 1 Column 3 Data
Row 2 Column 1 Data	Row 2 Column 2 Data	Row 2 Column 3 Data