Time
7 hours 36 minutes
Difficulty
Beginner
CEU/CPE
3

Video Transcription

00:00
Hi. Welcome to module to Databases. This is Lesson 1.7, the Windows edition. There will be one of these for the boot to Lennox operating system as well,
00:09
because the installation of this database has a couple of things that makes it a little more complicated
00:15
so it wouldn't show to pass of installations on two different operating systems. But with that said, Let's get it started
00:24
soaping up your browser of choice. And, as usual, you will need a computer with administrative shooting, administrative access and also Internet access. So go to your browser of choice.
00:38
I search my sequel sample database employees,
00:45
and one of your top results should be the Deb that my civil dot com domain.
00:53
And if you landed at a different section,
00:56
we'll be sure to go to the installation section.
00:59
And it says you can get this
01:00
at the employees D B on get help. So let's do that.
01:04
Let's click on that
01:07
and let's click the cloner download. We're just gonna download the ZIP file
01:10
and we're gonna save the file.
01:12
It shouldn't take too long.
01:15
Looks like it's done.
01:19
Go to your downloads folder,
01:21
click on it right click
01:23
and then click the extract. All
01:29
okay,
01:30
going and click into the folder that opens.
01:34
And on every one of these sequel files and dump files, you need thio, right? Click them and click properties and click Unlock
01:42
windows by default on a lot of installations will attempt to protect you from certain files and will automatically block them.
01:52
And now,
01:53
of course, we need to use these files so we will have to unblock them.
02:00
And that's something to keep in mind when you're working with various types of program files as well. You could be doing everything right.
02:06
And you just forgot to come into the properties and unlock the file.
02:10
I'm gonna go ahead and fast forward this to the end so you don't have to watch you unblock all these.
02:15
Okay, I finished. I'm blocking all those Don't for
02:19
Don't forget this file down here. You might have stopped at the read me, but you also need to unlock this fall. You will didn't want to select all these falls with a shift and click to select all and then hold control
02:32
and click
02:34
on show a lap start sequel file so that you get all these selected and then hit control C to copy them or you can right click and click copy,
02:44
and you'll need to click on this PC. Go to your C drive or wherever your OS is installed,
02:50
go to your program files. You're my sequel folder. This is the place where my singles installed. Don't change the name.
02:58
Go into the server folder,
03:00
Go into the Ben Folder and paste all those files.
03:04
Do this for all current items. Click Continue,
03:08
and the reason you have the pastries falls in here is because when you run the install Script
03:14
de Beaver
03:15
or my sequel, to be more precise, is going to look in this folder for the past automatically.
03:22
And if they're not in this folder, it will fail. Now it's possible that have you installed the 32 bit version of my sequel that instead of program files, you'll have program files X 86. So if you cannot find my sequel server, Ben and the program files, be sure to check The program falls X 86 as well,
03:42
which is right there.
03:44
So let's go ahead and open up. D beaver. We've prepped the files.
03:51
This shouldn't take too long
03:54
on, then you will close the tip of the day. Open up your connection. Open up your data basis and right click any database and click tools.
04:05
Execute script.
04:09
Quick the fuller button
04:12
and you go ahead and go to your
04:15
your downloads folder
04:17
and to that
04:19
folder we un compressed into that folder and double click the employees that sequel
04:26
script
04:28
and go ahead and click Start.
04:31
Now. This could take anywhere from a few seconds to a minute to run. This does take a little bit of time. It's actually
04:39
it's actually putting an ale substantial amount of test data, which is just fine.
04:44
And I'm gonna go ahead and positive video and fast forward to the end so that we don't have to wait here.
04:48
Okay, we've finished the insulation. You can see that it took my system one minute, 46 seconds. Install that so it can take a little bit of time going to click. OK, and go ahead and close this box. Now. If you left click on your databases folder, right click and then click Refresh
05:06
should see. A new database is going to open that up.
05:10
It's going to Open up the tables. Folder
05:12
on. Let's double click on the employees.
05:15
Make sure the data got in to the data days, so click on the data tab.
05:21
All right. It looks like we have a substantial amount of data.
05:27
Yeah, 600 rose, 800 rose. They gave us a lot of tests out of the work with. That's nice.
05:34
So in the next video,
05:36
what we're going to do is we're going to take a look,
05:40
ATC Wearing out this relationship and seeing how
05:44
writing a sequel query for this will. Look,
05:46
I hope you enjoy this lesson. Hope you gotta work in and I'll see you in the next lesson.

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