You have many options available to you, when choosing how to learn about SQL Server. zip file contents to a folder on my c:\ drive.Īll that I need to do then is restore the database - If you need to know how to do that watch the video - its starts at around 4:10 zip that contains the backup and extracted the. You mentioned that you had a backup file of the adventure works 2014 database so I’ll assume you got the. I have included the links to both locations below CodePlex is still available in read-only mode up until December this year so you can still get it the sample databases from there up until that time. Earlier in the year – around 1st April 2017 it was announced that CodePlex would be closing and all the Microsoft open source tools moved to GitHub. Microsoft used to make all their sample databases available via its CodePlex website.
Install that including the features that you want to learn – from the email it sounds like you would Analysis Services, Integration Services and Reporting services then you can use the features available in the products Sample Databases – AdventuresWorks I would recommend you get SQL Server 2016 developer edition – for free. You can read more about the comparison of the various SQL Server editions here SQL Express has a very limited set of features and has almost no Business Intelligence applications. But for the purpose of learning all about SQL Server ‘inside out’ it is ideally. You can’t for example use it in production. Developer edition of SQL Server has all the features SQL Server has to offer…Its like enterprise edition but there are restrictions on where you can use it. Prior to that there was a fee of around $50 for a developer license. If you want to learn SQL Server inside out including the Business Intelligence suite of applications I would suggest downloading the developer edition of SQL Server which since 2016 has been made available free of charge.
SQL Server Express v SQL Server Developer Edition