Hello and welcome to the simulation and this lesson, you will learn how to prepare yourself a secure
database after signing up for a hosting account and setting up your domain name.
You can log in just like we explained in the previous lesson to your panel or the similar dashboard.
After that, you need to follow my steps to create your database username, password and your Ezekial
table.
Now let's first create a database and a user.
The first step is go to the tools section and select a database manager.
As you can see, this is the database manager, just click a new database, and here you need to enter
your database name and database user name and database password.
The first step that we need to do is choose your database name and our example, it will be E.S.P data
because we are handling E.S.P 32 data.
Then we need to choose our password and our username.
So let's call them now, I usually prefer choosing the database username name wisely and make it relevant.
Now, our database username will be E.S.P board.
And you should enter your password here.
I will enter my password and you should write it down.
OK, but you need to make sure that you are using an uppercase letter and that your password is at least
12 character long and include no special characters.
So you can create that password or choose a random one.
As you can see, it will create one for you and you should take this information and save them.
In art, not politics bad.
So here's not bad, what you need to do is copy the username best it could be the.
So that's the best name, username and password.
That's it now click create after copying this information.
Hey, I don't want to save.
OK, now here's our database and now it's creating the database.
So you should wait a minute or two.
The database limit is one gigabyte and you can create up to 100 table.
We only need one table.
And this is more than enough again for testing.
You can create two databases using the free hosting.
So I think it's a very good way to start testing.
It shouldn't take long.
Now you can use localhost as a condition hostname.
And you can copy this information and placed them in the notepad that you created earlier.
OK, now that we created this is what you need to do is create a skill table, click here and go to
HP, my admin, you can delete the space or change your password or see the statistics from these two
lines.
Just click through my admin.
And you'll be redirected to this window, and this is the PSAP, my advents, a very famous interface
to control your database and create tables, delete tables, create queries and other stuff.
Now, creating the actual data base is the second step.
After creating your database and using what you need to do is go to the left side of this database,
as you can see, and this will be your database name.
Now, usually we did name E.S.P data, but they don't give you, let's say, access to this name.
So they add an idea before.
So this is our database name.
Now you need to click it.
And once you click it, you have access to your database, you need to go and click on the actual tab.
This is Hilltop will help us create our table and make sure we have open the database that you have
created, then click the asphalt up.
If you haven't selected this database and click the actual tab, it will take you to a new or a general
database that you don't have control over.
If you don't follow these exact steps and run the actual query, you might create a table in the wrong
database.
Now, to create the query, query is basically a simple lines of code that you execute using this window.
You will paste them here and once you click go, it will execute this query and this query will create
the columns of our table and will create a new table for us with the name that we do choose.
Now to create that query, you need to do the following.
Look, Muscleman.
The first step is try to create and as you can see, it's recognizing and trustable then sensor data
or any other thing, you can simply write S or E.S.P data, then you need to open and close to parentheses.
Now you need to write your query in between.
Now, this will write the E.S.P data, which is basically creating a new table and naming it E.S.P data.
The next step will be is I create the columns inside this table.
The first step is creating the idea column.
It's a very common one that will be end.
And let's make it six now to be unsigned, so left unsigned and so I auto increment.
We needed to increment.
We don't need to enter it manually and choose primary key.
So it will be the primary key for our table.
This is a secure UL
database query, so if you are not familiar with it, it's OK.
You can just copy and paste the code that I will provide for you in the resources lecture of this section.
So no worries.
If you don't understand what I'm doing at this point now, I will paste the lines and then I will explain
them to you so that we won't waste time creating a circle.
Next, we we need to create, let's say, value one.
And we make it far character.
Let's give it our first.
And make sure that it's recognized as not normal.
OK.
Now, this needs to be 30, not 10 and unsigned here has a red line underneath it because, OK, let's
make this stem because we misspelled it, OK, and sign.
Signed, OK?
Now everything's OK, now let's move on, we need to create other variables as well.
The second one is called value to a third one.
We can call it value three, depending on how many values we need to create.
We can create other values as well as we go with this code.
Now, the next step will be.
Adding a timestamp, so let's add reading time and make a time stamp default and choose current time.
Stand on update on timestamped.
This will make sure that we have a column that will print the time at which these values were received.
Now, the next step is creating other variables, if we if we need, we can create a variable and call
sensor so it will be sensor data.
And it will be very variable character and let's give it a value of 10 or let's make it 30 and make
sure that it's not not.
We can be the same.
And based it here to create another variable and let's call it location data.
OK, location data available shot 30 Natnael.
That's it.
Now let's review what we have done here.
We created a table and named it E.S.P data.
You can change this name.
We created an I.D. which will auto increment.
It's basically the idea of the table.
It will be one, two, three, four, five and will keep increasing.
It's the primary key that we are going to use to access any of these values.
Now we have created a character named Census Data and another character named Location Data.
We created value one to three to pass other values.
If we want, we can leave them to be zeroes or we can pass data.
So these are basically variable creation.
Now here we are creating a timestamp.
Whenever we create or send our new census data, it will print out the time at which this census data
was sent.
That's it for this lesson.
Thanks for watching.
This is Ashira from Educational Engineering Team.
Now, before moving on, we need to click the goal button to create this table, and it will take a
minute, as you can see, my security and an empty ResultSet, which is Xeros.
And as you can see now, this is our database and this is our table.
If you click once on your table, you can see that you have already since data location data value one
value to value three and the reading time.
So that's it.
This is our table and these are all columns.
If you got this smashers and you got this this result, it means that you have done everything correctly.
If you have any problem or if you faced any problem, please do ask in the Q&A board.
I'm here to help you.
This is Ashara from educational engineering team.