How to Install Microsoft SQL Server Express

Brewster Knowlton
A free video tutorial from Brewster Knowlton
Business Intelligence Expert
4.6 instructor rating • 2 courses • 74,522 students

Learn more from the full course

Microsoft SQL from A to Z

The Complete Guide to SQL Querying

05:41:46 of on-demand video • Updated December 2020

  • Complete literal SELECT statements.
  • Complete basic SELECT statements querying against a single table
  • Filter data using the WHERE clause
  • Sort data using the ORDER BY clause
  • Learn about database design and normalization
  • Using joins, return columns from multiple tables in the same query
  • Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
  • Complete SQL statements that use aggregate functions
  • Group data together using the GROUP BY clause
  • Filter groups of data using the HAVING clause
  • Use built-in SQL Server functions
  • Understand SQL Server Data Types and Type Casting
  • Work with Table Expressions: Derived Tables and CTEs
  • Use CASE Statements
  • Use Subqueries
English [Auto] So many of you have asked me to create a video to show how you actually set up SQL Server and load the database and do all of that. So I wanted to take the time to actually create that. There's been a ton of questions that have come into the Q&A section or directly messages, a direct message to me through you, to me. So I wanted to take the time to to go through and show you that. So I just downloaded. I haven't installed, but I've just finished downloading SQL Server two thousand twelve Express and I also downloaded. The adventure works 20 12 data via the link that I provided to you all in the course. So I'm just going to extract that now. They should be able to minimize at least. So it is an empty file, so as I say in the instructions, I want you to copy that or you can move it, but I'm just going to copy it for the sake of simplicity. You're going to go to the C Drive program files. Excuse me, that's not right. Program files. Eighty six. Right, so we've extracted the adventurous data, just going to kind of hold on to that for now until we install SQL Server. OK, so I'm going head back to my download section and I'm going to execute. The installation. You'll hear. Take its time extractor. When this comes up. And there's a lot of thinking throughout this process. Just be patient. I'm also running on a on a remote van that is not the most powerful. So it might take a little bit longer than it may on your machine, but you do want to notice that this will pop up. That's a good thing. So I'm going to click on new SQL Server standalone installation or add features. And do this, we will check. So for any issues, sure that you're working on the right. System settings and that there's some basic checks that are being done. Look, I accept you can choose to send feature data usage if you'd like us next. And it may ask you to install with some product updates that are found online, I just leave that as is and next shouldn't be anything too crazy. Finally comes to extracting them, installing the optics. Again, if you're getting a newer version of sequel, you may have to you may not have to wait as much older versions, maybe some service packed updates dates may have to add some more information and a little bit longer to update. OK. So in this next part, we want to make sure that management tools. And database engine services are at a minimum selected, you can leave your client connectivity SDK as is next. Let's leave the name instance as the default name. Changing that is going to make a little bit more difficult to remember some things, I just always the default instance for local settings for an installation in a corporate environment that's different, but for this purpose of learning and things like that, just stick with it. For instance, just click next. Again, stick with the default settings. Now on this screen. If your username. He's not added to this list. When you get to this step, be sure to click add current user. So if you're not here when you get to the screen, automatically be sure to click add current user and then just simply post next. You can choose to send windows if there are issues, but this is just to kind of show you, so I'm just going to leave it as is and next. It's going to do a last little look, which was the step, and then it's just going to start and start. So barring any issues which are rare, if you get to this point, there's usually some rules have already been checked. So you should be ready to go and it should just continue to install at this point. So I'm not going to have you watch this whole thing and stop. But again, if you got to this point, you should be good to go and it should be able to install on your end. So in the next section, I'm going to come back and show you how to get everything started for the first time and load the sample database that we're working with.