0:02
[Music]
0:12
hello friends welcome back to our
0:13
channel so in today's session we'll
0:15
discuss about one more topic in dbms
0:17
that is dbms languages
0:22
dbms
0:24
languages
0:28
so in dbms there are more number of
0:31
languages which are used to
0:34
access with the data using the sql
0:36
queries so we'll see what are the
0:38
different languages and what are the
0:40
commands example commands comes under
0:43
those languages
0:44
so
0:45
the first one
0:47
is a called ddl which is stands for
0:51
data
0:55
definition
0:57
language
0:59
data definition language
1:01
and the commands under this ddl
1:04
is used to define the structure as the
1:06
name itself indicates data definition
1:09
language
1:10
so defining the database means defining
1:13
the structure of the database that means
1:15
creating the schema creating a tables
1:18
with a logical constraints everything
1:20
will be done by using the commands of a
1:23
ddl data definition language okay so it
1:26
will use to
1:28
work with the structure of database not
1:31
the data of database okay so the
1:33
database will be having some data but
1:35
these ddl commands will work on the
1:37
structure that means the skeleton of
1:39
database right so the commands comes
1:42
under this ddl are the first one
1:45
create
1:47
so this command is used to
1:49
create a database i mean tables or
1:52
objects okay create a tables or objects
1:56
and the second one
1:58
alter so this command is used to
2:01
alter the structure of database
2:04
alter the structure
2:08
of database so altering the structure
2:11
means
2:14
adding some more attributes okay
2:16
removing some attributes whatever it may
2:18
be that will comes under this alter ok
2:20
alter
2:22
next one
2:25
drop so this is used to
2:28
delete the table entire table okay not
2:31
the data so all these commands will be
2:33
working on the structure of database
2:36
schema okay not the data in the database
2:39
and the next one
2:41
truncate
2:43
so this truncate is used to
2:46
remove
2:47
all the records all the records of
2:50
database
2:53
all the records of a table
2:56
okay so
2:59
these are the few commands comes under
3:01
the data definition language so that's
3:04
the first language
3:05
and the second one
3:09
dml
3:10
so dms stands for
3:12
data
3:16
manipulation
3:19
language
3:20
so here
3:23
the name itself indicates data
3:25
manipulations that means whatever the
3:27
manipulations
3:28
we are going to do on the data that
3:31
command still comes under this dml
3:34
so first one
3:36
select
3:37
so select command is used to retrieve
3:41
the data from the database that means if
3:43
you want to get the data so we are going
3:45
to use the command called select okay so
3:51
retrieve
3:52
data
3:54
from database
3:57
so for example consider some student
4:00
table so i need to get the student
4:02
details
4:03
uh
4:04
all the student details who got greater
4:06
than 90 percent so we need to get the
4:10
selective data from the table student so
4:13
for that purpose we are going to use
4:14
this select command select command
4:18
and the next one
4:21
insert
4:22
so insert command is used to insert the
4:25
data into database so if you want to add
4:28
a student details so this insight method
4:30
will use used to insert the rows
4:33
of a table rows into a table right so
4:36
this is used to insert
4:39
data
4:40
to the database
4:43
to the database
4:44
and the next one
4:46
so quite opposite that is a delete
4:50
and this delete command is used to
4:52
delete
4:53
a single row or a multiple rows or all
4:56
the rows from the table so it is
4:58
somewhat diff different from a time
5:00
truncate so truncate will remove all the
5:02
rows of a database but here delete is
5:05
used to
5:06
delete an individual row or multiple
5:08
rows or all the rows of a table right
5:11
based upon the condition we can delete
5:13
the rows of a table for that purpose we
5:15
are going to use this delete command
5:18
so it is used to delete
5:22
single or
5:25
multiple
5:28
or
5:30
all the records
5:32
all the records
5:35
right so for that we are using delete
5:38
and the next one
5:40
update
5:42
so this update command is used to update
5:45
the data okay not the skeleton not the
5:48
structure
5:49
right so here we are updating the data
5:51
for example the student so the student
5:55
coming to the student details so if he
5:58
got some percentage
6:00
okay so if we want to update the
6:02
percentage okay now not the skeleton so
6:05
if you want to update the value okay
6:08
update any value of an attribute that
6:10
will be done with the help of this
6:12
update command right update the data not
6:15
the skeleton so
6:17
update the data
6:22
so these are very few commands comes
6:24
under this data manipulation language so
6:26
these are all the commands which are
6:28
used to
6:29
manipulate the data in in the database
6:31
and this is a ddl which is a data
6:33
definition language which will
6:36
define the structure of a database that
6:38
means a skeleton of a database
6:40
right so these two are the languages and
6:43
we'll see the third one
6:45
that is
6:48
data control language
6:53
the third one
6:56
data
6:57
control
7:00
language
7:04
so the control over accessing the data
7:07
so the commands which we give the
7:08
control over accessing the data so that
7:11
means we are having a two commands
7:13
one is a grant so this command is used
7:16
to give the privileges for the user to
7:19
access the database okay so
7:22
giving
7:23
privileges or permissions
7:28
privileges
7:30
to the user
7:33
to access
7:37
database
7:39
okay giving some permissions so what
7:41
type of permissions so that will be done
7:44
by this grant command the next one
7:49
revoke
7:50
so quite opposite for the grant so
7:52
taking all taking back the permissions
7:55
from the user okay so this is one
7:59
taking back
8:02
the permissions
8:07
or privileges
8:10
given to user
8:13
given to user taking back the
8:15
permissions given to
8:16
uh given to the user right so these two
8:19
comes under this data control language
8:21
so controlling the accessing of data
8:24
from the database right and the fourth
8:26
one
8:27
the fourth language
8:31
is a transaction control language
8:40
so this is a
8:42
dcl
8:44
and this is a tcl which is
8:49
transaction
8:54
control
8:57
language
8:59
so
9:00
these are the commands
9:02
comes to
9:03
based upon the transactions okay coming
9:05
on the transactions so whatever the
9:07
transactions we are doing so
9:10
the commands comes under this
9:11
transaction processing okay so the fund
9:14
is
9:15
commit
9:18
so this command is used to
9:20
save the transaction to the database
9:22
okay
9:23
save the transaction
9:30
save the transaction
9:32
to the
9:33
database
9:37
and coming to the next one that is
9:40
rollback
9:42
rollback is to
9:44
undo the transactions which
9:47
being done in the latest right that
9:49
means cancelling the transaction which
9:51
was done recently right so
9:54
undoing the transaction undo the
9:56
transaction or under the recent
9:59
transaction
10:02
undo the recent transaction
10:04
so that will be done by using this
10:06
rollback so these two commands
10:08
will be work on the transactions so
10:10
these two commands comes under the
10:12
transaction control language so
10:16
we have discussed very few comments so
10:18
there are a lot of comments so these are
10:20
the very few comments comes under this
10:22
languages so data definition language
10:24
data manipulation language data control
10:26
language and transaction control
10:28
language so
10:30
once we see the summary
10:32
and we'll close the session right so
10:35
let me write the commands and languages
10:38
as a summary
10:40
so this languages
10:41
comes under
10:43
four categories
10:44
so one is d d l
10:47
another one is d m l
10:50
another one is d c l
10:53
and the last one is t c l so the
10:56
comments comes under this d d l are
10:59
create command
11:01
so very few comments there will be a lot
11:02
of comments but i am writing only few
11:04
comments
11:05
so alter
11:09
drop
11:14
truncate so these are the very few
11:15
comments and also rename okay in order
11:17
to rename the
11:19
table
11:20
so we'll use this
11:21
ddr right so rename and if the commands
11:24
comes under this dml
11:26
uh select
11:30
insert
11:34
delete
11:39
update
11:40
so these are the few commands comes
11:42
under this dml data manipulation
11:44
language coming to the dcl
11:47
which is
11:48
grant
11:52
revo so these two are the commands which
11:54
are used to control the
11:57
database right so
11:59
next one
12:00
commit
12:04
and roll back
12:06
and run that so these two commands comes
12:08
under all the transaction control
12:10
language so these are the different dbms
12:13
languages which are used to work with
12:15
the database using the queries
12:18
right so in the further concepts once we
12:21
got into the sql so you will be knowing
12:23
about all these commands so we have to
12:25
write the commands or we have to write
12:26
the queries instead of writing the
12:28
commands we have to
12:30
pronounce it as a queries so we have to
12:32
write the queries so while writing the
12:34
queries you will be understanding about
12:36
each and every command here right so we
12:39
will see the syntaxes in the sql
12:42
right so hope you understood this dbas
12:44
languages and if you are having any
12:46
doubts regarding this one feel free to
12:47
post your doubts in the comment section
12:49
definitely i will try to clarify all
12:50
your thoughts and if you really enjoyed
12:52
my session like my session share my
12:54
session with your friends and don't
12:56
forget to subscribe to our channel
12:58
thanks for watching thank you very much