SQL Tutorial - 14: The SELECT Query Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 14th tutorial in this course and in
this tutorial we are going to talk about
the Select query now the Select query is
one of the most important commands in
SQL and as you can see on the slide it
is used to get data from tables in a
database and in this tutorial we are
going to see how we can use this read
query to pull out the information that
we need from a table right so the syntax
of Select query is pretty simple it has
just two keywords in it and first one is
the Select keyword and after the Select
keyword you have to specify the names of
the fields or columns that you want to
see in the results side and then you
have the from keyword and after that you
type in the name of the table from which
you want to pull out your data so next
we are going to see how we can use the
Select query to pull out information
from the employee table in the MySQL
workbench so I've got my MySQL workbench
here and in the test database I've got
two tables at the moment the first one
is the employee in employee table and
the second one is the EMP underscore
info table and before I use the Select
query to you know get data from the
employee table let me just describe it
and show you guys what all columns it
contains right so this table is familiar
with this table we've seen it quite a
lot of times and we know that it has the
ID fee the name field the date of birth
field and the email field right and it
also should be having some data in it
and we're going to pull that data out
using the Select query so I'll type in
SEL ect that's select and then the names
of the columns that I want to see so let
me pull out data from the name field and
the email field on the next line I'll
type in the from keyword and then the
name of the table which is employee for
a semicolon at the end to terminate the
statement when I press control enter I
see that at the moment I've got two rows
in the table the first one has the value
mother in the name field and you know
mother dot party at hotmail.com in the
email field and then it got its called
ABC in the name field in the second row
and ABC at gmail.com as the value for
the email field in the second row now
suppose you want to pull out information
from all the fields in the table what do
you do in that case you type and select
right and then you put in the Astra
character so the Astra character stands
for all columns in the table and then on
the next line you type in the from
keyword as was the case with the last
way that we execute it and then the name
of the table which in this case would be
employee and put a semicolon and when I
press control enter I see that I get you
know the the records and this time I get
data for all fields right so I see the
values in the ID field as well as the
values in the DOB field right so these
fields were not present in the previous
case where and I mentioned the names of
columns that I wanted to see in the
result set and in the you know last way
that we executed we replace the names of
columns by the Astrid character which
stands for all columns right so the
Select way is as I said it's one of the
most important commands in SQL and we'd
be using it a lot so you know it's a
very easy way to pick and I'm sure you
guys are already comfortable with it so
I'll see you in the next tutorial where
and we'll discuss something interesting
and important again for sure so please
subscribe to my channel in case you have
already in I see you soon