Install SQL Server Express 2019

now in this video we're going to download and install sql server express now don't worry about the term server you do not need a server to install it on any modern desktop or laptop that's a windows or a linux machine will be fine if you've got a macintosh then you'll need to somewhere to be able to use windows so either using parallel desktop or dual booting so the easiest way is just to type it in sql server and i'm going to type in express 2019 so the first thing we've got is a microsoft and i would recommend downloading it from microsoft address then you know you're not getting anything additional so let's have a look at the options now it starts off by saying we can download it on premises that just means on your computer or on a server the alternative is in the cloud that's azure microsoft's cloud product let's just scroll down download a free specialized edition so the developer edition is a really good thing it is something that gives you the power of the full enterprise edition without any of the cost slightly more difficult to install not hugely and if you are going to go on and look at ssis ssrs or ssas so this is sql server integration services reporting services or analysis services then i would use the developer edition right from the beginning because you will need that for those additional services if however what you want to learn is tsul so this is the select star from name of table what we're going to do now or if you want to have a look at some of database administration then i will download the express edition so feel free to download the developer edition if you want to do that then have a look at a youtube video of mine that is in the resource to this particular video as i say it's only slightly more complicated but for now i'm going to download the express edition which is a bit easier to install now just as a quick note this requires windows 8 or windows 10 with a 64-bit processor that's the majority of modern computers so if you're not sure then download this and see if it works if it doesn't work it will tell you so very clearly and then i will download sql server 2014 again i've got another youtube video for how to do that the link to that video is attached as a result to this video so click download now and you can see very quickly we have the boot strap as they call it a small bit that actually gets all of the files so we have got three different options basic with the default configuration custom or you can download the entire file and then install them on whatever machine you want now let's see what happens if you install with the basic configuration so you've got these terms and conditions that you have to read which basically says this is your software basically it's free software what do you expect so click accept where do you want it to be saved to well i'm going to save it to a slightly different location microsoft sql server 2019 express and click install and here you can see it's installing now let's just have a talk about some of the terminology that we've had we've got the express edition well there are multiple editions the express edition is this cut down version that's free you've got a developer edition which is a more expanded version that's free but can't be used in as many places you'll still be able to use it in your own computer for learning purposes but that's basically what the developer edition is for you've then got the paid four versions you've got the standard version and you've got the enterprise version and those can cost quite a lot of money so that's why we're using a free version now let's look at the 2019 bit well sql server the first edition i think was in 2000 and then there was a 2005 2008 and then the next one is a strange one 2008 r2 release 2. don't know why they didn't call it 2010 but they didn't do that in future they did 2012 2014 2016 you might think the next one would be 2018 but no they got one in 2017 and then 2019 so they'll generally release one every two years so now you can see that it has completed successfully now let's have a look at the bottom items connect now customize install ssms and close it's this third option i want you to have a look at ssms sql server management studio is your front window it's your user experience so at the moment you can't actually use sql server express edition easily you would have to have some program to connect to it so i'm going to install ssms so that takes me to another webpage and if for some reason you no longer see that dialog box and you can't click on the button just go to google and type in ssms and this will take you to the download page exactly the same page as we got previously and if you've just installed sql server using the custom installation you can also get to this page by restoring the window that we'd previously minimized and clicking on the link to ssms in this window so however you get here you see that ssms is free and it doesn't really matter what the latest version is it happens to be 18.6 at the moment but it will just keep on getting slightly better and you probably won't notice any of the differences so let's run that and here you can see it's downloading you take about six minutes on my version so just let it download right now it is downloaded it's asking for permission to make changes to my computer so i'm just going to say that's fine click install and it's now downloading the packages so this is your front engine this is the user interface that you will be using so now everything has been installed so click close so we've installed the back engine we've installed the front engine of sql server that's all the installation we need to do so now the only thing we need to do is to run sql server management studio now to run ssms we just go to your start menu so just to click here to search and just type in ssms so this is the latest version that i've installed version 18.6 so i'll just click on that and it starts to open so i can now close all windows that i've previously got open and here we are so this is the connection it needs to know that you have sufficient rights to be able to log into sql server after all those going to be a lot of data that you have on sql server and we need to make sure that the right person is doing this now as you have installed sql server express you have the right to whatever you want so you have administrator rights now what is your server name well it could well be localhost if you've just downloaded it on your computer alternatively it could be a dot a period a full stop now try one of those and see if it works and leave everything else the same database engine should be there windows authentication should be there if however you've got multiple sql servers then you'll need to select which one and i'd happen to have multiple sql servers i've also got the developer edition so i'm going to click on the drop down box and browse for more and i'll expand my local servers once on my computer the database engine and you can see here it has installed it as name of my computer slash sql express so click ok and connect and now i am connected to my sql express once you have done that that is the difficult bit of installing all done everything else that you wish to do regarding tsql or database administration can just be done in this program so let's have a quick look around on the left hand side we have the object explorer objects are things like databases tables views basically anything you create anything that sql server creates is an object and we can expand or collapse any of these nodes by just clicking on the plus or the minus button next to it so there are no databases in at the moment so we don't have anything there we don't have any of my user databases so we have security server objects replication polybase and management and quite frankly you don't need to have a look at those when you're just starting out in sql server it's this databases that you'll really be having a look at now we have a lot of menus and most of them you probably don't need when you have a finder replace and we have a go to a particular bit but most of them not necessary there will be some bits then you might be going oh i want to go into options and have a look at something there's also a lot of icons the vast majority of icons you will not need the ones you will need are new query and execute so having clicked on new query we get this new window and we can have as many quotes as we like it might get a bit complicated if you have so many queries that you don't know how to do them so this is when you type in your query so i'm just going to type in one of the most basic queries press execute and you get your results at the bottom so that's what a query window is and so it is new query and execute which are going to be the most important parts of this toolbar along with this one which also shows which database you are in so now we have successfully installed sql server back engine the front engine and we've opened and had a quick look around sql server management studio so now we can start learning how to use sql server well now we are in ssms that's almost it for this video coming up we'll have a look at the custom installation process but before we do that if you like this video why not click like and then why not click subscribe and check the bell and that's where you'll be informed of any new videos and now let's have a look at the custom installation process so let's click on the custom installation tab so where do you want it to download you can change that and then it downloads the installation package so we'll just skip over that for now so once the custom download has happened you then get the sql server installation center and it's this top one we want to go for the new sql server standalone installation it's also where you go if you want to add features to a sql server you've previously installed so if i click on it we can now minimize this window and the computer then make sure your computer is fine that it's got the latest version of things that it needs so you can see scan for product updates just checking everything's fine this windows firewall it gives a warning it just says it's there but i don't think there's anything you really need to worry about click next so do you want to perform a new installation of sql server or add features to an existing version if you've already got it so you can come back to this if you say getting the developer edition and you want to add ssis ssas ssrs any of these extra parts of sql server but we can't do that with the express edition anyway so i'm going to perform a new installation so i'll accept the license terms and the privacy statement again useful to read click next and then here is the main page what is it that you want to install and the computer has just checked a number of things so you can just leave it alone or you can say well i'm not going to do anything with r or python or java so i don't want the machine learning services in fact that's what i would do i would get rid of the machine learning services unless you're actually going to be using them sql server replication again i don't think i would use it that's just getting the objects the tables and so forth what you're going to store from one database to another we don't need it for necessarily for this level and full text and semantic extractions again i don't think we'll need so i'll just have this this is the important thing database engine services that is the core service for storing processing and securing data so as long as everything else is fine so this instance i'm going to change it to microsoft sql server 2019 express custom just because i can so click next it's now going to just check everything so we're going down this long list you can see where we are highlighted in bold so what's the name of this instance well i've already got some x installed on my computer so i'm just going to call it sql express custom click next and then it keeps on checking going down this list but that's the hard work done the hard work was in the feature selection so service account correlation i'm just going to leave as is collision just means what language rules are you got again windows authentication mode i'm just going to leave as is i'm going to leave all of this as is and in case you are not an administrator you can click on add current user but you should be an administrator which means you have unrestricted access to the database engine so that doesn't mean that you have unrestricted access to the computer it just means you have restricted access to sql server so click next and then it installs and hopefully will install fairly easily and there you go it's all installed so just click close and it's done you

Channel: SQL Server 101

Views: 83,452

Rating: 4.9098287 out of 5

Keywords: SQL Server, SQL Server Express, SQL Server 2019, SQL Server Management Studio, SSMS, Install SQL Server, Download SQL Server, Download SSMS, sql server installation, how to install sql, sql, install sql server 2019, how to install sql server on windows, install ssms, how to install microsoft sql, install microsoft sql, microsoft sql server, install t-sql

Id: LIytfaWH_10

Length: 16min 15sec (975 seconds)

Published: Wed Sep 16 2020