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.
Database frameworks, schema loaded with their tests, data. So this will give us
some good practice on writing queries against a
A database that's more reflective of what you'll find commercial software built from.
So with that said, let's get started. Let's get this installed. These files will be available for download,
so you're gonna want to get
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.
You need to use a specific charge set for this database. You need the UTF eight em before char set.
Then you can click. Okay,
so once you've downloaded it
and you're ready and you have the file ready, you're gonna right click on the database. You just created
tools, restore database,
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,
and you're just gonna go ahead and click. Start
now, this will take some time to finish, so I'll go ahead and fast forward the video
to where it's finished to. Ah, close out this tutorial.
All right, I just finished. The database import that took about six minutes to complete
is a large skim A. So that's kind of expected with the larger data basis.
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.
Oh, I already got a filter on.
Let's do that again, is you will see this is a very large database with lots of tables.
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
e P employees is one. Give that a double click.
data. Yep, looks like it's been loaded with a bunch of test data.
And let's take a look at our diagram. Yep, they have some constraints in there that are highlighting the relationships between the tables.
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.