Here we.
I hope you get installed successfully deployed serious skill.
And if you're getting some problems then you can ask me.
I was so late.
So now we finally begin working the databases.
Now we have to learn what the database actually eats and how we can install the one that is both cheery
as well.
Now we are going to learn that how we can cope with that from now things will be very easy for you.
So first of all make a file for the databases in the US.
So the item you file save this phone is say D.B. denoting database not be why i i'm taking short names
so that I do not have to write much in terminal and this on his own next to and not no when one thing
I'm doing.
I'm going to do here is I have this file at this point and I'm going to make a copy of this one at this
database base too and rename the son D.B. to the spacing between them.
Now also on this file here we have this I just have got this one here.
Now why.
To file one for the default database one for the both jihadi so that you can see that how they're different
because they are no different at all.
Now let me begin first of all working with any database is very simple.
Hey I will tell you only three things that will make you to go to these one possible use or any database
very easily.
And those three things are plus one five step three second one is like what that is
focusing on Goma and caution.
So you need to only focus on these two things.
Are very different from the other languages I believe because in that one you did not require what.
And last thing functions usage.
So if you will just focus on these two things.
There is nothing more except this thing in the complete database I believe that the only thing first
that we consider these fights step.
So the database works on four.
Now what the area they stands for First one
connection.
Second one Gaza
third one.
Connect enough then fourth one is close and between them we have execute
so these are the seeds we e middle which make all the work done with these databases.
Now what they actually are is like here we have the database.
This one is a hard drive separately and I'm working on my main hunch right.
So first I need a connection between my program and this hard drive.
After that one let me take a simple example you have a drawer in your house in which you need to add
some stuff.
So first of all you need to go to that one.
Second thing you need to open.
So that what you will do with your hands so your hands are acting as it goes out there that are doing
this.
And connection is you are getting to Denver after that execute is like you are putting your stuff there
and taking other stuff from Denver.
So that is the execute or maybe you are adding some more.
You are changing something and you are maybe taking money from distraught to draw like that.
After that one this one is not connect this is commit maybe by hitting and date it.
Same as they connect.
So they commit after that one is made.
Like now you have done all this stuff.
You are going to leave.
There is nothing as left.
After that we have to close that is closing the door.
Otherwise someone else will steal that.
And you can also see these two steps like commit is closing and closes locking the now they will move
to this but before that function focusing on this one the functions.
So these are the two things that we are going to focus on the program the comas and caution Mark caution
mark may only be required for local or we can see default database.
We did not require this one while we are working with people cheering.
So this is not a typical issue of daily functions use it.
This thing is very important.
Like if you are creating the Escalade then I have told you the five steps.
So whatever you need to do like the draw is the best example if you need to add something update something
take something you always need to perform that five steps.
There is no shortcut for document.
So you not write all the five lines again and again in your program whenever you need to update something
like If you are adding 100 names then you gonna write again and again that lengths.
So it is very good to make some simple thing functions so that you can define them once and call whenever
you are required.
So with the databases we are going to do everything in functions.
So let's begin with that one.
First of all if I'm working on the default database I need to import a library that is known as a school
right or because it is too light three make sure that no double L in between them so here we have a
school like.
After that when I'm making a simple connection here for that one defining a function say connect.
We have this one or this one you can simply do without any connections also.
Let me just define this one without any connection.
So connect is very simple.
You just need to add Sue and then denoting connection then ask you a light tree don't because we are
using this library as the main default database and then just add connect and they're in quotes bus
light database that is light dot baby.
So this is all about the connection at this point.
Your file are connected.
Now what about creating some table with everything you are going to store in the database is stored
in form of tables as I have shown you on the Safari.
So no of book with functions begin.
I'm defining a function here that is create say DBA princes and then courts in that van wherever you
are drawing something.
You always need a connection again like the draw.
You first need to go to that one after that when you need to create some hands.
That is a Gaza.
So this goes of it act.
So we have CNN connection and then Gaza.
So this is very important step.
You always need after that when we have execution step.
I'm leaving a enter here because this is the only line that will differ in know every like when we add
delete view like these operations press the forces will all be same only the E is different.
So when you are done everything just become it about that one solves connection not commit and Pence's
there is no parameter in this and in last when you do just close that one.
Otherwise your data will not be saved.
So these are the four lines that will always remain seen.
Now about creating the data.
So whenever you are working the data is this thing you will understanding the next video event.
I will show you with the posterior clear there I can show you all the things but not in this video.
We have only a few commands select to select any data or we have then create
insert this time.
So stuff I was there to talk about this in the next video.
Let me focus on this one.
So execution is done with these hands like you can not just put the stuff without your hands.
So you only also need to include DeCosta so because they're not executed there we have this one Pence's
and then in that one make sure always passing the quotes because query language is the language which
is always bus in between courts whether you are working on the Internet or you are working on local
host this will always be in courts.
And one more thing here we can use for separation of things is this symbol this this is actually the
one before one and about the step number one and about f or D below the debt escape button.
Now you can just copy this whole to use this one again and again because this will all that you've been
seeing now to create a table we use here just create the language is very simple just add here create
if you want to create insert if you want to insert.
Simple as that.
So one more thing.
Well it is good.
If you prefer capital letters because they will separate the votes from the one that we are adding locally
because there is no comma no slash no equal to used in between these.
Just a simple syntax line.
That's why I have to loop coma and question mark.
All this focus on that.
So create and then what we need to create here a table so paper.
Now if you notice here we have no separation and no codes and no Epsilon.
You can also separate this one by adding this like this.
It will still work but more I'm taking a simple example.
Create table space there provide the name of people you want to create say I want to create data there
we have this one here the table is created.
Now if you want to add columns in that table simply a table consists of columns and tools.
So for that one now you need to pass Prentiss with the name that you have created there.
And then there at that point add what you want to see in my first column is name.
So you simply just need to provide a name for us.
And just providing things that I'm adding here comma after that I need say.
Lemme say I'm adding muscle to students and then I have months.
So here these two things I need to add in my data or say rule number is before the name that is.
Why would you have this one lady this is about adding the columns.
Now one more thing you need to specify with that one like whatever you are adding provided data.
And that is simple like rule number just a space.
And what did what number will be.
This one will be an integer.
There we go with that one name.
This one is going to be a XT.
So not string we have XT again I will show you this thing in the next video.
Then we have marks this one maybe like floating point values in integer values.
For that we use real.
Now we are done with this one.
So this is all about creating a table and all about everything in the database.
Just this line will defer with the things press will always remain the same maybe in few.
We have a different or because of one more addition line here.
Next we will talk about the press.
These things will always be seen.
So you will not find difficulty with using databases.
So just controls this one.
And I have just created a function here.
I also need to call this one and just remove the death for now or just this one simple lines or you
can just call here.
Create table and benches see if this one day long the terminal is not fixed.
So I'm using the terminal separately see next door.
And then here byte and three DB Don't be why it written they will get this one successful no letter
and the output is not here but here this one you have noticed this one is created at this point.
Let me show you that one again with a different name see data to see if this one then it again You do
not get this one right now.
So that one is updated in that one right now.
And if I delete this one and again on that one we go to that one again here light dot tv and if you
change the name this will just only updated not a separate copy.
So we have that now.
So here we have created the data table.
And if you tried to open this one you will not find any application in your computer but you can still
open this one just right click open with an indexed for it.
So this one is something you will get.
You will not able to understand this when you have some data here.
But that is it readable like this one table data.
Create table data.
Then my skill that I have passed there.
And then I have passed data to for this same display.
All the commands would be here.
Also whatever the data you will add will be seen here but not in a systematic and efficient way.
So this is the reason we why these other databases because you do not have a much efficient way here
so this is all about creating a table in default database.
We learn the same.
The deposed jihadis will in the next video.
I hope you understand this.
So we'll see you there.