SQL Tutorial - 6: Data-Types in SQL (Part-1) Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the sixth tutorial in this course and in
this tutorial we are gonna talk about
data types right and I have another
presentation here and this one's got
just three slides so I hope I don't bore
you much in this tutorial so anyway
what's up with data types you know you
must have heard people say this a lot
you know that data types all you need to
understand data types
pretty well if you're you know learning
programming and stuff what data types
are actually pretty simple right and
data type is a property that specifies
the type that you can put in your table
so as far as SQL is concerned what we
mean by data types is that you know in
the last tutorial we had look at the
table in which we had you know
information about tennis players so you
know if rank is a field and if you know
in that field you're only going to put
tennis rankings so all the rankings are
going to be numbers right so all those
numbers have some data type and you know
they can be integers or they can be you
know floating values like if they have
decimal values so what what we mean by
data type is that you know each value in
the table must you know be known to SQL
I mean SQL should be able to connect you
know that value to some datatype right
so you can either have characters or you
can have integers or if you're storing
images in your tables you know that's
possible as well so then you need to
specify the data type for the image
field in the field that's going to
contain images right and well this will
this will be clear in just a bit so each
field has a data type and all values for
a field must have the same data type so
let's have a look at this table here and
it's it's different from the table that
we saw in the last tutorial this one has
got one two three four four fields the
first one is serial number so I have
seen numbers one two three four five for
the five rows that I have in the table
and then I have another field called
name in which I have names for
superheroes and Hulk very well doesn't
really qualify as a superhero but I like
it very much so that's why I have
included
in here and then in the next column you
have age of the superheroes and then you
have email addresses of superheroes and
these are actually fake IDs so you know
if you're thinking about emailing
Superman then well this is not the
correct email address so you know please
don't use it so anyway that's a bad joke
so well to understand data types just
concentrate on any one field right so
let's concentrate on the name field and
you know the data type of the first
value in the column that's associated
with the name field is spider-man right
and so the data type is characters right
because all these are character values
and in the next column you again have
Batman which is a string of characters
then you have Ironman in the next which
is a string of characters and you have
Superman you have hulls so all these are
character values these are string values
that are made of characters right and
then serial number let's come to this so
serial number one is an integer it's a
number two is also an integer it's a
number three is number four is a number
and five is a number so all these five
values have the same data type so the
data type of this value here or you know
in a way the data type of this field
right so if you're gonna have more rows
then you know you're gonna have rows
like six seven eight nine ten so the
value for each row for this particular
field is going to be an integer number
so the data type of this field is
integer
it's int right and the data type of the
name field is you know character or
variable character and we're gonna see
I'm gonna talk about there are types in
more detail in the next tutorial but
just just you know just try to
understand this that you know all values
that are associated with the particular
field have the same data type that's
that's you know what do you need to know
and then age again is a number and if
suppose tomorrow you want to modify this
table and instead of mentioning age in
the table you want to mention the date
of birth of a superhero right so in that
case was prime - 30 years old so
subtract 30 from 2013 you get what 1983
right so if you want to put force
january 1983 as a value in this table
right so
you can do that by having a you know
another column and you can call it D or
B right there of birth or you can change
this and you can make this do B and in
that case the data type of the field
would change from number to date right
so date is again a data type you have
date you have date time and you have
time so you can store time in your data
in your tables you can store you know
dates in your tables and you can store
timestamps and there's so much you can
store and you know there are so many
data types we're going to check out some
of the most important ones in the next
tutorial right and then you have the
email field in which you've got email
addresses so do we have any more slides
now there are no more slides in this
presentation so that's it thank you so
much for watching this tutorial
I assume the next one in which we will
discuss data types in more detail and
please stick with me and I show you that
we're going to have fun and subscribe to
my channel case you have already and I
see you soon