Now let us discuss briefly what a table is. Now a database consists of one or more tables. A table comprises rows and columns. Essentially, if you will look at an Excel spreadsheet, you'd see that you have rows depicted by numbers and you have columns depicted by letters. So in the cell A one, you would have some amounts of data, and usually you would create some form of tabular structure. Let's say for instance, for the list of students and you have an Excel spreadsheet, you'd have a sheet post students, and then you would have columns first name, last name, date of birth, etc.

And then in each cell underneath the respective columns, you would have the appropriate bit of data to support that value. Together. This record or rule would create a description of an object or a student's. So in the same way that we can visualize data in an Excel spreadsheet it is is the same way that it is represented in an SQL table. So we have rows and we have columns. And rows, create records under meetup have data points.

And each column in the table stores the data point, which can be in the form of text or a number or a date, but many data types that are supported. And all of these combined to tell us details of an object. So that's essentially what a table looks like in a database. And then in the same vein, each row or record should be uniquely identifiable using what we call a primary key. So in the next video, we'll go about creating an table. Remember our database is called school and we will go about creating our first table to store all of our students stick around.