Introduction to Database Management System Video Lecture - IT & Software

hello dudes welcome to tech ted.com
a free learning and sharing environment
my name is rhythm
and I am going to guide you through this
course which is on database management
system so let's have an overview of this
course let's understand what happened
just now with you ok you came online to
study on tech TOCOM and you made a
request with the URL through the browser
so the URL went home in the request went
to the server and server responded you
with the page right not exactly
this is not what exactly happens what
happens is when you made a request it
goes to the server this is just a server
where the code is hosted it means where
the business logic is hosted all the
foods but this server doesn't have data
or it has it may have data but is not
much data generally this case or
especially for this technical so what
happens is this server again make a
request to another server which is our
database server now this database server
returns the data to the server and again
this business logic server returns you
the page using this data which has been
returned by a database server and
renders it in form of page and it
returns you through the browser so this
is our concentration this database is
our pool concentration in this course so
this is the overview basically we will
be following gate syllabus but this is a
entire overview of this course first we
will be starting with introduction of
database system where we will understand
what is database what is a database
management system few basic definitions
which will be useful throughout the
course next we will be on covering ER
diagram or ER model which is basically
the real world presentation or
representation
on paper so through the entity and the
relationship among among entity we try
to model our data based on paper and
from this model we generally design the
actual database system or our tables and
all next we will be covering a
relational database model in which we
will be covering various relationship
among the tables and inside the table
itself than various level of
normalization etc next we will be
covering database design where we will
try to design a database through from
given scenario after that we will be
covering SQL SQL for is structured query
language it is used to interact with the
database as we said here just I
explained like we have our business
logic server and we have a database
server right so this business logic
server interact with the database server
so this is done through this SQL next is
transaction management our transaction
is a smallest atomic unit of work so we
have to manage this transaction because
various transaction will be going on so
we have to ensure asset property
afterwards we will be understanding the
concurrency control like on a particular
database system at the time for add at a
moment various transactions can go on so
how we will ensure the consistency among
the data or how we will ensure the
correctness next is file structure file
structure is basically what we see
database is as a table but it's not what
actually it is as to stored in the
system so we will be understanding how
we actually store the database on
physical level and AD then we will be
understanding the indexing like like how
we made the excess faster and faster
okay using the indexing system so this
is the entire overview of this course
and throughout this course we will be
covering the entire
various gate questions which has been
asked previously and we will be covering
new questions also so I hope you will be
enjoying this course and you will be
enjoying learning database management
system so see you in the next lecture
thank you