0:02
[Music]
0:11
hello friends welcome back to our
0:13
channel so in today's session we will
0:15
discuss about one more concept in
0:18
dbms that is
0:20
what is data
0:29
what is a database
0:38
what is a dbms
0:45
what is a sql
0:49
so all these are related to our database
0:52
management system so we'll discuss
0:55
what is what
0:57
so first coming to the data
1:00
so a data is an information which is
1:03
unprocessed data right it's an
1:05
unprocessed data
1:09
unprocessed data
1:12
so there is no structure for the
1:14
particular data so only the data which
1:16
is
1:18
saved in an electronic mode
1:20
and coming to the database
1:22
this data is organized
1:26
here
1:28
organized data
1:30
right so the storage of organized data
1:34
is known as database
1:36
so here we'll be having a different
1:38
models so based upon the model the data
1:41
will be organized for example so coming
1:44
to the
1:45
rdbms
1:47
so that means a relational database
1:48
model
1:49
okay relational database model
1:52
so in this rdbms the data is stored in
1:57
terms of
1:58
rows and
2:01
columns
2:02
rows and columns simply we can say them
2:05
as a
2:06
tables the data will be stored in the
2:08
form of tables so one database can have
2:12
a multiple tables right so whatever the
2:15
unprocessed data is available that data
2:18
will be
2:19
processed in an
2:21
it there that means
2:22
it will be
2:23
stored in a organizer fashion right so
2:26
that we call it as a database and
2:28
database
2:30
a database can have
2:32
multiple tables
2:35
multiple
2:36
tables okay
2:38
so that means data multiple data can be
2:40
stored in terms of our tables
2:42
and then the extension for this database
2:45
is dot db so that means we can store all
2:49
these tables in a single file called
2:52
dot db so every file will be having the
2:55
extension similarly the database files
2:57
are also having the extension this dot
3:00
db
3:02
then what about this dbms
3:04
now we had an unprocessed data and that
3:08
unprocessed data is organized in a
3:10
structured fashion which we call it as a
3:13
database and now if you want to access
3:16
the data that means manage the data
3:19
managing the data means edition that
3:22
means adding some data or deleting some
3:24
data or updating some data so all type
3:27
of manipulations can be done with the
3:29
help of this tool
3:31
so
3:32
dbms dbms is a tool
3:36
which
3:37
is used to
3:39
manage the database manage the database
3:41
means manipulations doing the
3:43
manipulations by adding the data
3:45
inserting the data right whatever the
3:47
manipulations we can do that can be done
3:49
with the help of this tool dbms is a
3:52
software or a tool which is used to
3:55
manage the data from the database an
3:58
example for this dbms are
4:01
like oracle
4:02
[Music]
4:04
mysql
4:07
sql server
4:11
mango db
4:15
sqlite
4:17
so there are
4:18
more number of tools available
4:20
in the dbms right
4:23
so in order to access the data from the
4:26
dbms oh sorry database
4:29
right to manage the database so
4:32
this dbms is a software tool and
4:34
database is a collection of organized
4:37
data so in order to process this data
4:40
that means in order to process the data
4:42
we need to retrieve the data so if you
4:44
want to add some data if you want to
4:46
delete some data if you want to update
4:48
some data so that can be done with the
4:51
help of one language called structured
4:54
query language so structured query
4:56
language
4:57
so sql sql is a structured query
5:00
language
5:01
which is used to
5:07
manage the
5:08
data
5:10
in a database
5:13
that means if you want to insert the
5:14
data that should be done with the help
5:16
of one command that is sql if you want
5:19
to delete the data data will also be
5:21
done with the help of sql so we commonly
5:24
call them as
5:26
queries so we have to write the queries
5:29
and by means of queries only we can
5:32
manipulate the data from the database so
5:34
here the term manipulation means both
5:37
additions or deletions or updations
5:39
whatever it may be retrieval so whenever
5:42
it is required so we can retrieve the
5:44
data from the database for everything we
5:46
have to write the queries so this
5:48
queries we call it as structured query
5:51
language so with the help of structured
5:54
query language
5:55
so
5:56
the data data from the database will be
5:59
retrieved by using this dbms tool so
6:02
even though there are a lot of dbms
6:04
tools
6:05
so in all the cases
6:08
in the back end it will generate a query
6:10
and by executing the query the data will
6:12
be accessed from the database so without
6:16
the query the data cannot be accessed
6:18
from the database so dbms will be using
6:20
this sql commands to access the data
6:23
from the database so this is the major
6:27
difference between the data database
6:29
dbms and sql
6:32
hope you understood so data is an
6:33
unprocessed data and if the unprocessed
6:37
data is organized in a structured manner
6:39
that we call it as a database and
6:42
accessing that managing this database is
6:44
called
6:45
is done with the help of a tool called
6:47
dbms
6:48
and
6:49
the data is accessed from the database
6:51
with the help of
6:52
sql
6:54
structured query language
6:56
right so
6:58
hope you understood this one so if you
6:59
are having any doubts regarding this one
7:01
feel free to post your doubts in the
7:03
comment section definitely i'll try to
7:04
clarify all your doubts if you really
7:06
enjoyed my session like my session share
7:08
my session with your friends and don't
7:10
forget to subscribe to our channel
7:12
thanks for watching thank you very much