Sample database

Joshua Bolaji 0 Reputation points
2024-04-25T14:54:43.12+00:00

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

Azure Training
Azure Training
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Training: Instruction to develop new skills.
942 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bruce (SqlWork.com) 56,766 Reputation points
    2024-04-25T15:00:55.6966667+00:00
    0 comments
  2. Rahul Randive 8,521 Reputation points Microsoft Employee
    2024-04-25T18:50:27.2366667+00:00

    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

    0 comments