Learning about basic data types of SQL

SQL data types define the type of value that can be stored in a table column, as well as the operations that can be performed on the column. For example, in the customers table, possible columns could be the following:

• customer_id (stores unique identifiers for customers)
• first_name and last_name (stores customer names)
• total_purchase (stores total purchase values)
• birth_date (stores the birthdate of customers)

Here, you can filter the customers by birthdate to get those who are turning 18, you can add recent purchases to the total_purchase field to have the latest purchasing history, and you can also search for customers with a specific name, such as Tom or Jerry. But you cannot add first_name and birth_date together because one is a string and the other a date, not numbers. SQL data types define the type of value that can be stored in a table column, as well as the operations that can and cannot be performed on the column. The basic data types...