And this video, we will be installing the sample database for human resources tables, so in order
to do that first, let's create a fresh new database, right mouse click on database, click on database,
and I'm going to call this Hitcher.
An owner will keep it to Adam and save.
OK, so we have our new database created, so make sure that we select the database, the new database,
and we will click on the new Pope admin query tool and make sure that the haters slash Apple's servers
are coming out.
This shows that this query is enabled to access the database, which are now from here.
Let's import our files.
So from the download folder that we've given to you with with these videos and download the files and
inside the download file, you have a zip file.
Unzip that.
And once you zip that, open the folder where you unzip the files.
And over here you will see The Hitcher as well.
So we're going to select that.
And this is basically creating, uh, databases, tables and everything over here.
We're going to go through with that in more detail.
So right now, we'll just click on Run and the tables are created.
Um, don't worry about these notices, because what it happens over here is it sets table region does
not exist because very first time when you run this script is actually drop table, if there is any,
to a region table, which is the case over here is not.
So that is the reason it's saying table region does not exist because we are installing the fresh copy
of here.
Now, if you were to run this again and let's try that again over here and again and you will see the
notice is gone because there was tables before and now we have a fresh installation.
So let's double check whether our tables are created under the schema tables.
And we have countries, department, employee job history, jobs, location, region tables and their
columns.
Over here in the next video, I'm going to show you more about the database, the schema of human resource
or H.R. database.