From the course: Database Foundations: Data Structures
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
The role of data types
From the course: Database Foundations: Data Structures
The role of data types
- [Instructor] When we begin building databases, one of the first questions we'll need to answer is what kind of data will need to be stored. Being specific about the type is the first line of defense in protecting the integrity of your data. The basic Structured Query Language table-creation statement looks something like this. After the keywords CREATE TABLE, you'll name the new table. This part is easy because you can name it whatever you want. Choose a name that's descriptive of the data that will be stored in it and make it meaningful to your business. Next, list out all of the different columns that'll hold information about the various attributes that'll make up each data row. In this table for product data, I want to store each product's ID number, it's name, the supplier that manufactures the product, and its price. Just like the table name, column names can be whatever makes sense for your business. Finally, we…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.