How to install sample data (from AdventureWorks) on your SQL Server

Published: 20 November 2020
on channel: SQL Server 101
36,694
514

In this video, we'll have a look at how to install sample data on your SQL Server.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: https://rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): https://rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): https://rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): https://rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): https://rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): https://rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpiv...
----
Do you want to have some sample data to play with on your SQL Server?
The good news is that Microsoft has released a set of sample data called AdventureWorks.
The bad news is that Microsoft keeps changing its location.
In this video, I'll show you how I find the current location. We'll also find out which version of AdventureWorks you should NOT install (if you are not running the latest version of SQL Server), and then how to install it.
I cover backup and restore more in depth as part of my 98-364 course (https://rebrand.ly/database-fundamentals ). Why not check out that course, or any of my courses, on http://www.filecats.co.uk ?


Watch video How to install sample data (from AdventureWorks) on your SQL Server online, duration hours minute second in high quality that is uploaded to the channel SQL Server 101 20 November 2020. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 36,694 times and liked it 514 visitors.