Sample database

Question

Which sample database is used in the T-SQL training? Can it be downloaded. The sample queries are not working on the AdventureWorks2022

This question is related to the following Learning Module

Answer 1

Hi @Joshua Bolaji

Just to elaborate in detailed steps-

To download a SQL database for practice and learning, you can download the AdventureWorks sample database from Microsoft's website. The AdventureWorks database is a sample database that is used in many Microsoft tutorials and is a great way to practice working with SQL.

Here are the steps to download the AdventureWorks database:

1. Go to the AdventureWorks download page.
2. Scroll down to the "AdventureWorks Databases and Scripts for SQL Server 2016" section.
3. Click the "AdventureWorks2016.bak" link to download the backup file.
4. Once the download is complete, you can restore the database backup file to your SQL Server instance using SQL Server Management Studio (SSMS) or any other tool that supports restoring SQL Server databases.

I hope this helps! Let me know if you have any other questions.

Thank You

Answer 2

https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms