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.

Numeric data types

Numeric data types

From the course: Database Foundations: Data Structures

Start my 1-month free trial

Numeric data types

“

- [Instructor] The most common type of data stored in a database is almost certainly numeric values. Everything from financial data to scientific measurements, to video game scores are recorded as numbers, and relational databases provide many different ways to store these values. Now at first you might be thinking that numbers are numbers. How many different ways can you possibly store a number? But when you look really close at their details, you'll find that numeric data can be categorized in different ways. And building a database table that focuses on the one, single category of a number needed for a particular task will help keep things organized and efficient. There are three main variations to choose from when storing numeric data: exact integers, exact decimals, and approximate numbers. Let's take a look at each one. Exact integers are going to be used most often. Integers are whole numbers that do not include a…

Contents