In SQL, a table is like a spreadsheet. It’s where you store your data in a structured way. Think of it as a collection of rows and columns.
Relational databases store their information in tables, similar to spreadsheets. These tables, uniquely named and made up of columns and rows.
Table: Imagine it as the whole spreadsheet.
Column: Each vertical set of data. For example, if you have a table in the section below, you have columns for “studentID”, “name,”, “country”, “gender” and “year”, like number 1 in the below.
Row: Each horizontal set of data. So, if you have a person’s name in one row, their country in the next, and their gender in another, that’s a row, like number 2
Data types: Each column has a specific data type that defines the format of the data it can hold (e.g., text, integer, decimal, date). For example, the type of the data in “name” column.
Databases use tables, like boxes with categories, to hold their information. Each box, named and organized by rows and columns, makes it easy to find and manage data.