Understanding SQL Tables

Understanding SQL Tables

Now that we’ve spent some time learning about databases, let’s talk about the building blocks of databases: Tables.

• A database table is a collection of related data consisting of rows and columns.
• Rows run horizontally and represent a record.
• Columns run vertically and represent a field
• Typically, in a database, you’ll have multiple tables representing either an entity like an Apartment or a User, or action that’s being tracked, like Apartment Bookings
• If you’re wondering why tables in a database get broken up this way, don’t worry we’ll cover that in a different course later this semester when we talk about Database Normalization.