Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
3. Columns and rows


Tables in databases look exactly the way you would imagine a normal table – they have columns and rows.

Columns in every table have their names and they identify the kind of information is stored in them.

Each row stores information about one object. In the student table below, you can see that the column names reflect the kind of data contained in them, so in the column name there are names of students, in the column graduation_year there is the year of their graduation, etc.

Each row corresponds to exactly one student.

id name year_born graduation_year
1 Kyle Lawson 1992 2015
2 Santiago Knox 1991 2015
3 Arian Sheppard 1990 2013
4 Samuel Foster 1991 2014
5 Hayden Smith 1986 2010


Click Next exercise to continue.