Here everyone in the studio I will tell you that what actually database is so the database is very simple
concept.
Once you get it you will never forget about it.
And it's very easy to use install and you can get it everywhere.
So first of all let me begin with the computer.
This is the main P.C. here.
But this screen is something that doesn't store the data whenever you are doing something writing something
or during any music file video and anything else.
Like when we have downloaded the data then the data is not stored on the screen or these on these icons
that it is actually storing the hard drive.
So basically the harddrive acts as a database for this computer.
Now after that when just suppose I'm playing some music on a speaker and I am using a memory chip or
any say band right then I'm inserting that particular pendulum that my music system and that music system
is taking songs from that one and making us to listen them.
So there at that point the band I will say memory card is acting the database.
So in simple words the database is just that player because a source or space where our data is stored
or the point from where the computer takes the data and interacts with us.
So that in there in very short is actually database.
The most common use for that one is the Internet like well whenever you are browsing something on the
internet you are getting data and that data is most of you not most of everyone you would get angry
with that when that data is not in a computer.
We are getting that from internet.
Now the question is what actual internet is from where you are getting that.
So actually that data is that we are getting on a browser whatever we are using is coming through some
databases and their databases manage a database company where any source say Oracle which is the biggest
part of his company.
And there you can store your data from which every user can access data.
You can take any example of any websites even Google who will have their own database entries also destroyed
their data on that one and you have a year.
The concept of hosting hosting is something from their big databases databases.
The centers are very big same number of buildings a larger number of hard drives are stored alternate
to each other.
So they what they do.
This has some space all that particular data to the users who are using internet or those who have websites
say any music company assists Simpson Apple or any company whatever you will look for on the Internet.
They have buy some space on the database and they're storing their data files there so that other users
can access statement also here if you notice on this deck stop this desktop interface but it actually
consists of code and that code is stored in my computer so that I can access this one.
Similarly websites are made from coding that is known as Web development.
So they also include that file.
Now the Web sites files are also stored in the databases so someone can access that websites.
Now if we talk about the computer that is about the Internet then most of you are thinking that when
we are actually storing the data on your computer then by we need to install the databases like when
you have booked on the programs you have used when he was at that point your data is stored in variables
and the variables are actually storing the data in the hard drive one meeting when you press controls
that you will get you mean code return whatever you have deleted.
The reason for that one is also the code is consequently stored in the hard drives from where you can
access that the.
Now when we talk about why we need the databases on the computer then again the same reason instead
of searching the complete Internet domain or computer whatever we are looking one will direct us to
that particular database on the Internet.
From there we will test the data of that particular Web site and work with that one.
Similarly instead of searching complete hard right we will make a separate point on that particular
hard drive where we just set salable data off of a program.
So you have made a simple application in which the only entry and a button at whenever you enter something
Sandy name it will get added to your database.
So if you will not use any data the data will be entered randomly in your computer.
But if you have a database then that particular data is entered at particular space.
That is actually your database with which you then [REMOVED].
So this is the concept of database.
Now we will come to how to use these.
So we cannot just directly make our database here.
However the Python programming and other parameters also provide us the by default creating databases.
That is with the Esko like reliability.
So we have a library by which we can create the databases.
But it's a little hard to interact with that one.
So we have different databases software with which we can create databases access that one at easily
use these.
They include a number of softwares but before them.
This is how actually they look like.
Let me show you the list.
So you have a large number of list of databases so these are actually software that will create our
database and they will interact with Declan.
So here we have my sequel Oracle post jihadi rescue plan no offline.
First I want to make you learn about my sequel because this one is the most popular one and open source
but installing this one is a little harder and making it one ready again and again.
So what we are going to learn here.
We are going to learn this one poses serious good because this one is very easy to install restive working
of every database is same.
Just like if you use Python programming any editor the programming remains in just interfaces difference.
So similarly we have all the databases with the same commands.
This is the interface or installing process it is a little different.
So I am using the one which is easy to install so that you will not get any difficulty in that one after
that one.
These are actually what our database looked like.
Simple example this one they use to retain form of tables like this so you create tables like this.
We have names there we have the continent.
Capital and these rules can be added by programming or by your program.
Like if I have a program here my entry whenever I add something that will be added to database or this
table and that is stored safely at that particular point.
Now whenever I need that data my program will just go to that position and get me that data.
So this one makes things very easy.
Instead of making some complex in the situation like store everything at different position and then
it's very hard to access them after that one as I have told you we have local databases also.
That is a skill like reliability with this one we can create a local database and we will learn about
these that how we can create them and use them in the next video.
Then the concept will be more clear to you.
So thanks for watching.
See in the next video.