Database Technology Video Lecture - SSC CGL Tier 2 - Study Material, Online

hello friends let us begin with the
database technology now database has
really changed the way how a - both you
know database the few language like
Oracle ingress so this have radically
changed our view towards computers
because their base has really played a
very vital role in a - so let us take Oh
what is database technology actually
will be looking so basically what is
database technology database technology
is at the heart of information systems
of an organization it is a central
repository system of organization of
data so for organization of data it is
nothing but a central repository system
repository means actually where you
deposit your data so here here the
organization data is being deposited and
how the database technology works that
will be looking in the upcoming slide so
data is nothing but it is a raw acts of
detail where randomly the data has been
collected by each and every data
department and it has been feeded into
the computer and the database is
actually a logical related data so it
contains of entities like student is an
entity say for example and here courses
is another entity instructor is another
entity so these entities are being
related
with the help of the keys you know say
for example student might be having the
old number his name and his course which
he has taken so roll number is the
primary key over here the name of the
student and the course the course is
linked with him you know my he might
have taken MBA or MIT taken engineering
so this is nothing but the courses has
been named link and structure is the
name of the person who is actually
instructing the students so these
entities are being related and there are
some relationships and that relationship
is done with the help of the ER diagram
so we have entity relationship diagrams
to work without ways and here in
database you know database management
system it is Lac actually a lot softer
package which is designed to store and
manage databases so basically bbm s is
nothing but a large soft blanket which
actually works with the data so data
base as are everywhere your valid is
full of database record for example your
join glycine is somewhere like power of
an audio department your credit card is
somewhere is at all of your bank you
know and gym membership card
membership card okay Jim you know your
individual checks in your bands checks
you might be having between final checks
you have these 500 note it contains a
serial number it is the record of some
Reserve Bank of India or whatever
government you are associated with and
even your photos and ID checks you know
maybe your identity card say for example
if you are an Indian you might be having
another an election card so this is our
nothing but it contains some serial
number and your name and your address
say for example your mobile number it
also puts utilities so it's somewhere
you know lots of people have this kind
of data and it is connected to somewhere
called a database you know the database
is being everywhere so why do we need
database actually it is a very
information explosion in today's society
we need to keep accurate records so
accurate record-keeping is very
important that's why we need databases
and they had one pages of using the
database into three main categories that
we should have to offer maintenance of
data providing access to the data and
maintaining the data so proper
maintenance should be there and there
should be levels of access you know
levels of access should be set properly
and the security is also very important
so that is why this all these three
factors have made
available in DBMS only using DBMS so
traditionally there wasn't a half manner
when people used to keep data and the
requirements were actually application
derived and independently and there are
files actually developed from an
individual applications you can use to
develop the data files individually on
them they don't need they never used to
link that data files and afterwards you
know when they be asked in these files
correlating to one another and here are
some of the application programs which
are actually data department so many of
the programs here on holidays which are
designed by the computers they have gone
back end and there's got a front-end so
for example front-end programming you've
made a bit ESB don't need a programming
language and back-end you know some
database called SQL Server so this
front-end and back-end databases are
linking so nowadays the application
programs are becoming data dependent so
every program there's some database is
have been used so many friends even the
games part if you consider you know
collect or maintaining the maintaining
popular very well they also contain the
data so the points which are actually
dedicated to some application programs
will be looking in the upcoming slide to
come how we should keep data based
approach and one of the data sharing
apps also will be looking in the
upcoming slide and