Opening SQL Server Management Studios (SSMS)
A free video tutorial from Phillip Burton
Best Selling Instructor - over 350,000 students so far
4.5 instructor rating • 49 courses • 365,341 students
Learn more from the full courseMicrosoft SQL Server - An Introduction (2018 edition)
A quick tour of T-SQL, DBA and SSRS (all part of Microsoft SQL Server)
02:18:44 of on-demand video • Updated September 2021
- Either Download and Install SQL Server Express on your computer - for free
- or Download and Install SQL Server Developer, which used to cost US$100, for free - a full version for personal use only.
- Log in and create a database.
- Create a table and insert data
- Retrieve the data contained in your table.
- Learn about the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses.
English Instructor: Now we've got our SQL server installed, let's start using it. Now, if I go to Start and I have a look through Microsoft SQL server, whichever version you installed, you will notice quite quite a lot of programmes. You might be going, "Oh, which one do I actually start with?" Well, what we need to start with is a programme called SQL Server Management Studio. And you can see the quickest way that I found it on my system is just typing SSMS. So, if I now run this programme, so, here comes SQL Server Management Studio, this is where you do a lot of work with TSQL, which is your standard SQL server called the Select Statement, which is what we'll be looking at in the next few videos. This is also where we do DBA: Database Administration. So, first of all, we have it connect to a server. Now, your server name will be completely different, but what's important is it says server type, database engine. Server name, whatever the server name that you've installed, and authentication, Windows Authentication. And I just click connect. I ignore all the other options. So, hopefully you've now found on your computer SQL Server Management Studio. You might have to search for it, especially if you've got an older version of Windows. Now, just in case you got to this screen you click connect, and maybe server name was blank. If server name is blank, then my suggestion is to put a period, a full stop, a dot as your server name. And that will allow you to connect to your local server. But generally, just accept whatever was there as your default. Obviously, if you're connecting to a corporate machine, then some server that's already been installed, that's worth tens of thousands of dollars, then use whatever credentials you were given by your system administrator. So, this is SSMS, SQL Server Management Studios. And let's just have a look around it. First of all, we have an Object Explorer. Now, if you don't see this object explorer, if it's disappeared, then go to View, and Object Explorer. Now, this contains all of the objects that we are going to be using in this TSQL and in the DBA section of this course. So, we start off with databases. And if I expand that, then we have System Databases and any databases that may have previously been installed. You can see that I've got a few databases installed. But, we're going to ignore all of my existing databases and concentrate on a new database. First of all, what is a database? A database is a object, a container that can hold other objects. It can hold data, it can hold queries, it can hold procedures, and in this course we're going to make all of those. So, first of all, we need a database container. So, what I'm going to do is right-hand click on the word Databases and go to New Database. Now, we can call this database almost anything we want, within reason. So, I'm going to call it My First Database, without any spaces. So, I'm going to leave everything else as it is. This is just a test environment. I don't need to concentrate on any of these tabs or other options that get really complicated very quickly. So, let's just ignore that and just click OK. So, once we've done this, in the Object Explorer, the phrase My First Database has appeared, it's right here. Now, if I expand this new database, we've got Tables, Views, which hold queries, and in Programmability we've got stored procedures. And we'll be concentrating on these later. Within Tables, we have got System Tables. Within Views, we've got System Views. And there's actually quite a lot of them, to be honest. So, all of this is just the outline of our database, it doesn't actually contain any data. So, in the next video, we are going to create a table and we're going to populate it. We're going to add some data into it.