2_Developing_presentation_l2_v2
Оценка 4.7

2_Developing_presentation_l2_v2

Оценка 4.7
pptx
09.05.2020
2_Developing_presentation_l2_v2
2_Developing_presentation_l2_v2.pptx

SQL datatypes

SQL datatypes

SQL

datatypes

What do you remember from previous lesson?

What do you remember from previous lesson?

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

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

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

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

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

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

Number(Int)

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

Date, Time, Datetime Date, Time and

Date, Time, Datetime Date, Time and

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

Varchar (Text) Varchar (also a

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:

Define datatypes: Name: John Surname:

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

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

Task

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

Thanks for the attention!

Thanks for the attention!

Thanks for the attention!

Скачать файл