SQL Tutorial - 28: Aliasing Through AS Clause Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 28th tutorial in this course and in
this tutorial we are going to talk about
aliasing through the as clause in SQL so
I've got a very simple query in the
MySQL workbench window and this query is
going to pull out three columns from the
tutorial table the first one is title
the second one is uploading scored and
the third one is tutorial so let me just
execute this query and show you guys the
result so there you go you see that in
the result set we have three columns and
then you know the data that we have in
the table for the three columns now
suppose you want to see you know
different headers for these columns in
the result set what I mean by that is if
instead of duration you want to see
length as the column header and if
instead of uploading score date you want
to see upload space date in an either
way as the column header and fin stead
of title in all small case you want to
see t that is the first alphabet in
capital case and rest of the alphabet in
alphabets in small case so if you want
to do such things and you have to use
the as clause and it's really very
simple all you have to do is after you
type in your column name you give a
space and then type in as and then type
in the way in which you want your column
header to be displayed right so if I
want t capital then I type in t capital
and then TI tle that's title and then if
I want to see upload underscore date as
upload space state then I type in that
but since upload and date are two words
and since I'm going to put a space
character between the two words
I'll have to put both the words within
single quotes right because that's
that's that has to be read by SQL as a
string so I'll type in upload space date
right and since I want to see duration
as what do you call length I'll type in
that right now when I execute this query
I see that I get the same information in
the result set but I see different
column headers now so I have title and I
have a float space Diana I have length
so aliasing is pretty useful and
aliasing basically means giving
different names to you know
things so you know title here is an
alias for the earlier title and upload
space station is a alias for you know
upload and score date so I hope you guys
had fun watching this tutorial I'm going
to see you in the next one and you may
subscribe to my channel if you haven't
already and take care