How To Install SQL Server 2019 (with Sample Databases)

Here we look at how to download and Install SQL Server 2019. I've also included where we can get sample databases from so we can run a few queries once we've setup SQL Server.

The tutorial covers how and where to browse for SQL Server Installation media, and in this case its a simple download for either SQL Server Developer Edition or SQL Server Express ( both full downloads). We use Developer here as it has all the SQL Server features and its completely free. You can follow the same instructions in this tutorial for SQL Server 2014 or 2016 as the basics are exactly the same.

We also cover how to Download and Install SQL Server Management Studio (SSMS). This is needed so we can access, query and maintain SQL Server. Again this is a free download from Microsoft and this tutorial covers how to download the latest version.

Once SQL Server is downloaded, installed and configured we will need a database to download and restore. So in the latter part of the tutorial we go over how to download and install AdventureWorks database to be used with SQL Server. From here on in, you should have everything you need to get started with SQL Server!

Content:

00:00 Introduction
00:37 SQL Server 2019 Download
02:13 Install SQL Server 2019
05:20 SSMS Download
06:16 Install SSMS
07:42 Sample Database Download
09:33 Restore a Database

[Mike-lmii]

Great video dude. I've been looking for something like this all day. What video would you recommend after it's setup? Also, do you have a video where you're actually pulling data from the table you downloaded? Thank you again!

[stephenogunkunle]

I cannot restore the sample data. not sure if its because I downloaded the SQL 2022 version.