Locked lesson.
About this lesson
We will install and setup SQL Server Management Studio.
Exercise files
Download this lesson’s exercise file.
Setting Up Microsoft SQL Server Management Studio.docx58.8 KB
Quick reference
Setting Up Microsoft SQL Server Management Studio
SSMS provides the interface that allows us to work with our databases.
When to use
Anytime you want to use SQL Server, you'll use SSMS.
Instructions
Download the free SSMS from the link that appears on the pop-up box after you installed SQL Server. Or Google it and download it from the official Microsoft website.
SSMS is what we will be using to work with our databases and write our SQL.
Hints & tips
- SSMS is the main tool we'll use throughout the course.
- It interfaces with our Database and allows us to do everything we need to do to work with our database.
- You'll need to restart your computer after you install SSMS.
- 00:05 Okay, in the last video we installed SQL Server 2016.
- 00:08 In this video we're going to install SSMS, which is stands for
- 00:12 SQL Server Management Studio.
- 00:14 And SSMS is the thing you're going to use.
- 00:17 It's the thing you'll open up and create databases, edit databases,
- 00:21 add information, or move information,
- 00:23 run your SQL commands, do all the stuff that you're going to be doing.
- 00:25 You are going to be using SSMS to do that.
- 00:27 So, the SQL server itself just kind of runs in the background.
- 00:31 It's installed on your computer.
- 00:32 It handles all this stuff behind the scenes.
- 00:34 SSMS is the thing that you'll use.
- 00:36 So this is the last screen that we had when we installed SQL Server, and
- 00:40 you see there's this button, install SSMS.
- 00:42 So, if we click on that,
- 00:43 it'll bring us back to the website where you can read a little bit about it.
- 00:46 But we just really want this download link, so I'll go ahead and click that.
- 00:50 And like before, I'm just gonna save it to my desktop.
- 00:53 You can save it anywhere.
- 00:54 And this is a bigger file.
- 00:56 This is 729 megabytes, so quite a bit bigger than the last one.
- 01:00 If you're on a slower connection it's gonna take a while to download.
- 01:02 I'll just pause the video while this downloads so
- 01:05 we don't have to stare at this screen the whole time.
- 01:07 Almost there, and I should mention that SSMS is free.
- 01:10 That's right there, download it below.
- 01:12 We're downloading version 17.0.
- 01:13 By the time you watch this video, they may be on a different version.
- 01:17 Doesn't really matter what version they have listed there.
- 01:19 Just go ahead and download.
- 01:20 Whichever one they have listed is gonna be the most up-to-date version.
- 01:23 And if you look through here, you can read, if you're into release notes,
- 01:27 you wanna see what's new over the last one, if that sort of thing interests you.
- 01:31 You can go through and look at all of that.
- 01:32 I tend to ignore all that stuff most of the time.
- 01:35 Okay, so we've downloaded this file.
- 01:37 Now to install this thing, you can, just like in the last video,
- 01:40 either click this link right here or navigate to your desktop wherever you
- 01:43 downloaded this, and you'll see a little icon.
- 01:45 You can double click it.
- 01:46 The icon says SSMS.
- 01:48 It's very obvious.
- 01:49 But I'm just going to click this right here.
- 01:51 Okay. So we have this installation screen here.
- 01:55 Just go ahead and click Install.
- 01:56 And like in the last video, if it asks you any questions along the way,
- 01:59 you're usually gonna wanna go with the default, so just keep clicking Next.
- 02:02 In this case, it didn't ask us anything, just started installing.
- 02:06 So like in the last video, this can take a little while to install.
- 02:09 Depends on your system.
- 02:10 You can see we have this little taskbar thing that tells us how long it's taking.
- 02:14 Seems to be speeding right through it though.
- 02:15 Just gonna depend on how quick your computer is, what kind of memory and RAM,
- 02:19 and all that good stuff you have, how many megawhozits and what not.
- 02:22 And if you look at the package progress at the top, you can see like right now it's
- 02:25 installing Microsoft Visual Studio Tools for Applications 2015.
- 02:29 Microsoft SQL Server Uses all kinds of stuff, a lot of Visual Studio type things.
- 02:35 And Visual Studio is sort of like Microsoft's programing language IDE, and
- 02:39 so it's kind of interesting that it's installing all those things.
- 02:43 So moving right along.
- 02:45 You get this little message at the end that says a restart is required.
- 02:48 I'll go ahead and do that at the end of this video.
- 02:50 But that's pretty much it.
- 02:51 We've now downloaded and installed all of the tools that we need.
- 02:54 In the next video we'll fire this thing up, and we will connect to a server and
- 02:58 look at the object explorer.
- 03:00 In the meantime, I'm going to restart my computer
Lesson notes are only available for subscribers.