REQUEST FOR SQL DATABASE

Question

I am currently on the get data module on power bi, I have been learning how to import data and then I have gotten to SQL relational database. for better understanding it would be good to have a SQL database to practices with. Is it possible to download the tailwind database or be given a databse to for studying. I have tired downloading the AdventureWorks Databse but it's not visible on my SQL STUDIO 22

This question is related to the following Learning Module

Answer 1

To practice with a SQL database in Power BI, you can download the AdventureWorks sample databases, which are commonly used for learning and testing purposes. If you are having trouble seeing the AdventureWorks database in SQL Server Management Studio (SSMS), ensure that you have restored the database correctly after downloading it. Here are the general steps to follow:

1. Download the AdventureWorks Database: You can find the AdventureWorks sample databases on the Microsoft SQL Server Samples GitHub repository.
2. Restore the Database: After downloading the database backup file, you need to restore it in SSMS:
   • Open SSMS and connect to your SQL Server instance.
   • Right-click on the "Databases" node in Object Explorer and select "Restore Database...".
   • Choose the backup file you downloaded and follow the prompts to restore it.
3. Check Visibility: Once restored, the AdventureWorks database should appear in the Object Explorer under the "Databases" node.

If you are looking for a different database like the Tailwind database, it may not be readily available as a sample database from Microsoft. You might need to create your own database or find other sample databases online.

Make sure that your SQL Server instance is running and that you have the necessary permissions to restore databases.

Answer 2

What you have downloaded is a backup of the database, not the database itself. You need to run a restore operation to have the database inside SQL Server:

RESTORE DATABASE AdventureWorks FROM DISK = '<path>AdventureWorks.bak'
WITH MOVE 'AdventureWorks' TO 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Data\AdventureWorks.mdf',
MOVE MOVE 'AdventureWorks_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Data\AdventureWorks.ldf'

Note that I had a to guess a little bit on some names here, so this exact command may not work out, but we will see.

There is also a UI in SSMS you can use, but I never use it myself to restore databases.