Student Reviews
( 5 Of 5 )
1 review
Video of The Best Way to Store Phone Numbers in an SQL Database in Database ERD Principles course by Database Star channel, video No. 17 free certified online
Get my Database Design Guides to many different sample databases: https://www.databasestar.com/dbdesign/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign72
Turn your idea into a real database: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign72
Phone numbers are a common field to store in a database. However, storing them as integers can cause problems.
In this video, I'll demonstrate an example of storing a phone number as an integer, explain a problem, propose a better way to store phone numbers, why it works, and show an example.
You'll also learn about formatting of phone numbers and my recommendation for that.
TIMESTAMPS:
00:00 - Introduction
00:42 - Storing a phone number as an integer
02:32 - What is a phone number?
03:26 - Another way
04:56 - Formatting phone numbers