Data Types in SQL with Examples
SQL (Structured Query Language) is everywhere, and in today’s digitalized world with massive amounts of data being gathered every day and stored into a database, knowing how to program with SQL is imperative. Whether you’re a marketer or an aspiring developer, SQL is a great language to learn.
String Data Type
CHAR – Char type is used to store a fixed length string that can contain alphanumeric include numbers, letters, and special characters etc.
VARCHAR – Varchar type is used to store only string variable with fixed length alphanumeric characters that can contain numbers, letters, and special characters.
BINARY – Binary type is equal to CHAR type but stores only binary byte data strings.
TEXT – Text type is store a string that can contain a maximum length of 255 characters.
ENUM -Enum type used only when a string contain only one value, where you have to select from a list of possible values.
BLOB – Blob type is used to store only for BLOBs type data value i.e. (Binary Large Objects).
Numeric Data Type
INT – INT type is used to store integer value.
FLOAT – Float type is used to store a floating point number.
DOUBLE – Float type is used to store a double point number.
DECIMAL – Decimal type is used to store a decimal point number.
BOOL – Bool type used to store only specify Boolean number values either true and false.
Date and Time Data Type
DATE -Date type is used to store only specify date format type in this format YYYY-MM-DD.
TIMESTAMP – TIMESTAMP type is used to store the timestamp data with the format of hour-minute-seconds.
YEAR – Year type is used to store data in a year format i.e. four-digit format.
SQL contains following topics at TCCI:
Course Duration: Daily/2 Days/3 Days/4 Days
Class Mode: Theory With Practical
Learn Training: At student’s Convenience
TCCI computer coaching institute is located in Bopal Ahmedabad and ISCON Ambli Road in Ahmedabad.
For More Information:
Call us @ +91 9825618292
Visit us @ http://tccicomputercoaching.com