Time
7 hours 36 minutes
Difficulty
Beginner
CEU/CPE
3

Video Transcription

00:00
Welcome back to module to databases. This is less than 1.7 the Abou to Lennox installation instructional video for the Employees database. Now this is going to be a pretty short video. It's
00:11
easy to get this installed on a Bluetooth, so let's get started. So if we open up the activities for a search, let's go ahead and open up the D Beaver application we installed in a previous lesson.
00:25
Okay,
00:28
let that get opened up,
00:29
and you should be connected to the connection that we established in a previous lesson. So we'll be able to see the results of the insulation of the database. Next, open up a browser and again you will need root privileges. And you will also need
00:46
Internet access to complete this.
00:49
So we're going thio, Google Search for my sequel
00:53
sample
00:55
database employees
01:00
and you should get a top here at the dev dot my sequel dot com domain. We're gonna go ahead and open that up.
01:07
We're gonna go to the installation section
01:11
and we're going to click the link for the employees D B on get hub.
01:17
And once we are at this page, we're going to click the cloner download button
01:22
and we're gonna click Download zip
01:26
and we're gonna click okay for save file.
01:32
And that shouldn't take too long to download.
01:36
Once it's downloaded, we're gonna open up our file Explorer
01:40
clicking on the files icon on the left side.
01:45
And then we're going to go to the download section
01:48
where we should see are downloaded file.
01:51
We're going to right click
01:53
and then select extract. Here.
01:56
We're gonna open up the resulting directory
02:00
and on some available y space, click open, right click
02:07
and then click open and terminal.
02:08
That's gonna open a terminal at the path
02:12
where you selected.
02:14
And then we're gonna need to switch to the route user so of pseudo dash s
02:22
and then type in your password.
02:25
And next, you're just going to enter
02:30
my sequel space less than symbol Space Employees. That sequel
02:37
and hit Enter.
02:39
You should see some details off the script running
02:46
and again, it takes a little bit of time to actually load the scripts because they did put a substantial mental test at
02:52
in the files, which is a good thing.
02:58
And we will wait for that to run.
03:00
If you try to do this
03:02
and you were not the route user. You may get some permission errors.
03:08
So that's why the required Thio.
03:12
That's why you are required to switch to the re user to run this script.
03:15
And once this is done loading, we should be able to check D Beaver and see the results.
03:29
Okay, 49 seconds.
03:30
Too bad. So go back to your D beaver. Gooey
03:36
right click on your data basis and select refresh.
03:40
And we have the employees data beta database going to open that.
03:46
Go ahead and expand tables and let's just select employees.
03:51
Give that a double click
03:53
and then click on the data tab
03:57
and we can see that the data has been loaded. So we have successfully
04:00
established employees database and loaded it with
04:04
data.
04:06
So this that completes this lesson. I hope you enjoyed it. I hope you got it working. And I'll see you in the next lesson. 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