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:

Basics of SQL, More advanced SQL queries, Relational Queries, Modifying Database

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