0:02
[Music]
0:11
hello friends welcome back to our
0:12
channel so in today's session we'll
0:15
discuss about the introduction to sql
0:26
introduction to sql
0:29
so first let us discuss about what is an
0:31
sql and what is the importance of sql
0:33
and then we will move on with the sql
0:35
what is uh what exactly we have to learn
0:37
in the sql
0:39
so sql
0:42
stands for
0:45
structured
0:49
query
0:51
language
0:53
structured query language and this sql
0:57
is used to
0:58
work with the databases
1:01
the main use of sql is
1:03
to work
1:05
with
1:07
database
1:11
so we know that database means the
1:13
collection of tables if it is a
1:15
relational database right there are
1:17
different types of database so we have
1:19
already recorded about the different
1:21
types of databases in our channel so
1:22
please go through that so the link will
1:24
be in the description section so if it
1:27
is a relational database so the data
1:29
will be stored in terms of tables so the
1:31
database will be having lot of tables so
1:35
table 1
1:36
similarly table 2
1:38
right
1:40
table 3 etc so we'll be having a
1:42
different tables in a single database
1:45
then if you want so what exactly there
1:47
will be in table
1:49
so a table will be having
1:51
data
1:53
right data
1:56
data so the data will be in terms of uh
2:01
rows and columns right rows and columns
2:04
so if you want to access this data ok if
2:07
you want to access this data that means
2:10
accessing
2:14
or
2:15
manipulating
2:22
on
2:24
data so we need a language called
2:27
structured query language
2:30
so this query language is used to
2:33
access or manipulate the data which is
2:36
available in the database
2:39
right so accessing means
2:41
reading
2:44
manipulation means
2:46
adding
2:48
or
2:49
removing
2:51
both what we can call it as a
2:52
manipulations right so everything will
2:55
be done with the help of this query so
2:58
without using the sql you can't access
3:02
or manipulate the data available in the
3:04
database
3:05
then
3:07
so in order to execute this sql we are
3:10
going to use a different
3:13
dbms
3:14
tools
3:15
different dbms tools right so those dbms
3:19
tools
3:21
so
3:24
mysql
3:27
sql server
3:31
oracle
3:32
so exit one etcetera are all the
3:34
different dbms tools so whatever the
3:37
tool we are using
3:39
the sql is a common language which is
3:42
used to access or manipulate the data
3:44
from the tables which are available in
3:47
the database
3:49
right so here the query names
3:53
the query means
3:55
commands
3:57
the query means commands so with the
3:59
help of commands we are going to access
4:02
the data accessing means reading or
4:05
writing so usually we call them as
4:09
current operations
4:10
we will call it as a
4:12
current operations so
4:17
all the third operations can be done
4:19
with the help of this query so current
4:21
operations means
4:23
create
4:24
so creating the database creating the
4:27
tables
4:31
read so accessing the data
4:37
update so we can update the data
4:43
delete
4:44
so we can delete the data from the table
4:48
so usually this we call it as a card
4:50
operations so create read update and
4:53
date now what can we do with the help of
4:56
this sql
4:58
so we are saying the accessing and
5:00
manipulation so a little bit elaborate
5:03
this term
5:04
i will little bit elaborate this term so
5:07
we can create a database
5:12
so everything will be done with the help
5:14
of a comments okay sql commands we call
5:16
them as sql commands
5:19
next
5:22
create table so inside the database we
5:25
can create the tables
5:30
alter database
5:33
so if you want to change the structure
5:35
of a database then also we can use the
5:38
item
5:41
alter table
5:44
altering the table that means updating
5:46
the table
5:57
reading data
6:00
so reading the data from the tables
6:07
update the data so we can update the
6:10
tables i mean the data tables data
6:16
delete
6:17
database so we can also delete the
6:20
database
6:22
we can also
6:24
delete the
6:25
tables
6:27
we can also
6:31
delete the data inside the table data
6:34
inside the table right so all these
6:37
operations all these operations
6:40
can be done
6:43
can be done
6:45
using
6:47
sql
6:49
comments
6:51
sql
6:52
comments
6:54
so for every operation
6:56
we have to
6:57
write some query squaring is a command
7:01
okay so here the commands are divided
7:04
into different categories so that we
7:05
have already discussed in the previous
7:07
session like dbms languages now once
7:10
again i will revise that one
7:12
so
7:13
now these sql commands are categorized
7:15
into different ways so let us see that
7:18
commands what are the different commands
7:20
and from the next sessions i will
7:22
elaborate each and every command i will
7:24
explain each and every command by
7:26
executing
7:28
in the
7:29
dms tool we'll use a sql server so which
7:32
is a free source so we'll execute each
7:34
and every command in the sql server
7:36
mysql
7:38
right so
7:39
here
7:43
sql commands
7:46
are divided into different categories
7:50
so let us take the categories
7:53
so one is
8:01
data definition language
8:06
so usually we call it as a ddl ddn
8:10
commands ddl commands
8:20
data manipulation
8:26
language so usually we call it as a dml
8:29
commands
8:30
dml commands
8:39
data control
8:43
language so usually we call it as a dcl
8:46
commands
9:00
so the next one is transaction
9:05
control
9:08
language which we call it as a tcm so
9:12
all the sql commands are categorized
9:15
into four waves one is a data definition
9:17
language data manipulation data control
9:19
and that transaction control right so
9:22
usually we call all these as a different
9:25
dbms languages we call it dbms languages
9:28
so
9:29
here data definition means which updates
9:32
the table okay which observes the table
9:35
structure
9:36
so the commands will be
9:40
create
9:43
alter
9:46
drop
9:48
create alter drop so these are very few
9:50
comments which changes the table
9:52
structure
9:54
and these are the data manipulation so
9:56
as the name indicates here the commands
9:59
which are used to change the data inside
10:02
the table
10:03
so selection in order to read the data
10:07
updation
10:08
we can update the existing data
10:10
insertion
10:12
we can insert the data
10:14
deletion we can also delete the data and
10:16
also here there is one more command
10:18
called truncate
10:20
truncate right and these are the few
10:22
commands which comes under the data
10:24
manipulation language
10:26
data control language
10:30
so grant
10:32
and
10:34
rebook
10:35
that means
10:36
so the database administrator will give
10:38
the permissions or privileges to the
10:40
users right so granting the services
10:43
to the user
10:45
and
10:46
taking back the permissions from the
10:48
user is a revoke so this comes under the
10:51
data control
10:52
right and transaction control
10:57
commit
11:05
roll back
11:07
commit and roll back so which will
11:09
confirm the transaction and which will
11:13
undo the recent transcription
11:15
so these are the very few comments okay
11:18
very few comments so comes under this
11:21
sql so data definition get a
11:23
manipulation data control and the
11:25
transaction control
11:27
right so this is all about our sql sql
11:30
is a structured query language which is
11:32
used to access the data from the
11:35
database so whatever the database
11:38
management tool you are using either
11:39
oracle or mysql or sql server so the
11:43
data can be accessed from the database
11:45
by using only the structured query
11:47
language where query is nothing but a
11:49
command
11:50
comment right so these commands are
11:52
divided in these categories so let us
11:54
stop here and in the next session we
11:57
will see all these commands one by one
12:00
so what is the syntax and how we can
12:02
create the database how we can create
12:04
the tables how we can read the data from
12:06
the tables how can we update the tables
12:08
so each and every command i will
12:10
demonstrate in the
12:12
mysql
12:14
right so let's stop here and this is all
12:16
about the introduction to
12:18
structured query language
12:21
so hope you understood this one and if
12:22
you are having any doubt regarding this
12:24
introduction feel free to post your
12:25
doubts in the comment section definitely
12:27
i will try to clarify all your doubts if
12:29
you really enjoyed my session like my
12:31
session share my session with your
12:32
friends and don't forget to subscribe to
12:34
our channel thanks for watching thank
12:36
you very much