Exploring data tables

We have all used Microsoft Excel at some point in our life. In every Excel file, we see the following concepts:

• Workbook: This refers to the Excel file itself. From now on in our course, we will be using this word to refer to Excel files.
• Worksheet: Every workbook can have multiple worksheets that contain data.
• Row: Every worksheet consists of rows of data.
• Column: Every data row consists of multiple columns that contain different data values referring to the type of data each column holds.
• Cell: A cell in an Excel sheet contains a single value or a formula. Every row consists of multiple cells.

Similarly, a data table is a variable type that can store data in the same structural format as an Excelsheet.

You might wonder about the differences between a data table and a worksheet. A data table is a memory representation of a single database table that can hold multiple rows consisting of multiple columns of different data types...