Cybrary Pro Day is here!

3.1 Database Installation

Video Activity
Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Time
7 hours 36 minutes
Difficulty
Beginner
CEU/CPE
3
Video Transcription
00:00
I welcome back to Module three sequel programming. This is less than one sequel statements. They get started off on the right foot, We're gonna import a large air P database. This comes from the schematic of framework. It's there.
00:13
Database frameworks, schema loaded with their tests, data. So this will give us
00:19
some good practice on writing queries against a
00:25
A database that's more reflective of what you'll find commercial software built from.
00:30
So with that said, let's get started. Let's get this installed. These files will be available for download,
00:36
so you're gonna want to get
00:38
de beaver open,
00:39
and you're gonna want to create a new database and you're gonna you're gonna name it whatever you want. But I'm gonna go ahead and call it a thematic of.
00:49
You need to use a specific charge set for this database. You need the UTF eight em before char set.
00:56
Then you can click. Okay,
00:59
so once you've downloaded it
01:00
and you're ready and you have the file ready, you're gonna right click on the database. You just created
01:06
click
01:07
tools, restore database,
01:11
and then you're going to need to find the file that you downloaded which looked should look like something like this. You're gonna open it,
01:18
and you're just gonna go ahead and click. Start
01:21
now, this will take some time to finish, so I'll go ahead and fast forward the video
01:26
to where it's finished to. Ah, close out this tutorial.
01:36
All right, I just finished. The database import that took about six minutes to complete
01:42
is a large skim A. So that's kind of expected with the larger data basis.
01:49
And let's take a look to make sure that we got that import. So let's see. There's the database. There's the tables.
02:00
Oh, I already got a filter on.
02:02
Let's do that again, is you will see this is a very large database with lots of tables.
02:12
So let's make sure some test that I got in there. So I know a couple of table names so I'll just go ahead and search for those
02:19
e P employees is one. Give that a double click.
02:23
We'll click on the
02:25
data. Yep, looks like it's been loaded with a bunch of test data.
02:29
Very good.
02:30
And let's take a look at our diagram. Yep, they have some constraints in there that are highlighting the relationships between the tables.
02:37
All right, so in the ah, the next tutorial video, we will actually start writing some queries against this database to, ah, tranquil out some interesting data. So I hope you enjoy this video. I hope that you were able to get your database imported, and I will see you in the next tutorial. Thank you.
Up Next