2_Developing_presentation_l2_v2

SQL

datatypes

What do you remember from previous lesson?

SQL
Database
Advantages and disadvantages

Datatypes

Everyone knows what is datatype from previous courses, but does anyone know what datatypes are used in SQL?

SQL datatypes

SQL Data Types define the type of value that can be stored in a table column.

Number(Int)

Number(Integer) – datatype that define a whole, not a fraction number.

Date, Time, Datetime

Date, Time and Datetime are a datatypes that stores (obviously) date and time. Often, the rule of storing data for Date is “mm.dd.yy” and for Time is “hh:mm:ss”.

Varchar (Text)

Varchar (also a Text, short text or long text) is a datatype that stores a list of character (string in other words).
“Hello World!” is a sentence with “text” datatype.

Define datatypes:

Name: John
Surname: Smith
Date of birth: 11.05.1998
Age: 29
Blood group: A

Task

Give any 3 example on each datatype you’ve learned today.

Thanks for the attention!