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

Introduction to SQL

This introductory SQL training teaches SQL core concepts that can be applied in professional environments. Once students complete this course, they will be able to query and interact with an SQL database, and know how to design database schemas.

Instructed By

Instructor Profile Image
Kitt Parker
Instructor