0:06	hello everyone i welcome you all to this
0:09	wonderful course on
0:11	database management systems before we
0:14	start the session let's see a quote by
0:17	alan coven
0:18	do not wait until conditions are perfect
0:21	to begin beginning makes the conditions
0:24	perfect with this wonderful quote let's
0:27	begin this journey with the introduction
0:30	before we step into the introduction to
0:33	the subject i just wanted to give an
0:36	analogy to understand the significance
0:38	of having dbms in our day-to-day
0:41	activities
0:42	just assume i am owning a manufacturing
0:45	company where i manufacture pens and
0:48	pencils do you guys think that
0:50	manufacturing alone enough without
0:52	storing the data about the manufactured
0:54	items
0:55	i would say no just manufacturing a loan
0:58	is not sufficient we need to maintain
1:00	the complete database of all the
1:02	manufactured items and not only this we
1:05	are also required to maintain many more
1:08	data
1:09	why it is so let's take this pencil as
1:12	an example once this pencil is
1:14	manufactured the details such as the
1:16	length of the pencil the color of the
1:18	pencil
1:20	the date of manufacturing of this pencil
1:24	the price of the pencil
1:26	the model of this pencil qr code barcode
1:30	batch location and other details have to
1:33	be stored in the database
1:35	why do we need to store all this
1:37	information in the database say here we
1:39	are storing the length the color the
1:41	date of manufacturing price model qr
1:44	code barcode all the required data we
1:46	are storing why we need to store all
1:49	these data permanently because data is a
1:52	precious thing and will last longer than
1:54	the system themselves
1:56	and also in today's world data is the
1:59	new signs so from this what we are
2:02	understanding is i am the manufacturing
2:04	company owner and i am producing pens
2:06	and pencils and i am storing all the
2:08	information about the manufactured items
2:10	in my database let's assume one of my
2:13	customers has raised a complaint about
2:15	one manufactured item it may be a pen or
2:18	a pencil
2:19	as the owner it's my ultimate
2:21	responsibility to look into the customer
2:23	complaint because customers are the
2:26	kings of any business for example let's
2:28	assume i am collecting the barcode or
2:30	the qr code of the faulty pin or pencil
2:33	once the qr code or the barcode of the
2:35	faulty pen or pencil is collected using
2:38	these data we can find out what has gone
2:40	wrong with the manufactured item and
2:42	this is possible only when we store all
2:44	the information in our database do you
2:47	think it is ridiculous that customer is
2:49	complaining about a low cost item no
2:51	certainly it is not a ridiculous thing
2:53	because customers are not only customers
2:55	they are the actual consumers of the
2:57	product and they have all rights to
2:59	express their satisfaction appreciation
3:02	give feedbacks give suggestions and even
3:05	complaints if a complaint is received
3:07	about a particular item then it's my
3:09	responsibility as the owner to also
3:11	check the whole batch or the particular
3:14	date of manufacturing for further
3:16	analysis to know only one item is faulty
3:18	or the whole batch is faulty why the
3:21	manufacturers need to do this because
3:23	they need to sustain in the market and
3:25	grow well in the market and not only
3:27	that to be involved in continuous
3:30	improvement to file taxes regularly and
3:32	they need to be transparent when they
3:34	will be transparent when all the data
3:37	about the manufactured item is stored
3:39	permanently only then they will be
3:41	accountable so i mean to say if we want
3:44	to be transparent and accountable
3:46	all data must be well documented to be
3:49	precise all data must be well maintained
3:52	in a database like this in this analogy
3:54	the data that we maintain includes not
3:57	only the manufactured items but also the
4:00	employee or the hr details the accounts
4:02	finance the research and development
4:04	details the complaints and redressal
4:06	details the logistics details sales and
4:09	many more and storing all these data is
4:12	strongly recommended and where the
4:14	organization is going to store is it
4:16	going to store in the files no it's
4:18	going to store all the data in a
4:20	database like this
4:22	why do we need to store the data in the
4:24	database like this and that's why we are
4:26	here in this subject the database
4:29	management system be it any industry or
4:31	organization databases are inevitable
4:34	trust me guys whether it is a
4:36	manufacturing company or an hospital
4:38	environment a school or a university
4:41	banking environment airlines supermarket
4:44	insurance and whatnot databases are
4:46	inevitable so from this what we
4:48	understood all the data must be stored
4:51	in the database permanently about all
4:53	the manufacture details in addition we
4:56	need to maintain all the data possible
4:58	to be transparent and accountable
5:01	so far we have seen an analogy to
5:03	understand the importance of having dpms
5:05
in our day to day activities let's now
5:08
see the target audience of this course
5:10
to whom this course is actually intended
5:12
to this course is actually intended to
5:14
the ug students
5:16
if you are an aspirant undergoing
5:18
competitive exams like gate isro or any
5:21
other competitive examinations then you
5:23
are in the right place if you want to
5:25
demystify the database technologies and
5:28
jargons used in the database world
5:30
welcome to this playlist and in this
5:32
contemporary world we have the
5:34
requirement for data analyst and
5:36
business analyst for which database
5:38
knowledge is very much essential we have
5:41
just seen the target audience let's now
5:43
see the syllabus of this course
5:45
in this subject we are going to see 14
5:47
chapters chapter number one is
5:50
introduction to the relational database
5:52
management system simply rdbms in second
5:55
chapter we will be focusing on the
5:56
relational database in third chapter we
5:59
will be focusing on database design and
6:01
the entity relationship model simply
6:04
called as er model in the fourth chapter
6:06
we will be focusing on introduction to
6:08
the structured query language sql which
6:10
is one of the popular database languages
6:13
and in chapter 4 we will be dealing
6:15
about the basics of sql in chapter 5 we
6:18
will be focusing on the advanced sql
6:20
features like the procedures triggers
6:22
functions etc in chapter 6 we will be
6:25
focusing on the formal relational query
6:27
languages the double relational calculus
6:30
and the domain relational calculus we
6:32
will also be focusing on the relational
6:34
algebra in chapter 7 we will be focusing
6:37
on the normalization and the various
6:39
normal forms with the dependencies the
6:41
functional dependency the full
6:42
functional dependency partial dependency
6:45
transitive dependency joint dependency
6:47
multi-value dependency and many more
6:50
with relevant examples and in chapter 8
6:52
we'll be focusing on storage and file
6:54
structures because databases directly
6:57
deals with the storage of data so we are
6:59
required to know the basics behind the
7:01
storage and the file structure in order
7:04
to improve the performance of the
7:05
database we need chapter number 9 which
7:07
is indexing and hashing and chapter
7:10
number 10 deals with query processing
7:12
and query optimization we know databases
7:15
are going to respond to the queries that
7:16
we supply so we need to process the
7:19
query and we need to optimize the query
7:21
in order to achieve better performance
7:23
and efficiency chapter number 11 deals
7:26
with the transactions and concurrency
7:28
control chapter number 12 we will be
7:30
dealing about the database system
7:32
architectures which includes the
7:34
distributed database architecture the
7:36
parallel databases etc and chapter
7:38
number 13 we will be seeing the
7:40
introduction to the data warehousing and
7:42
data mining techniques and then we will
7:44
be concluding the subject with the last
7:46
chapter the 14th chapter xml and
7:48
advanced databases we are done with the
7:51
syllabus of dbms let's now see the scope
7:55
you may be asking me what's the use of
7:57
studying this subject
7:59
this subject is very very important
8:00	because in every organization which uses
8:03	database there is a key responsible
8:06	designation the database administrators
8:08	simply called as dbs he is the one who
8:11	has the complete privilege over the
8:13	complete database
8:15	if you want to become a database
8:16	administrator then obviously we need the
8:19	subject database management system and
8:21	already mentioned we have data analyst
8:24	and business analyst job opportunities
8:26	as well and if you study dbms then this
8:28	is going to be the basics for acquiring
8:30	the job in the data analysis or business
8:32	analysis market and not only that
8:35	industries are nowadays looking for
8:37	employees who are full stack developers
8:40	they are not going to deal with only the
8:42	front-end development activities i mean
8:44	the user or the web interface
8:46	development the developers are also
8:48	expected to have the back-end knowledge
8:50	where databases are the back-end as
8:52	mentioned industries are expecting full
8:54	stack developers and that's why it has
8:56	become mandatory to learn database
8:58	management system and finally if you
9:00	want to become a database tester or
9:03	software tester or penetration tester
9:05	simply pen testers then databases are
9:08	very much important i hope now you
9:10	understood the significance of having
9:12	dbms in our day-to-day activities so
9:15	with the fingers crossed let's see about
9:17	database management system elaborately
9:19	with the formal definition in the next
9:21	lecture i hope you guys enjoyed this
9:23	presentation and thank you for watching
9:26	[Music]
9:26	[Applause]
9:29	[Music]
9:37	you