Hey guys, in this lesson, we'll be walking through all the steps required to download and install my SQL Server and workbench. So we start off this journey by going to WWE, my SQL Comm. And then you can do the reading, we see that they have an Enterprise Edition and some code services. That's all good. But then we have to pay for most of what is advertised here. So we want to go to downloads.

And then we want to look for the Community Edition, which is free for developers. So we click that and then we continue with my SQL community server. And then we can do a bit bit read bits off reading on the Community Edition, which is freely downloadable. And it is kept active by an open source developer and enthusiasts community. So we see that one it's open source, you can get it, you can modify it if you're already a developer. If not, well, that's fine, but it's always free for the developers and enthusiastic Like ourselves, we can scroll down and then we just go to the MSI installer, which is the bootstrap installer.

And we will sort of go on download page. And then we can select the web installer. So we see we have two options 120 megabytes on one 373. So we can just go ahead with the web installer since it's smaller and easier to download. And then the next page would be asking you if you want to create an account or sign into your accounts, we can skip that that's optional, we can just go straight to our download. Once the download is completed, we can launch a file launch or installer.

And then it will ask you probably will ask you if you want to upgrade you can just see yes, and continue. The next screen you'll see is our license agreement. I always advise you to read it through and once you've already done you accept then you can just go ahead and say accept license and terms. Next, you can leave this on developer default. And if you think you want more power than just the defaults, you can always go to full. But I will leave this on developer default as this will have the server which is the whole database engine that will be driving my SQL functionality.

And it also includes my SQL workbench. And then in addition to that, it also has a bunch of plugins that may or may not be necessary for your context. So for the purposes of this course, we can just click Next. Now nodes if you may have had it installed or tried installed before, you may get this path conflicts. I had it installed before. So I'm getting a path conflict here but you may not get it so if you don't get it then that's fine, but I'll just show you just in case and just click Next.

And just accept that warning and go ahead. And then in this screen, you will be prompted to install certain plugins. So some of them are my own. I have Visual Studio Excellent Python connectors, you can click, and any claim can click check. But for the purpose of this course, we don't need any of these in installations right now, so I can just go ahead and click Next, then skip over this. And then it will warn me that the requirements may not have been fulfilled as continue.

And then here we see the most important things which are our server workbench and other imports on plugins needed for our engine to run. So I can just go ahead and click Execute, which will trigger the download no use, you may encounter these exclamation signs and you don't panic, you can just go ahead and click try again. Sometimes it feels well then sometimes the dependencies don't load faster and the other second is go ahead and keep on clicking try again. For as many times almost every time I install this, I get a different experience. So you're experiencing may be a bit different from mine. But just go ahead and keep on clicking try again until everything has been downloaded and installed successfully.

In some instances, you may encounter problems where no matter how much you press dragon, it just won't proceed. And I'm actually experiencing that. So if you're having this experience also, then I'm going to try an alternative method. If you're not, then you can go to the next step and just wait until I catch up. But then if you are one method that I've seen work is downloading the offline installer. So remember, we don't know that the web installer for 20 megabytes, so we can try the community installer, which is a much bigger file, which actually has everything pre downloaded.

And the don't, there's nothing to download and fail to download. So I already downloaded this and I'm going to run that installer. And try to catch up to where we are. So I'm just going to cancel this quickly and open this file. So if you had already started the process, then you would see them maybe one or two of your things would have been dealing with it already. Either way, if you get this screen then you can go ahead and click Add so that we can finish adding the software.

So we want definitely the my SQL Server. So we'll just drill right don't unselect that, click that green arrow we definitely want or my SQL workbench so we are alone and click that and then we can get our rotator. Alright, and then you can look through you can actually go ahead and install them all if you want. So I actually just go through and bring over all of them because I don't want to leave any stone unturned. So just go ahead and do that. Bring over the connectors for c++ and net and these are really just connection libraries, I leave the Python one out of it.

And I can bring over my SQL documentation if I wish. So I have a native reference on the computer and bring over samples and examples, which will bring forth some sample databases when we finish our installation. And after doing all of that, you can just double check and make sure that your list at the very least has the SQL Server, the workbench and the ODBC connectors. And then we can just go ahead and click Next. And we pretty much just go through all of the steps that we just went through. And this time they're ready to install because there is nothing to download.

So just click Execute, and then it will trigger that installation process. Alright, so whether you use the offline installer or the web installer The end of the process, you should be seeing all green ticks alongside each of the options that you selected. And then once you have that, and you're sure that everything has been installed, you can go ahead and click Next. And then they will start asking us to configure what we have. So the first thing to be configured is our server. Now, we can just leave this on the standalone my SQL Server cluster is essentially when you have more than one databases that need to be aware of each other.

In this course, we won't be doing anything that complex so we can just leave it that standalone server and click Next. And then we can change our settings the dedicated computer server computer development computer in this situation development computer is best because I'm sure this is your personal machine with other non database related applications. So we don't have to make it a dedicated my excuse database server so we can leave it on developer development computer. And also, we don't have to change that port. This is the default port for my SQL. So in an enterprise setting, there are times when people change the port numbers for security reasons.

But for our own machine, we don't have to make that change. And so we can leave everything as is on this screen, click Next. And then for the authentication method, I recommend using the legacy authentication method, because then you retain some backwards compatibility, in case you're going to be creating certain applications or installing applications on top of this. Not every application can use this authentication method that is with the new version. So I recommend using the legacy one, so that you have that backwards compatibility. And then we can go ahead and click Next.

And then I already had an instance installed, but at this point, they would ask you for a user password for your root user, I'm going to use root. So the username is root and the password is root. And I suggest to use something that you can remember. And here I'm checking the password. And clearly, this is not the correct password. Okay, false alarm.

So we see here that Tiki came up when I did a check. So once again, your screen may look differently, you may be asked to enter the root password and confirm it. And below that you will be prompted to possibly add other users but for now, we can just continue with roots. And I say again that I use a very easy password. It's my personal machine so I don't have to be very secure. Of course, if you're doing this for an enterprise setting, then you want to be very secure and in keeping with the password policy of your organization.

But then we can go ahead and continue once we have entered that password. And then it will see here that he's just confirming that it will configure a service and set it to start up automatically. So this service will essentially allow us to connect to the instance, if you untick this, then you would have to manually start the service every time. So I just recommend you leave this ticked. And you don't have to change anything here and you just click Next. And then our final step for configuring our server is to execute, so that it can just carry out these final things.

At the end of this execution, then we should see all green ticks, and then we can click Finish. And then we can just go ahead and configure the rotor. We don't have to change anything here because we're not using the road to the rotor would be for our cluster. So read actually, that was optional. And then we can just click Next to go ahead and install our samples and examples. And once again, we will be prompted to use that user route and that credential that password that we provided, we can click check, just to make sure that you connects successfully once again, use a password that you can remember if you didn't and this was not successful, then you can drop me a line whether by message or q&a, and I will help you troubleshoot that.

And then we go ahead and click Next and execute once more. And once that is done, we can click Finish. Now essentially the most important parts of this installation were the server and workbench, but then ultimately, it's nice to have all the things so when we click Next, we'll see that we have the option to start my SQL workbench after setup so we can just leave that ticked and click Finish. And then you may see the installer come up with all of what was installed, you can close this so those are all of the things that were installed and from here we can reconfigure as in change, the configuration settings, the ports, etc. If we want we can also choose to modify or add more or remove Any previously installed one. Alright, so as new versions come out we have the installer which helps us manage our versions and we can upgrade at will.

Ultimately our goal was to see that our workbench was installed. And from here The next video will be to connect and start running some commands