7 hours 36 minutes
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,
because the installation of this database has a couple of things that makes it a little more complicated
so it wouldn't show to pass of installations on two different operating systems. But with that said, Let's get it started
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.
I search my sequel sample database employees,
and one of your top results should be the Deb that my civil dot com domain.
And if you landed at a different section,
we'll be sure to go to the installation section.
And it says you can get this
at the employees D B on get help. So let's do that.
Let's click on that
and let's click the cloner download. We're just gonna download the ZIP file
and we're gonna save the file.
It shouldn't take too long.
Looks like it's done.
Go to your downloads folder,
click on it right click
and then click the extract. All
going and click into the folder that opens.
And on every one of these sequel files and dump files, you need thio, right? Click them and click properties and click Unlock
windows by default on a lot of installations will attempt to protect you from certain files and will automatically block them.
of course, we need to use these files so we will have to unblock them.
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.
And you just forgot to come into the properties and unlock the file.
I'm gonna go ahead and fast forward this to the end so you don't have to watch you unblock all these.
Okay, I finished. I'm blocking all those Don't for
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
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,
and you'll need to click on this PC. Go to your C drive or wherever your OS is installed,
go to your program files. You're my sequel folder. This is the place where my singles installed. Don't change the name.
Go into the server folder,
Go into the Ben Folder and paste all those files.
Do this for all current items. Click Continue,
and the reason you have the pastries falls in here is because when you run the install Script
or my sequel, to be more precise, is going to look in this folder for the past automatically.
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,
which is right there.
So let's go ahead and open up. D beaver. We've prepped the files.
This shouldn't take too long
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.
Quick the fuller button
and you go ahead and go to your
your downloads folder
and to that
folder we un compressed into that folder and double click the employees that sequel
and go ahead and click Start.
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
it's actually putting an ale substantial amount of test data, which is just fine.
And I'm gonna go ahead and positive video and fast forward to the end so that we don't have to wait here.
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
should see. A new database is going to open that up.
It's going to Open up the tables. Folder
on. Let's double click on the employees.
Make sure the data got in to the data days, so click on the data tab.
All right. It looks like we have a substantial amount of data.
Yeah, 600 rose, 800 rose. They gave us a lot of tests out of the work with. That's nice.
So in the next video,
what we're going to do is we're going to take a look,
ATC Wearing out this relationship and seeing how
writing a sequel query for this will. Look,
I hope you enjoy this lesson. Hope you gotta work in and I'll see you in the next lesson.