To follow along with the exercises in this course, you will need to install some software on your computer. Here are instructions that cover installation on a PC running Windows.
- [Instructor] In this movie I'll show you how to install a test environment to follow along with the exercises on a PC running Windows. This is part one of two movies. In order to follow along with the exercises, there's a few things you will need. You'll need a web browser and any modern web browser will do. I'm using Google Chrome, but that's just my preference. If you prefer Firefox, Safari or Microsoft Edge, that'll work fine. You just need a modern, up-to-date browser. You'll need a web server with PHP and a database engine.
I'll show you how to install XAMPP, which includes the Apache web server, in the next movie. You'll also need a plain text editor. And this is different than a word processor. A word processor is designed for writing documents and includes a lot of formatting information along with the text, and that formatting information will actually interfere with the SQL code in the example files. So a word processor will not work for this purpose. Unfortunately, the Notepad program that ships with Windows also doesn't work well for this purpose.
So, for Windows users, I suggest Notepad++. It's an excellent text editor and it's free. Finally, you'll need the SID and CRUD applications that I wrote for demonstrating SQL. These are included in the exercise files and I'll show you how to install them in part two. These installation steps can be a bit technical so, take it slow and pay close attention to the details. We have a lot to do here, so let's get started. Notepad++ is easy to install. You can download it here from their web page here at notepad-plus-plus.org/download.
You'll notice on this page that it's very busy and it has a lot of, what I call, landmine ads. These are advertisements. They're trying to get you to click on them by fooling you into thinking that they're for the download. So, either of these links or this start button, those are not for the download. Those are gonna take you to ads. Down here you'll notice this link. It says Notepad++ Installer 32bit x86. That's the one you want. So you'll click on that and you'll download it. I've already downloaded it to my desktop here. So I'm just gonna double-click on the link and we'll start the installer.
At the user account control I'll say yes. Select English for the language. This is just for the installer and there's a lot of choices, but I'm selecting English. I like English. And I'll select Next here and agree to the license agreement which I have never read, and, I'm gonna accept the default destination folder which is where you wanna put it, Program Files x86 and I'm gonna accept all of these defaults and I'm just gonna click on Create Desktop Shortcut here because I'll use that.
The installation goes pretty quickly. I'm gonna leave Run Notepad checked because, if I don't run it now, it doesn't load up this little document of the change notices and I want that, not because I'm gonna read it, but because I'm gonna use it as I set up the editor. So I'm just gonna say Finish here. And you see here's our change log. I'm just gonna go ahead and I'm gonna close this because I wanna run it as an administrator. But even when I run it as an administrator now, I right-click and click Run as administrator and accept the user account control, it'll still bring up this document.
And that's handy for what we're going to do in setting up the editor. So I'm running it as an administrator just this once because some of these settings work better as an administrator. And that's for setting the file association. So we'll go ahead and do that first. Settings, Preferences, come over here to File Associations. And what this does, you'll notice these Supported extensions. There's all these file extensions which you see listed here on the right. I'm gonna use customized, but it associates a file extension with the editor so that when I double-click on a file of, say, dot text, I'll enter dot text here.
And when I double-click on a file with dot text, it will run it in Notepad++ instead of running the default Notepad, which we don't want. I'm gonna just do a few more here. Dot PHP and dot SQL, and for each of these, I type it in and I press the right arrow and dot HTML, dot HTM, which is Microsoft's special three-letter version of dot HTML, and dot CSS. So these are the things that I want associated with these editors.
For our purposes, you really need dot TXT, dot PHP and dot SQL. The other ones are for convenience and may or may not really be necessary for you. So I'm gonna go ahead and close this. And I'm gonna change a couple of other settings here which you don't need to change. I'm gonna go into the style configurator and there's a lotta different styles here you can select from. For my purposes, because the screen is small and I'm demonstrating and I want you to be able to read what's on the screen, I'm gonna change the default text size and font. I do that by enabling a global font and a global size and I check Consolas here for the font and the font size of 16, and you can see that that's now nice and big and legible, just for the purpose of demonstrating on this small screen.
You do not need to do this. So I Save & Close, and, again, for my purposes, I like spaces instead of tabs, so I'm gonna check that. This is under Language and Tab Settings, Replace by space. I like that. Now we can close this and I'm gonna bring up our exercise files and some text files here. You'll notice that these text files are not showing the Notepad++ icon. I just went in and I changed that association and if I double-click on one of these, it's gonna bring up the Microsoft Notepad, which is wrong and you see everything's formatted wrong and we don't want that.
Then why did I change it in the application? And why did I go and run it as administrator do that? Well here's why. When I right-click on this file here, this text file, and I bring up properties, and you wanna follow along with me to do this 'cause this is the final step of setting the association. The first step was setting it in Notepad. Now we have to set it in Windows. You see it says Opens with: Notepad, and I'm gonna click Change and now, down in this list, you'll notice I have Notepad++. If I had not changed that in Notepad++, changed it in the settings, and if I had not done that as an administrator, this would not show up.
So if this doesn't show up here, it means you didn't do that, or you didn't do it as an administrator and you wanna to back and set that setting in Notepad++. So I'm gonna click on this and I'm gonna say OK, and I'm gonna say OK here and now, you'll notice all the text files, any one of them that I bring up, I'm gonna double-click on that one there, now it brings it up in Notepad++, which is exactly where we want it. We don't need this change log anymore. I'll close that one. Notepad++ is sticky. When you close it and you reopen it, it reopens all of your files.
There may be a setting for changing that. I've never looked for it. I like that behavior. So now Notepad++, if you're seeing this sort of result, and if it's working as expected, you've now successfully installed Notepad++ on your computer. And, in the next movie, I'll show you how to install XAMPP and the SQL demonstration applications. So I'll close this. And I'll close this. And I'll bring up our browser again and we're ready for the next movie.
- Understanding SQL terminology and syntax
- Creating new tables
- Inserting and updating data
- Writing basic SQL queries
- Sorting and filtering
- Accessing related tables with JOIN
- Working with strings
- Understanding numeric types
- Using aggregate functions and transactions
- Automating data with triggers
- Creating views
- Defining functions in PHP