From the course: Database Foundations: Intro to Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Table columns

Table columns

From the course: Database Foundations: Intro to Databases

Start my 1-month free trial

Table columns

“

- Before you can store data in a database, you need to build a home for the data to live in. So let's talk for a few minutes about constructing tables. Tables are made up of columns and each column stores a single piece of information. In our libraries books table, we might have a column that stores the unique book identifier number, it's title, publication date and the identifiers that link to the author and publisher tables. Each of these columns, stores one piece of information about each book. And together, they make up the full set of details that we want to store in the database. In order to create this table using SQL commands, we need to identify a couple of details. The first one is easy. We need a unique name for each column. The name should be descriptive and not contain any confusing acronyms. And it's best if the column name doesn't include spaces. When you do, things get a little bit more complicated when…

Contents